–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.
I am not 100% sure that there isnt a more elegant way, but this is how I did it, since I had simialr problem.
What we did is create formula field with Today() formula, which we then hide since its only used for automation.
Then use update record action and configure it so that it writes Formula field into your desired destination (in your case “Published Date”).
You can edit that field manualy after if needed.
Hope it helps, a bit late here and I was working whole day so a bit tierd :grinning_face_with_big_eyes: