In the app order capture, I wish that details can not be added to a canceled or finalized order, how can I do this?
Hi @German_Sarmiento. You can add a validation rule to the Order column in your details table that checks the order status. It would look like this:
[Order Id].[Status] = โOpenโ
See these articles:
https://help.appsheet.com/expressions/using-expressions/valid_if-column-constraint
help.appsheet.com - Dereference Expressions Dereference Expressions help.appsheet.com
@tony thank you for your help, I have already thought about it, however the ideal is that the table order details will be read only when the order is closed or canceled
@German_Sarmiento It might be easier to create slices for the different categories of orders. Slices can have their own update permissions.
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |