Skip to main content

Auto Insert Date Based on Submitted Form

  • November 17, 2018
  • 4 replies
  • 66 views

Hi All!

I’m new to this community and hope to contribute as well as to learn from you all.

I have a form created in Airtable. How do I create a formula so that when the form is submitted, airtable would insert the date of the submission automatically in a specific field I created beforehand.

Thanking you all in advance for any assistance.

4 replies

Forum|alt.badge.img+19
  • Inspiring
  • November 17, 2018

You could use the field type “Created Time”, or a combination of the formulas DATETIME_FORMAT() and CREATED_TIME() to get the format you want. That will automatically insert the date and time the record was created into that field.


  • Author
  • New Participant
  • November 17, 2018

You could use the field type “Created Time”, or a combination of the formulas DATETIME_FORMAT() and CREATED_TIME() to get the format you want. That will automatically insert the date and time the record was created into that field.


Hi Nead_Admin! Thank you for your quick reply.

I will try and will report back.


  • Author
  • New Participant
  • November 17, 2018

Hi Nead_Admin! Thank you for your quick reply.

I will try and will report back.


It worked! Thank you so much.


Forum|alt.badge.img+2
  • New Participant
  • October 19, 2021

Hello,

Where do you add this formula?

Thanks