Hello all,
We have a fleet of vehicles. The people still fill in the data on a sheet of paper. I'm trying to digitize this a bit and I'm using the interface function (Forms).
The person in charge would like to have a function that ensures that people cannot enter incorrect kilometers since they have to split up their kilometers driven.
Do you know if something like this would be possible? Unfortunately, I have not been able to make it work.
Thank you very much.
No, this is not possible with Airtable’s forms.
You would need to use Fillout's advanced forms for Airtable which offers the ability to perform calculations in your form, and then you would disable the submit button if your 2 calculation fields don’t match.
Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
No, this is not possible with Airtable’s forms.
You would need to use JotForm, which offers the ability to perform calculations in your form, and then you would disable the submit button if your 2 calculation fields don’t match.
After the form is submitted, you would automatically send the data from JotForm to Airtable by using Make’s JotForm integrations.
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
Hi Scott. Thanks a lot for your reply.
Just using a "blank" interface would not give me more options, right?
I don’t think so.
Afraid not - field validation in AT is limited to CHAR, NUMERIC, DATE, TIME etc, i.e. the field type - You cannot perform logical checks on the data entered if it matches the field type - But their party add ons will provide this for you (at a cost)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.