How can i configure Date entry to capture date entry automatically to date the form is submitted, if possible along with time.
Automatic Date Entry
+18Hi @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.
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.
Can I have my primary field to be the created date?
+18How? I didn’t find the way.
@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.
+29@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.
Or have your primary field be a formula field with the CREATED_TIME() function.
+18Or have your primary field be a formula field with the CREATED_TIME() function.
Completely forgot about that function. Yes, what @kuovonne said would be best. Thank you.
Or have your primary field be a formula field with the CREATED_TIME() function.
That’s really works! Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.