How do I ensure that a form can't be submitted if the end dates is before the start date?

[JWalker]

I've been submitting tests for me event form however there is no restriction on being able to put the end date earlier than the start date. Does anyone know how I can remedy this?

Thank you.

[ScottWorld · Accepted solution]

That is not possible with Airtable’s forms.

However, you can very easily do this with Fillout’s advanced forms for Airtable.

Fillout is 100% free and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to conditionally show or hide the submit button based on certain criteria, conditionally show or hide certain fields, and validate fields to make sure that they have proper values in them that you're looking for.

So, for example, you could state "If Start Date is greater than End Date, then hide the submit button”.

Additionally, Fillout offers tons 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.

Fillout is really the best form software for use with Airtable because it natively communicates with Airtable in real-time, and it is the tool that I always recommend first.

However, just an FYI: You can also do this with JotForm's forms as well. JotForm gives you “conditional logic settings” to hide the submit button if certain conditions fail. For example, “If Date A is greater than Date B, then hide the submit button”.

Then, you would use Make's JotForm integrations to send your JotForm submissions into Airtable. There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make.

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

[JWalker]

Thank You! Really appreciate the help. 🙂

[ScottWorld]

You’re welcome! 😀

[CristianCG]

Hi there!

You can easily do this using miniExtensions. We've built a third-party form that integrates seamlessly with Airtable, and offers several ways to control or disable form submissions. These include allowing users to create only one record, setting a scheduled date to disable submissions, and restricting submissions based on specific conditions. This combined with the ability to calculate formulas within your form using our Save & Continue mode will allow you to control the submissions.

For your use case, specifically, you can set it up like this:

• Create a formula field in Airtable that calculates the difference between the start and end date, using the DATETIME_DIFF(end_date, start_date, 'days') function. If the end date is earlier than the start date, the result of this calculation will be a negative number.
• Enable the Save & Continue mode to compute formula fields before submitting your form.
• Configure your miniExtensions form to reject submissions if the result of the calculation is lesser than 0 (or 1 if you want to also reject the day being the same):