Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Expanded Options for Date Field

cancel
Showing results for 
Search instead for 
Did you mean: 
FormsUser
4 - Data Explorer
4 - Data Explorer
Status: New Ideas

I often develop Airtable forms for use in youth afterschool programming. Since many of our participants are minors, it is important that we document their ages. In Airtable forms, I add the date field for prospective participants to enter their DOB and make it a required field. I set the "Range Minimum" to the latest date someone could be born and qualify for program (so, if a program requires you be 18 to participate, the "Range Minimum" to the latest date someone could be born and still be 18 by the program start date). Problem is, you have to click through each of the months of each year to get to the far past. This is time-consuming, and having the ability to type in a date would really save time. 

Overall, the Airtable team should look into allowing the date field to be used for more than just tracking dates connected to things other than just project timelines. 

Who is the target audience?

People who use forms and other Airtable features to track age or other dates that occurred in the far past. This is NOT for people tracking future deadlines or team project timelines, as it seems that the Date field is currently configured with those users in mind. 

2 Comments
ScottWorld
18 - Pluto
18 - Pluto

 

To clarify what @FormsUser was trying to explain above, he is saying that when you create a new form in Airtable, and you decide to set the form to be restricted by a "range limit", Airtable frustratingly doesn't allow you to type in a date for your range limit.

Instead, Airtable forces you to keep clicking with your mouse over & over & over again for an extremely long time (typically many minutes or longer) in order to set your range limit.

This is extremely frustrating, which is why I would recommend that you rebuild all of your forms with Filloutโ€™s advanced forms for Airtable.

Fillout is 100% free and it is the most advanced form software available for Airtable. It offers hundreds of features that Airtableโ€™s native forms donโ€™t offer, including the ability to set date range limits by typing on your keyboard.

As you can see from the Fillout screenshot below, you can type in date ranges with your keyboard, and even better, you can actually make your date ranges VARIABLE by using date calculations! So the date ranges can continually change all on their own, without you needing to do anything on your end.

Fillout also offers hundreds of other advanced Airtable features, such as the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more. 

Hope this helps! If youโ€™d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant โ€” ScottWorld

Screenshot 2025-01-20 at 5.20.55โ€ฏPM.png

 

FormsUser
4 - Data Explorer
4 - Data Explorer

@ScottWorld you highlighted my problem exactly. Fillout does look like a viable option to remediate this and other Airtable limitations. I'll have to see about my company policy regarding third-party extensions in Airtable since we do collect and store confidential/private data from our participants. I'll follow up if I end up using it to solve this issue. Many thanks!