# Automatically Modify a Row in Glide Database When a Specific Date is Reached **URL:** \ **Category:** Ask for Help\ **Created:** [May 16, 2024, 2:36pm UTC](https://community.glideapps.com/t/automatically-modify-a-row-in-glide-database-when-a-specific-date-is-reached/73433 "2024-05-16T14:36:16Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![LVaurie](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@LVaurie](https://community.glideapps.com/u/LVaurie)\ **Post date:** [May 16, 2024, 2:36pm UTC](https://community.glideapps.com/t/automatically-modify-a-row-in-glide-database-when-a-specific-date-is-reached/73433/1 "2024-05-16T14:36:16Z")
I need to modify the data in a row in a Glide database when a given date (also stored in the same row) is reached. Is there a way to do that? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1fa392d16e33c8becce840f984fdb99c9da0192a.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 16, 2024, 3:22pm UTC](https://community.glideapps.com/t/automatically-modify-a-row-in-glide-database-when-a-specific-date-is-reached/73433/2 "2024-05-16T15:22:08Z")
You can do that with math. It will be a computed column and not a value that’s stored in the table, but it’s possible. What are you trying to achieve? ---
**Author:** ![LVaurie](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@LVaurie](https://community.glideapps.com/u/LVaurie)\ **Post date:** [May 21, 2024, 7:18am UTC](https://community.glideapps.com/t/automatically-modify-a-row-in-glide-database-when-a-specific-date-is-reached/73433/3 "2024-05-21T07:18:35Z")
I’m trying to automatically change a user’s to-do list once their arrival date has been reached. There’s a pre-arrival-date list and a postarrival-date list (which includes the same to-dos as the first list, but with some new ones). ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 21, 2024, 7:49am UTC](https://community.glideapps.com/t/automatically-modify-a-row-in-glide-database-when-a-specific-date-is-reached/73433/4 "2024-05-21T07:49:38Z")
Use an [if-then-else](https://www.glideapps.com/docs/automation/computed-columns/if-then-else-column) column. - If Arrival Date is after today, then pre-arrival-date list - Else post-arrival-date list ---
**Author:** ![LVaurie](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@LVaurie](https://community.glideapps.com/u/LVaurie)\ **Post date:** [May 21, 2024, 8:55am UTC](https://community.glideapps.com/t/automatically-modify-a-row-in-glide-database-when-a-specific-date-is-reached/73433/5 "2024-05-21T08:55:00Z")
I already have another column for assigning a list. It’s a text column, filled by a “choice list”, with a relation column next to it. I suppose this makes my problem too complex… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 21, 2024, 8:59am UTC](https://community.glideapps.com/t/automatically-modify-a-row-in-glide-database-when-a-specific-date-is-reached/73433/6 "2024-05-21T08:59:44Z")
I don’t see how it is particularly complex. If you want it to be automatic, based on the current date, use the solution that I gave you. If you want it to be manual, based on a user selection, then stick with your choice option. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 28, 2024, 9:00am UTC](https://community.glideapps.com/t/automatically-modify-a-row-in-glide-database-when-a-specific-date-is-reached/73433/7 "2024-05-28T09:00:36Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.