In the app order capture, I wish that details...

references
(German Sarmiento) #1

In the app order capture, I wish that details can not be added to a canceled or finalized order, how can I do this?

(Tony Fader) #2

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

(German Sarmiento) #3

@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

(Tony Fader) #4

@German_Sarmiento It might be easier to create slices for the different categories of orders. Slices can have their own update permissions.