Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Prefill a Specific Date in a Form

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1297 8
cancel
Showing results for 
Search instead for 
Did you mean: 

I’ve seen a lot of requests for specifying Today() as a prefill option for a date field, but I haven’t been able to find any asking whether you can pass Airtable a specific date as a prefill option. Is this a thing?

1 Solution

Accepted Solutions

@kuovonne has actually created an app that makes it very easy for you to create your prefilled URL:

The string format (before you URL encode it) should be as simple as this:

1/28/2021 8:00am

See Solution in Thread

8 Replies 8

Yes, you can prefill a form with a specific date. You may need to play around with the url encoding of the date string you use.

I think he means that he wants the form to continually pre-fill with a different date, depending on today’s date. The only way to do that would be to keep changing the URL, yes?

To prefill a form with a different date would require a different url with different url parameters.

However, I’m not sure what you mean by “continually prefill”.

Perhaps @Julian_E_Post can give more details with some specific examples?

“Continually prefill”: meaning that the value changes every time someone goes to the form.

@Julian_E_Post: What you want to do is not possible with Airtable’s forms. You would need to use a more advanced form building software like JotForm, which lets you set the default date to today. This support article has a screenshot which shows you your default date options:

Thanks @ScottWorld and @kuovonne . For this post, I am interested in how to input a static date. The URL will change based on a formula in Airtable. What is the string format that Airtable will accept to prefill a date and time. For example, Jan 28, 2021 at 8:00am?

@kuovonne has actually created an app that makes it very easy for you to create your prefilled URL:

The string format (before you URL encode it) should be as simple as this:

1/28/2021 8:00am

Very cool! I am completely new to URL encoding, but I can reverse-engineer @kuovonne 's app-generated urls to figure it out. Thanks!

You don’t really need to worry too much about it, because the ENCODE_URL_COMPONENT function takes care of it all for you.

Also, here’s a support article on how to manually create your own prefill URLs: