I have a base setup that tracks campaigns (each campaign has an individual record) that are currently live, upcoming, and completed based on dates we input. I’m using a single select field for the phase it’s in (live, upcoming, completed). The table is grouped by the phase. Each record has a start date and end date entered.
How can I make it so each record is automatically in the correct phase based on the start/end date I input? For example, let’s say today’s date is 8/28/20, and Record A has a start date of 8/1/20 and an end date of 8/30/20, I would want this record to be in the “live” phase right now, and on 9/1/20, I want it automatically moved to the “completed” phase. How can I achieve this?
Thanks in advance!