Help

Re: Form datestamp / pre-fill form with today's fate?

1107 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Robert_Andrews
6 - Interface Innovator
6 - Interface Innovator

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.

3 Replies 3
Stephen_Hauck
6 - Interface Innovator
6 - Interface Innovator

I use this to auto enter a date time …

DATETIME_FORMAT(SET_TIMEZONE(CREATED_TIME(), ‘America/New_York’), ‘M/DD/YYYY h:mm A’)

Robert_Andrews
6 - Interface Innovator
6 - Interface Innovator

@Stephen_Hauck Yes, using CREATED_TIME() now - not with all the other stuff, but works okay.
Thanks.

Moe
10 - Mercury
10 - Mercury

One of our form’s features is the ability to be pre-filled with today’s date automatically.