Help

Re: Today's date when status changes

3959 0
cancel
Showing results for 
Search instead for 
Did you mean: 
carine
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,
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”)

Next question:
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!

5 Replies 5
Marko_Petrovic
7 - App Architect
7 - App Architect

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:

Thanks Petrovic! I’ve never played with formula fields so I will try to learn. If you can point me to some info or screen shot showing how to configure it, I’ll be forever grateful!

Marko_Petrovic
7 - App Architect
7 - App Architect

This is how formula field should be configured to show todays date:
Formula

Its quite simple :slightly_smiling_face: In fromating Tab you can set how date should look, same as with Date field.
You have all the various formulas listed here : https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference

As for the automation part, not sure if its helpfull but this is how it looks:
InkedAuto2_LI
1 - Is your destination field
2 - Is the name of your Formula Field

carine
5 - Automation Enthusiast
5 - Automation Enthusiast

Woo-hooo!!! It worked!! (the team will be very impressed when they see this). Thanks so much for your help!

Clairerockwood
4 - Data Explorer
4 - Data Explorer

Hello, I'm at a complete loss, I followed the exact same steps but Airtable says "received invalid inputs".

I created a formula for today in a specific field "Today"

My automation is:

  1. I update a record (with a button)
  2. I find the updated record
  3. I change a date field (Supplier quote requested) with today's date (Today)

The preview shows me exactly what I want (Supplier quote requested on July 25th) but Airtable says NO.

Am I doing something wrong?

  1. Capture d’écran 2023-07-25 à 11.23.07.png