Change field status automatically after a period of time

AppSheet AppSheet Q&A
1

Hey everyone,

Based on the date field
How can I put an expression
For the record that is two years old, the status of the field (Activation) changes from “Active” to “Inactive” automatically

2

You will have to use a combination of a scheduled automation which checks the condition, then calls an action to update the column.

2 Likes
3

It works great
Thank you JPAlpano

2 Likes