1. In the Northwind demo I create a new order.
2. I then click "Order items" to add items to this new order
Please consider the following questions:
A) Is is possible to "lock" the order ID field?
When adding order items it is now possible to select other order ids. Can this be locked down, so that I can only add items to the order in #1 above?
B) Also, could we see the order details ( customer name etc ) on screen when adding order items?
Thanks for all help.
Lock down some fields
Re: Lock down some fields
You can set the order ID field as read-only in order details. That would effectively lock it.
To show the customer name in order details, you could add a lookup field in the order details table, with parent table set to orders, parent caption field set to customer name, and 'Auto fill' checked. You can add other customer info in the same way.
To show the customer name in order details, you could add a lookup field in the order details table, with parent table set to orders, parent caption field set to customer name, and 'Auto fill' checked. You can add other customer info in the same way.
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: Lock down some fields
Hi Ahmad,
Thanks for answering.
>You can set the order ID field as read-only in order details. That would effectively lock it.
I tried that, but then the field does not save. When adding a new item the order ID shows correct as read only field, but in database it is stored as NULL?
Thanks for answering.
>You can set the order ID field as read-only in order details. That would effectively lock it.
I tried that, but then the field does not save. When adding a new item the order ID shows correct as read only field, but in database it is stored as NULL?
Re: Lock down some fields
This issue was fixed in AppGini 5.50, released today
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: Lock down some fields
Thanks, Ahmad.
That worked much better
That worked much better