# Change a database value based on a timer

**URL:** <https://forum.bubble.io/t/change-a-database-value-based-on-a-timer/129071>\
**Category:** Database\
**Created:** [January 5, 2021, 6:19pm UTC](https://forum.bubble.io/t/change-a-database-value-based-on-a-timer/129071 "2021-01-05T18:19:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jameshhenry](https://avatars.discourse-cdn.com/v4/letter/j/898d66/32.png) [@jameshhenry](https://forum.bubble.io/u/jameshhenry)\
**Post date:** [January 5, 2021, 6:19pm UTC](https://forum.bubble.io/t/change-a-database-value-based-on-a-timer/129071/1 "2021-01-05T18:19:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [January 5, 2021, 6:44pm UTC](https://forum.bubble.io/t/change-a-database-value-based-on-a-timer/129071/2 "2021-01-05T18:44:09Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jameshhenry](https://avatars.discourse-cdn.com/v4/letter/j/898d66/32.png) [@jameshhenry](https://forum.bubble.io/u/jameshhenry)\
**Post date:** [January 5, 2021, 10:57pm UTC](https://forum.bubble.io/t/change-a-database-value-based-on-a-timer/129071/3 "2021-01-05T22:57:44Z")

</div>

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](https://us1.discourse-cdn.com/bubble/original/3X/c/8/c82e999dd8da94f5c52e6c5769f1f6b32782ddb0.jpeg)

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [January 5, 2021, 11:09pm UTC](https://forum.bubble.io/t/change-a-database-value-based-on-a-timer/129071/4 "2021-01-05T23:09:20Z")

</div>

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.