Help

Can I get a date field that will default to today, but still be editable

2970 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Really_ReallyRu
5 - Automation Enthusiast
5 - Automation Enthusiast

Best I can come up with would be to have

  • one column that is creation date
  • a second column this is editable date
  • a third column which will display the second column if it exists, and the first column otherwise

Unfortunately, this would mean that the place I edit the date would be different than the place I view the date

3 Replies 3
Marko_Petrovic
7 - App Architect
7 - App Architect

First thing that comes to my mind is to use automation to write today’s date when you create record.
There might be some more elegant solutions :slightly_smiling_face:

Russell_Brand
4 - Data Explorer
4 - Data Explorer

How would I do this?

I saw something about a limit on automations. If I had one automation per record, I imagine that I would bump up against that rather quickly(?)

Marko_Petrovic
7 - App Architect
7 - App Architect

Well that depends on the amount of records you will be making and plan you are on. You can see limit of each plan on https://airtable.com/pricing
If you dont need to have date editable you can just use formula.

As for automation, you would need a formula field in the base with Today() function.
Than use trigger “when record is created”, and insert field with Today() formula into the date field you need to be editable after.