Setting up forms which vary depedning on the time
Accepted Solutions
Yes, that is correct.
The answer is to use Fillout’s advanced forms for Airtable.
Fillout can display formula fields from Airtable, like the time of day from the NOW() function.
See the screenshot below for how this could look on your form. And of course, this information could be hidden from your users as well.
And then, after getting the time on your form, you can create conditional logic based on the current time (I.e. conditional pages, conditional visibility, etc.).
However, note that since Airtable times are always attached to a date, you’ll need to create an additional formula in Airtable to just extract the time itself from the date field. That way, you can base your conditional logic just on the time of day itself. Otherwise, your conditional logic would need to incorporate the exact date as well.
Also, as mentioned above, Fillout can only pull formulas directly from Airtable when you are updating a pre-existing Airtable record.
So, you would just choose a record from your Airtable base that serves as the “updating record” for everybody visiting the form, and that would become a permanent part of the URL for your form. Fillout will provide you with the URL to use.
(Fillout has its own built-in formulas too, that don’t require the form to be an update form, but they don’t offer date/time functions such as current time.)
p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld
Yes, that is correct.
The answer is to use Fillout’s advanced forms for Airtable.
Fillout can display formula fields from Airtable, like the time of day from the NOW() function.
See the screenshot below for how this could look on your form. And of course, this information could be hidden from your users as well.
And then, after getting the time on your form, you can create conditional logic based on the current time (I.e. conditional pages, conditional visibility, etc.).
However, note that since Airtable times are always attached to a date, you’ll need to create an additional formula in Airtable to just extract the time itself from the date field. That way, you can base your conditional logic just on the time of day itself. Otherwise, your conditional logic would need to incorporate the exact date as well.
Also, as mentioned above, Fillout can only pull formulas directly from Airtable when you are updating a pre-existing Airtable record.
So, you would just choose a record from your Airtable base that serves as the “updating record” for everybody visiting the form, and that would become a permanent part of the URL for your form. Fillout will provide you with the URL to use.
(Fillout has its own built-in formulas too, that don’t require the form to be an update form, but they don’t offer date/time functions such as current time.)
p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld
