Change a database value based on a timer

jameshhenry · 2021-01-05T18:19:55.814Z

Hello everyone,

Currently I am trying to change a database value on the backend of the database and not through the front end UI. As an example I am trying to change a status value from “New” to “Open” after a certain amount of time has pasted on a record (i.e. 3 days). I have researched this a bit and I think I need to use a workflow / trigger but I’m not 100% certain. Would love to get your thoughts on how best to do this.

Thanks,
Jim

adamhholmes · 2021-01-05T18:44:09.768Z

The simplest way is just to schedule a backend workflow to run 3 days after the record is created, with an action to change the Status field from New to Open.

jameshhenry · 2021-01-05T22:57:44.672Z

Thanks for the recommendation Adam, unfortunately I think I’m having a brain fart.

I can’t really see how best to write this change from New to Open. Below is where I’m at so far.

Any thoughts would be appreciated.

image878×356 48.4 KB

adamhholmes · 2021-01-05T23:09:20.742Z

Assuming your ‘Status’ field is a text type, then you just need to type ‘Open’ in the status field (where it currently says New in your image above). Or if it’s an option from an option set then just select Open from the menu when choosing the option.