I’m trying to create an automation:
–TRIGGER: status of the record is changed to “Completed/Published” (I managed this part, I think)
–ACTION: the “Published Date” field is automatically filled-in with today’s date (here’s where I get lost)
Is it possible to do this, and how? (I tried various things but am getting “test failed”)
Would the user still be able to manually change the “Published Date” field? For example, let’s say our content was published yesterday, but the user only updates their record in AirTable today, so they would need to manually correct the date.
Thanks for your help!