I have a multiple select field that is basically as follows:
Scheduled for Launch
I have another two fields that represents start dates and end dates.
I have a data record where I will set the start date and end date and then, if that is happening in the future, I will set “Scheduled for Launch”.
What I would like to know is if there is any way I can do a control check that basically pushes a data record status into ACTIVE if it has been set as “Scheduled for Launch” and it has arrived at the start date.
Is this something I would have to automate using something like Zapier?