Work Order Creation and Completion

[Rick1]

Maybe it’s not possible. I’m trying to setup a work order with data that is locked, and other data that can be completed and then “closed” within the work order. Some of the data, if edited after we enter it on the front end, will render the work order useless if it’s changed.

[Steve]

help.appsheet.com

Control Whether and When a Value Can be Edited in a Form

Design pattern to ensure that a form input can only be changed in specific circumstances.

help.appsheet.com

Editable_If Column Constraint

Conditionally allow the user to edit a column value.

help.appsheet.com

Controlling Add, Update, and Delete

How to determine how much your app users can modify data.

help.appsheet.com

Limiting Users to Their Own Data

You can use Security Filters to control which records a user can see and update.

[Rick1]

Would I able to complete these setups for testing under a free account, or would this need to be an upgraded account?

[Marc_Dillon]

You’ll be able to setup all of your table and column permissions with a free account.