Skip to main content

PRODUCT SUGGESTION FOR FORMS: Hidden fields & hidden prefill fields that actually submit


ScottWorld
Forum|alt.badge.img+20

2024 update:

Even though Airtable eventually added this feature, all of this is possible in a MUCH easier & much more customizable way with Fillout’s advanced forms for Airtable.

Fillout’s advanced forms for Airtable are 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to conditionally hide fields on a form, 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. 

————- 

Old post from 2020:

Not sure if this is a bug in Airtable or just a missing feature, but we really need this feature. Airtable needs the ability for us to have hidden fields on forms that will submit data upon form submission.

Currently, Airtable doesn’t accept the values from any hidden fields.

Here’s the situation:

My clients are currently having difficulties with Airtable forms, because prefilling fileds on forms (using the “?prefill_fieldname=” syntax) only works if the fields that you’re prefilling are actually visible upon submitting.

We’re trying to prefill hidden fields on the form that we’ve hidden using Airtable’s brand new conditional field feature for forms. So we’ve hidden a bunch of fields (using fake values that will always result in false). We’re forcing these fields to be hidden.

These hidden fields actually get their prefilled values filled in correctly!

How do we know this? Because if we type in the fake values to “show” these hidden fields again, the prefilled values are visible! The prefilled values are right there!

But — the only way to get these values to be added into our Airtable database upon form submission is to keep the field visible.

If the field is hidden, Airtable won’t submit the value into the base, which then defeats the purpose of having a hidden field to begin with.

Thanks!

38 replies

  • Participating Frequently
  • 10 replies
  • July 10, 2020

I strongly agree with that request. Most of the times It makes no sense to prefill and let user mess with the prefill value.


Not a native Airtable form but On2Air Forms by @openside can do this with JotForms.


A new, upgraded version of On2Air Forms is also in the works.


  • Inspiring
  • 368 replies
  • August 11, 2020

One of the features that we’ve added recently to our form builder is the ability to prefill hidden fields!



ScottWorld
Forum|alt.badge.img+20
  • Author
  • Brainy
  • 8705 replies
  • August 11, 2020
Moe wrote:

One of the features that we’ve added recently to our form builder is the ability to prefill hidden fields!




Wow! This is awesome, @Moe! Thanks for creating this! 🙂


  • New Participant
  • 2 replies
  • September 23, 2020

100% agree. It’s the most glaring missing feature on Forms, and the one big thing that really stops it from being a viable non-anonymized collection tool for almost every customer-facing business. It’s just not feasible to prefill a company name on a form if the recipient can ‘x’ out their company and then look at a list of every single other customer I have.


  • Participating Frequently
  • 5 replies
  • September 25, 2020

Won’t be able to use Airtable without this tbh. missing a trick.


  • New Participant
  • 3 replies
  • November 3, 2020

The lack of this feature is a huge blocker. I’m sure it’s pretty simple to implement and the value of this is enormous.


ScottWorld
Forum|alt.badge.img+20
  • Author
  • Brainy
  • 8705 replies
  • November 3, 2020

Everyone, please be sure to email support@airtable.com about this. I emailed them, and they didn’t understand why it was such a big deal to me. :man_shrugging:t2: :man_facepalming:t2: Perhaps they’ll understand if they receive more emails from different people with different needs for this feature.


ScottWorld wrote:

Everyone, please be sure to email support@airtable.com about this. I emailed them, and they didn’t understand why it was such a big deal to me. :man_shrugging:t2: :man_facepalming:t2: Perhaps they’ll understand if they receive more emails from different people with different needs for this feature.


Also emailed, this is a major blocker for me too. :crossed_fingers:


  • New Participant
  • 2 replies
  • February 23, 2021

This is a must for us too!


  • New Participant
  • 1 reply
  • March 12, 2021

And for me too! This feature so easy to implement and so important!

I can’t find any reasons, why AirTables do not do this:(


  • New Participant
  • 2 replies
  • March 16, 2021

agreed! thanks for posting this @ScottWorld


I found a work around for this! BUT, it would still be awesome if Airtable implemented this suggestion 🙂


Using the new Airtable automations feature, you can create a new Airtable record with whatever fields you need pre-filled, separate from what info the client submits in a separate form… So upon submitting a Google Form, I can populate fields in Airtable with info from the Google Form and whatever else I need in Airtable, determined by me.



  • New Participant
  • 1 reply
  • April 14, 2021

Hey Airtable, can we please please please have this feature?


  • Inspiring
  • 8 replies
  • April 20, 2021

Agreed @ScottWorld. As I noted here, in addition to setting hidden form values via query argument, it would also be convenient to be able to define values for hidden form fields by view


ScottWorld
Forum|alt.badge.img+20
  • Author
  • Brainy
  • 8705 replies
  • April 20, 2021

Yep, please keep bugging support@airtable.com about this minor but very important change to forms.


In the meantime, we all need to use a professional form building tool like JotForm or MiniExtensions.


  • New Participant
  • 1 reply
  • July 20, 2021

Can we please get this feature?!


Kelly_Loucks wrote:

Can we please get this feature?!


so they have done something that will help. you can now use the 'when a form is submitted trigger so you could run an automation to update the record when it is submitted


  • Participating Frequently
  • 5 replies
  • November 23, 2021

How this is not a feature already is beyond me. Please add this soon 🙏 🙏 🙏 🙏 🙏


  • Participating Frequently
  • 5 replies
  • November 23, 2021
Rebecca_Elam wrote:

so they have done something that will help. you can now use the 'when a form is submitted trigger so you could run an automation to update the record when it is submitted


Can you elaborate pls? When the form is submitted the contents of the hidden field or URL parameter will be gone so how do you grab them for the automation?


  • Inspiring
  • 150 replies
  • November 26, 2021
david_schaerf wrote:

Can you elaborate pls? When the form is submitted the contents of the hidden field or URL parameter will be gone so how do you grab them for the automation?


well. usually if youre hiding it from the user its something that the user isn’t changing. if that’s the case you just write an automation that says when a form is submitted update it with this info.


  • Inspiring
  • 150 replies
  • November 26, 2021
david_schaerf wrote:

Can you elaborate pls? When the form is submitted the contents of the hidden field or URL parameter will be gone so how do you grab them for the automation?


youre the one who put the prefill things in there, just prefill it after instead of before. but it depends on the usecase


  • Participating Frequently
  • 10 replies
  • November 28, 2021

This feature is a must. Been looking for that for a long time


  • New Participant
  • 1 reply
  • November 30, 2021

Yes, this is a must! This thread started in July 2020, I don’t understand why this feature has not been prioritized.


  • Inspiring
  • 150 replies
  • December 3, 2021
Arno_B wrote:

Yes, this is a must! This thread started in July 2020, I don’t understand why this feature has not been prioritized.


Generally, it’s one of a few things, Either because the underlying problem requires too much restructuring needed to accomplish it. That there is already a way that most people know that only a few people are missing. They built in a different feature that solves the issue. Or they’re already working on it and everyone needs to be patient. Not saying any of those are applicable here. I don’t know. but every time I ask these questions one of those is the answer. Ultimately what we need is transparency.