Lock down some fields

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
eagle
Posts: 25
Joined: 2013-01-09 15:38

Lock down some fields

Post by eagle » 2015-12-11 14:37

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.

User avatar
a.gneady
Site Admin
Posts: 1107
Joined: 2012-09-27 14:46
Contact:

Re: Lock down some fields

Post by a.gneady » 2015-12-14 04:31

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.
:idea: Calendar plugin: Organize your data into beautiful calendars.
:arrow: Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
:arrow: Summary Reports plugin: Build powerful reports and charts for your AppGini apps.
:arrow: Search Page Maker: Compose user-friendly yet powerful search pages for your AppGini apps.

eagle
Posts: 25
Joined: 2013-01-09 15:38

Re: Lock down some fields

Post by eagle » 2015-12-14 10:29

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?

User avatar
a.gneady
Site Admin
Posts: 1107
Joined: 2012-09-27 14:46
Contact:

Re: Lock down some fields

Post by a.gneady » 2015-12-15 10:20

This issue was fixed in AppGini 5.50, released today :)
:idea: Calendar plugin: Organize your data into beautiful calendars.
:arrow: Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
:arrow: Summary Reports plugin: Build powerful reports and charts for your AppGini apps.
:arrow: Search Page Maker: Compose user-friendly yet powerful search pages for your AppGini apps.

eagle
Posts: 25
Joined: 2013-01-09 15:38

Re: Lock down some fields

Post by eagle » 2015-12-15 12:15

Thanks, Ahmad.

That worked much better :)

Post Reply