Jun 21, 2019 11:31 PM
How can i configure Date entry to capture date entry automatically to date the form is submitted, if possible along with time.
Jun 22, 2019 04:36 AM
Hi @Niranjan_Gadgil and Welcome to Airtable Community
You’re looking for the Created Time field type. You won’t see it as an option to add to the form, but it will fill it in non the less.
Hope this helps.
Aug 07, 2021 07:50 AM
Can I have my primary field to be the created date?
Aug 07, 2021 07:54 AM
@A_T1 - yes you can.
Aug 07, 2021 04:45 PM
How? I didn’t find the way.
Aug 08, 2021 01:11 AM
@A_T1 - In my haste to respond, I didn’t elaborate enough. The short answer is no, you cannot create a Created Time
field type as your primary field. The workaround is to create a formula in your primary field that points to a Created Time
field.
Use DATETIME_PARSE({Created Time})
Make sure that both fields have the same formatting. For example, both format in local time.
Aug 08, 2021 08:44 AM
Or have your primary field be a formula field with the CREATED_TIME()
function.
Aug 08, 2021 09:04 AM
Completely forgot about that function. Yes, what @kuovonne said would be best. Thank you.
Aug 08, 2021 03:12 PM
That’s really works! Thanks!