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?
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:
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:
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.