Hi Airtable Community!
I’m looking for some help with creating an automation or script (I don’t know if it’s that complicated).
I need the record called Date of RTL to be updated WHEN the record called "RTL = YES.
The date that needs to populate is the date in which the condition becomes true in RTL.
Example: A5 Liquor was RTL=YES on 8/17/2020, which I manually selected.
Right now it’s a manual process and as you can see, I’ve forgotten to update it a few times. It does not have to retroactively update the Date of RTL, but would be helpful.