I was able to automatically update a record with a “need to start” status when created, but I’d also like it to automatically put today’s date in as well. I’m just not sure what I should be typing in the date field. I tried typing Today, but that didn’t work.
I’m going to admit to being a total novice here so please feel free to spell it out to me like I’m five.
Welcome to the Airtable community!
You don’t need to use an automation to put in the date that a record was created. That information is available in a formula field that uses the
CREATED_TIME() function or a created time field.
What you want can be done with automations, but it isn’t as simple as you would like.
You can update a date field with an automation, but where is the date coming from? Currently the “Update record” action can only update fields with fixed data, data from the record, or data from a linked record.
You could create a new formula field that returns the current date, and update your date field with that formula field.
Eventually, the “Update record” might have the ability to put in a formula that provides the current date, but automations is still a very new platform and that doesn’t exist yet.
However, since you can get the date a record was created without automations, why do you need an automation to get it?
To do this for the current date:
output.set("date", new Date().toISOString())
datefrom this action and use it to populate date fields.