It would be a common practice in many scenarios, that a user should not be able to edit a (Employee-Name-)field while editing a record/row, and he should be able to edit(=add) a (Employee-Name-)field, while adding a new record.
But in Appsheet, when I change the (name)field to editable in the data, that field becomes editable in the form, where I don't want the user to edit it, during editing.
If I make it un-editable, I am unable to add the name in a 'add new employee' form.
How to handle this situation?
(I want to achieve this on separate edit, add-new forms, not on edit-in-place forms.)
Solved! Go to Solution.
Use NOT(IN([KeyColumn],Tablename[KeyColumn])) with the Editable?. It allows you to edit the record when it's not saved to datasource yet = adding new record.
Use NOT(IN([KeyColumn],Tablename[KeyColumn])) with the Editable?. It allows you to edit the record when it's not saved to datasource yet = adding new record.
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |