I have a [status] name column
- Status "Done"
- Status "Not Done"
- status "waiting"
I want to show the edit icon by status
Solved! Go to Solution.
Use can use OR() AND() as per your requirement
e.g. OR([Status]="waiting",[status]="not done")
Make the Edit Action Display Overlay or Display prominently and in the Only if this condition is true you can give
[Status]<>"Done"
or other condition as per your requirement
Thank you... But what is meant is the show / hide requirement
Edit button based on record status
1-"Done" - hide the edit button
2-"Not done" - Show edit button
If you give this condition
[Status]<>"Done"
in the "ONLY IF THIS CONDITION IS TRUE" field for EDIT ACTION, then the EDIT button will only be visible for those ROWS with Status not equal to DONE
If I had more than one condition... What is the formula
Use can use OR() AND() as per your requirement
e.g. OR([Status]="waiting",[status]="not done")
Maybe this can help:
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Prevent-certain-records-from-being-deleted/m-p/...
You can use it to update too.
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |