Is there a way to make a row editable if (condition)?

AppSheet AppSheet Q&A
1

Hello!

I’d like to know if I can make an entire record be editable only if a certain condition is true. For example: I want my users to be able to add records and be able to edit them up to 7 days after adding.

I know I can do that in a per-column way. Is there any way to do this for the whole row?

2

Provided you have a datetime/date column in your table, for sure it’s possible.

1 Like
3

I tried to create a slice of the table with only records older than 7 days and marked it as “Read Only”. When I click on “View Data” it shows only the desired records, but the app still allows me to edit it these records.

4

No need for the slice. Just enter an expression for the Only if this condition is true property of System Edit action for that particular table:

TODAY() - [Date] <= 7

or

[Date] + 7 <= TODAY()

or

[Date] <= TODAY() - 7
2 Likes