Required Question on Form-People are still skipping it


#1

I have a design request form that staff has to fill out with their budget code for their project and its a required field and people have been able to submit the form without that not being filled in. I have it set as a text field right now because the formatting needs to use numbers and hyphens. Is that why people are able to get passed it? Are they able to just put a space?

How can I make sure that cell is always filled in like this: 000000-000000-0000-00? The person filling out the form has to fill out that one question like that or they can’t submit it. Is that possible?


#2

There’s currently no field validation in Airtable anywhere. Given that there’s no proper answer to your problem, here are a few “solutions” I can think of:

  1. Add a checkbox at the end of the form that says “By checking the box I acknowledge that a form submitted without a budget code will result in a stapler being thrown in my general direction.”
  2. Since the budget code has a fixed format of four number sequences joined by hyphens, break the form entry into four separate boxes and join them yourself using a formula (e.g. {Part 1}&"-"&{Part 2}&"-"&{Part 3}&"-"&{Part 4}). However, considering your users are already having problems with a single field, this would seem like a recipe for disaster.
  3. Use Google Forms or another service and then paste the results into Airtable.

#3

I really enjoy number 1 the best and really wish I could use that! :smile:

I know that airtable has an integration with google drive, is there a way to make a response from google forms go directly to airtable?


#4

You can do it through Zapier; I believe there’s a pre-built “Zap” that will create/update an Airtable entry from Google Forms (it might be listed under Google Sheets, since that’s where the submitted data gets stored).