Skip to main content

Hidden prefill columns returning empty on form entry?

  • July 25, 2016
  • 20 replies
  • 90 views

Forum|alt.badge.img+2

I set prefill data for certain columns and created form for other fields. On entering form data, new row is created but these prefill records returned empty. I thought new row will contain prefill data regardless of how it is created.

I referred this for temp solution: Can I prefill a portion of a form?

20 replies

Forum|alt.badge.img+4
  • Inspiring
  • 192 replies
  • July 25, 2016

Hi,

Right now, the prefill will only work for fields that are included in the form. Hidden fields for forms is on our roadmap.

Thanks,

Kasra


Forum|alt.badge.img+4
  • Known Participant
  • 33 replies
  • July 26, 2016

I’m currently using Cognito forms as a front end for data entry into Airtable which is super useful becuase Cognito allows hidden fields, and seriously powerful calculations. They also allow you to collect payment for form entries which is great because we’re using the form as an order form. The order is placed via the form, payment is collected, the data on the order flows into Airtable and out to our operations team. The connections are made via Zapier which is just a matter of field mapping.


Forum|alt.badge.img+3
  • New Participant
  • 1 reply
  • July 28, 2016

Will this same approach work using Gravity Forms?


Forum|alt.badge.img+4
  • Known Participant
  • 14 replies
  • June 22, 2017

@Kasra, is this still on the roadmap?


  • New Participant
  • 1 reply
  • November 21, 2017

Hi there, I would need the very same solution. Thanks!


  • New Participant
  • 2 replies
  • August 13, 2018

@Kasra, is this still on the roadmap?


ditto… want this as well.


Giles_Croft
Forum|alt.badge.img+5
  • Participating Frequently
  • 7 replies
  • September 7, 2018

Hi,

Right now, the prefill will only work for fields that are included in the form. Hidden fields for forms is on our roadmap.

Thanks,

Kasra


@Kasra I too am in desperate need of this… two years have elapsed since this reply. Is it still on the roadmap please?


Forum|alt.badge.img+3
  • Inspiring
  • 17 replies
  • October 23, 2018

Same as @Giles_Croft, this is the missing piece to make dynamic forms that are truly useful.

Please tell me it‘s coming soon…


  • New Participant
  • 2 replies
  • October 23, 2018

Yes. Me too… Useful update


  • New Participant
  • 1 reply
  • September 11, 2019

I desperately need this feature – it would eliminate the need for a lot of manual data cleanup and would save sooooo much time. Please add this!


  • Participating Frequently
  • 9 replies
  • September 12, 2019

Is there any status on this? I’d love to use this as-well!


  • New Participant
  • 1 reply
  • December 31, 2019

Any updates on this issue… ?


  • New Participant
  • 1 reply
  • January 14, 2020

Very interested in this. Seems like it’s been on the roadmap for a few years.


  • New Participant
  • 4 replies
  • January 18, 2020

Me, and about 50 different people who I referred to Airtable desperately need this update. Is there any way to get the idea if it is still on the roadmap?


Forum|alt.badge.img+2
  • Known Participant
  • 20 replies
  • January 20, 2020

Same! Please make this happen!


  • New Participant
  • 1 reply
  • February 21, 2020

Also would really love this feature :heart_eyes:


Forum|alt.badge.img+2
  • Known Participant
  • 13 replies
  • February 23, 2020

I would like this change too - PROVIDED: you can specify which fields can be populated through a form and remain hidden. Allowing any field to be populated whether or not it’s visible though a form would introduce a potential security vulnerability IMHO…


Noamsay
Forum|alt.badge.img+13
  • Participating Frequently
  • 29 replies
  • February 26, 2020

Hi @Bruce_Halliburton and others,

I suggest to use Jotform as I do. Benefits:

  • It’s integrated to Airtable (Zapier not required).
  • It’s free (up to 5 forms).
  • You can create dynamic form with conditions
  • You can create custom design
  • You can prefill values by adding them as parameter in the URL (like Airtable native form)
  • You can pass pre-populated values to Airtable even on hidden fields. Just don’t forget in the form settings to select “Don’t clear” in the “Clear Hidden Field Values” question

1 major disavantage:

  • You cannot display a dropdown from an Airtable Linked Record field on your Jotform (or send a pre-populated value to a linked record field). I think only Airtable native form can.

  • Participating Frequently
  • 9 replies
  • April 24, 2020

Hi,

Right now, the prefill will only work for fields that are included in the form. Hidden fields for forms is on our roadmap.

Thanks,

Kasra


3 1/2 years later, and this feature still isn’t here :slightly_frowning_face:


CristianCG
Forum|alt.badge.img+15
  • Participating Frequently
  • 122 replies
  • October 2, 2024

Hi everyone!

Airtable introduced the ability to prefill and hide fields, which works great for many scenarios. For users who need more flexibility or additional customization options, miniExtensions offers an alternative that can handle more complex use cases, like advanced data prefill configurations:

  • Airtable:

    To prefill and hide fields, you need to use the hide_FieldName=true URL parameter alongside prefill_FieldName=value. However, this method has a security limitation: users can modify the URL to remove or alter the hide parameter, which can expose hidden fields. This is somewhat risky if the hidden fields contain sensitive data, such as select or linked fields that might reveal valid options or information. In the image below, all the available options for the hidden prefilled field 'Prefield' are shown if I change the URL hidden parameter to false:

 

https://airtable.com/appJ5gX6lkLx4aQo6/pag8DTLzAypuXTXhm/form?hide_Prefield=false&prefill_Prefield=No

 

 

  • miniExtensions:

    Fields can be prefilled through the URL without being part of the structure of your form, and the hidden property is not exposed in the URL. This ensures that users cannot manipulate the URL to reveal hidden fields or their data types. To enable this feature, simply select the “Allow prefilling hidden fields” option and prefill any field in your table as you normally would.