Is there a way to autofill a hidden field or Date data on a form to show when that form was submitted? This to to eliminate the need of asking the user to fill in a date field.
Solved
FORMS - Date Submitted Field
+2Best answer by ScottWorld
There is a special field type called "Created Time". Just add one of those fields to your table, and you will always see the Created Date (and optional time).
Created Time fields are fields that can't be edited by the user, so if you actually need to have an editable date field for some reason, then you can just create a normal date field and have an automation set the normal date field to the value of the Created Time field.
+12Hi @JMilligan
You can have a Last Modified Time field. This could show you when the form was submitted, assuming no other data is modified within that record.
You can alternatively create a field with the formula CREATED_TIME(). So when a form has been entered, you can see what date it was created.
Hope this helps!
+35There is a special field type called "Created Time". Just add one of those fields to your table, and you will always see the Created Date (and optional time).
Created Time fields are fields that can't be edited by the user, so if you actually need to have an editable date field for some reason, then you can just create a normal date field and have an automation set the normal date field to the value of the Created Time field.
+2There is a special field type called "Created Time". Just add one of those fields to your table, and you will always see the Created Date (and optional time).
Created Time fields are fields that can't be edited by the user, so if you actually need to have an editable date field for some reason, then you can just create a normal date field and have an automation set the normal date field to the value of the Created Time field.
Thanks @ScottWorld ! That worked perfectly.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.