User control

am developing a form but i dont want the user to edit after pressing savedโ€ฆany help pls

0 3 218
3 REPLIES 3

Here is a possible option:

Add a column to your spreadsheet called โ€œStatusโ€.
Regenerate your table
Make this row hidden (uncheck the โ€œShowโ€ option)
Make the initial value = โ€œEditableโ€
Make sure the column does not reset on edit
Go in each row, and make the Editable expression = [Status]=โ€œEditableโ€
Create an action that changes data in this row
Select the column โ€œStatusโ€, and put in the value โ€œNot editableโ€
Go to UX < Views, and search for the _Form view of your table
Go to โ€œBehaviorโ€ in this view
Add the action to be triggered when the form is saved
Now, it will be editable only the first time.

Another possibly easier option:
Go to behavior > Actions
Find the system Edit button for that table view
Show it only if your first column ISBLANK: ISBLANK[Column 1]. That way, when you save, the column will not be blank, the expression will return false, and the edit button will not show when the first column has been filled out.

THX SO MUCH WORK LIKE MAGIC

Steve
Platinum 4
Platinum 4

Perhaps just hide the system-generated Edit action? Or set its Only if this condition is true expression to FALSE?

Top Labels in this Space