Hi everyone
I am trying to keep the date as the original date when I selected 31/oct/66 and saved. It comeback and i will select date again so i don't want select it again i want date “31/oct/66
If understanding of your requirement is correct, it sounds that you do not want the date column to be editable once a record is created and added. If so, one way to do this is to add an expression something like
NOT(IN([_THIS], Table_Name[Date])) in the editable_if setting of the [Date] column.
Conditionally allow column edits (Editable_If) - AppSheet Help
It worked but there was one thing I miscommunicate with you.
I want to have any date that I can choose not just Now() and not have to comeback and press the date again.
Thank you for posting that additional requirement. Your NOW() expression seems to be at App formula setting of the column.
If so, please remove any expression from the app formula setting.
Please add an expression of TODAY() or leave it blank in the " initial value" setting. In that case the form will open with today's date but the user can change the date as she/ he wants. Thereafter once the form is saved, the user entered date will not change.
Define app formulas and initial values - AppSheet Help
User | Count |
---|---|
37 | |
31 | |
28 | |
22 | |
18 |