Possible to make "Select Field" change when desire day is come?

I want to make a tv database for ongoing tv shows. as an example “Loki” tv series it’s first season air will finish 14th july 2021. i added in my base. i want to change the select status to “Finish” if 14th july 2021 day come. is it possible?

Set an Automation to trigger when a record in that table matches the condition: {Date} field = today

Add an Update record step that changes the {Select} field’s value to “Finish”

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.