Hi,
I'm anxiously waiting for the next release, as there are a number of security issues in versions up to 5.70. When can we expect the next release where the security issues will be addressed?
Next release due?
Re: Next release due?
The security issues you reported won't make it to AppGini 5.71 unfortunately as we wish to publish it next week .. but we'll do our best to fix them in AppGini 5.72 hopefully mid May.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
-
- Posts: 2
- Joined: 2018-05-02 09:47
Re: Next release due?
Hello,
Can you reactivate the option "Show column sum" with Lookup field? Maybe in the next release? Please
I read somewhere in the forum that it will appear in .72, but I was not lucky this time.
I need it to calculate a price for services from another table. Or does it work with summary reports and I was not careful?
(sorry for my English, I use google translate, a little)
Best
Cristi
Can you reactivate the option "Show column sum" with Lookup field? Maybe in the next release? Please
I read somewhere in the forum that it will appear in .72, but I was not lucky this time.
I need it to calculate a price for services from another table. Or does it work with summary reports and I was not careful?
(sorry for my English, I use google translate, a little)
Best
Cristi
Re: Next release due?
Sum of lookups does work in summary reports plugin. But we'll also try our best to implement it in future releases of AppGini as well.I need it to calculate a price for services from another table. Or does it work with summary reports and I was not careful?
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: Next release due?
Hi cmoldoveanu,
This is not so difficult to achieve.
Let´s say that you have a table called products: and fields like: id_product, name_product and price_product
And lets say that you have another table called inventory and in this table you have the fields: name_inv and price_inv as lookup fields from table products. Instead of price_inv been a look up field, you make that field a normal field with data format decimal, and write the next code in inventory.php hook file:
function inventory_before_insert(&$data, $memberInfo, &$args){
$id_product = $data['name_inv'];
$data['price_inv'] = sqlValue("SELECT name_product FROM products WHERE id_product = '$id_product' ");
return TRUE;
}
function inventory_before_update(&$data, $memberInfo, &$args){
return iinventory_before_insert($data, $memberInfo, $args);
return TRUE;
}
This is not so difficult to achieve.
Let´s say that you have a table called products: and fields like: id_product, name_product and price_product
And lets say that you have another table called inventory and in this table you have the fields: name_inv and price_inv as lookup fields from table products. Instead of price_inv been a look up field, you make that field a normal field with data format decimal, and write the next code in inventory.php hook file:
function inventory_before_insert(&$data, $memberInfo, &$args){
$id_product = $data['name_inv'];
$data['price_inv'] = sqlValue("SELECT name_product FROM products WHERE id_product = '$id_product' ");
return TRUE;
}
function inventory_before_update(&$data, $memberInfo, &$args){
return iinventory_before_insert($data, $memberInfo, $args);
return TRUE;
}
-
- Posts: 2
- Joined: 2018-05-02 09:47
Re: Next release due?
@wilmira
Thank You for effort but it is not working. First I do it with my data, and I have a white page, no errors, and second time I built a fresh app with tables and fields suggested, but I have the same result. I don't know what to do anything else but wait the next version with lookup fields sum working. Now I keep the evidence on excel, and it is a mess This is what I need from app: we have a therapy salon where kinesitherapists are employed that provide several categories of services. We need to make appointments for clients and know how each kinetotherapist worked. I thought that if I have the total price of the services on programming page, I can filter after the employee and find the total amount of services rendered by him / her. But as the lookup field does not work, I'm stuck in working with excel
Thank You
Best
Cristi Catalin
Thank You for effort but it is not working. First I do it with my data, and I have a white page, no errors, and second time I built a fresh app with tables and fields suggested, but I have the same result. I don't know what to do anything else but wait the next version with lookup fields sum working. Now I keep the evidence on excel, and it is a mess This is what I need from app: we have a therapy salon where kinesitherapists are employed that provide several categories of services. We need to make appointments for clients and know how each kinetotherapist worked. I thought that if I have the total price of the services on programming page, I can filter after the employee and find the total amount of services rendered by him / her. But as the lookup field does not work, I'm stuck in working with excel
Thank You
Best
Cristi Catalin
Re: Next release due?
Hi,
maybe you can post a little bit more information on what you have and what you try to acheive (with samples). So we can try to help on the specifix issue.
maybe you can post a little bit more information on what you have and what you try to acheive (with samples). So we can try to help on the specifix issue.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Next release due?
Sory cmoldoveanu,
There is error in my code:
Try this:
function inventory_before_insert(&$data, $memberInfo, &$args){
$id_product = $data['name_inv'];
$data['price_inv'] = sqlValue("SELECT price_product FROM products WHERE id_product = '$id_product' ");
return TRUE;
}
function inventory_before_update(&$data, $memberInfo, &$args){
return iinventory_before_insert($data, $memberInfo, $args);
return TRUE;
}
It is the same code, just that the Seclect field should be price_product instead of name_product
There is error in my code:
Try this:
function inventory_before_insert(&$data, $memberInfo, &$args){
$id_product = $data['name_inv'];
$data['price_inv'] = sqlValue("SELECT price_product FROM products WHERE id_product = '$id_product' ");
return TRUE;
}
function inventory_before_update(&$data, $memberInfo, &$args){
return iinventory_before_insert($data, $memberInfo, $args);
return TRUE;
}
It is the same code, just that the Seclect field should be price_product instead of name_product
Re: Next release due?
Hi wilmira,
is the double i in
is the double i in
correct?return iinventory_before_insert($data, $memberInfo, $args);
With regard,
Debenkumar Naorem
Debenkumar Naorem
Re: Next release due?
Hi dnaorem,
No, my mistake. Only one "i" is correct.
No, my mistake. Only one "i" is correct.