Oct 11, 2023 05:14 PM
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! Go to Solution.
Oct 11, 2023 06:27 PM
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.
Oct 11, 2023 06:22 PM - edited Oct 11, 2023 06:24 PM
Hi @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!
Oct 11, 2023 06:27 PM
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.
Oct 11, 2023 06:49 PM
Thanks @ScottWorld ! That worked perfectly.