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

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

0 3 368
3 REPLIES 3

tony1
Participant V

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

tony1
Participant V

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

Top Labels in this Space