May 16, 2017 05:14 AM
Hi
I have made a form for colleagues to fill in.
Amongst many fields people will manually fill in, I need the form to add the current date to my table.
Are there any tactics for doing this?, please?
In this case, this field could be hidden from the form, as the value will always be the day on which the form is sent.
Alternatively, we could pre-fill the form field with today’s date, but a) I know AirTable doesn’t support pre-filling/default form fields and b) though I know you can pass values through a URL string parameter, I’ve no idea when you can pass a generic TODAY-type value, as opposed to a specific value.
Thank-you.
May 16, 2017 11:33 AM
I use this to auto enter a date time …
DATETIME_FORMAT(SET_TIMEZONE(CREATED_TIME(), ‘America/New_York’), ‘M/DD/YYYY h:mm A’)
May 17, 2017 08:36 AM
@Stephen_Hauck Yes, using CREATED_TIME() now - not with all the other stuff, but works okay.
Thanks.
Sep 22, 2020 08:48 AM
One of our form’s features is the ability to be pre-filled with today’s date automatically.