I have a main form for tracking progress in a construction project. The user selects the building and then specifies the completed task. After that, they proceed to a subform to enter details such as the floor and the completed quantity, with the ability to input data for multiple floors within the same task.
The issue I am facing is that when users review their previous entries, they can edit or add new data to the subform. I want to completely prevent them from making any modifications or additions, allowing them only to view their past entries without any ability to change or add new records.
How can I achieve this in AppSheet? Thanks in advance for your help!
You want to add a “lock” column..maybe named [Locked?]. Then update each data column to NOT Editable when [Locked?] is TRUE.
If the current process allows for the user to re-edit the row multiple times before they are finally done, then you will need to have the user apply the lock on their final edit.
If your process expects the row to be fully completed on the first edit, then use an action to apply the lock automatically.
When the row is locked, the [Locked?] column is not shown. However, there will be occasions when a user makes a mistake and the row will need to be unlocked for correction. You can add a admin feature to unlock the row, the user edits and then the row gets re-locked.