Change a database value based on a timer

Need help Database
1

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

1 Like
2

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.

3

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.

image
image878×356 48.4 KB

4

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.