Forms: How to have pre-filled fields in a form with unique combinations

[Eva_Gronbjerg_C]

Hi there,
I have 4 tables that are linked - they are as followed:
Table 1) People who fills in the form
Table 2) Companies (105)
Table 3) Research Areas (17)
Table 4) Questions (5)
I want to create forms that match one company, in one research area, with one question - like;
Company 1-105 + Area 1-17 + Question 1-5 - where these variables change, so each form is sent to a person who fills in the form with a specific combination. One person, one combination.
So I select the combination (best if it’s automated) and the form only makes it possible to answer the question with predefined options. So the first fields are pre-filled by me - hope it makes sense. I’m new to Airtable.
Best,
Eva

[kuovonne]

Welcome to the Airtable community!

While it is possible to generate the urls for forms prefilled with different combinations, it is always possible for the person filling out the form to change the prefilled values. It is not possible to “lock” those prefilled values in place.

There are 3rd party form services that let you set hidden fields, and thus the recipients couldn’t change those hidden values. However, these systems take more configuring, and I do not know if the number of unique combinations that you want is really feasible with them.

[Eva_Gronbjerg_C]

Thanks for your reply - really valuable! Do you know some of the 3rd party form services I can check out?

[ScottWorld]

JotForm is widely considered to be the best.

It also can submit form data directly into Airtable, and it can even dynamically pull data from Airtable with On2Air Forms.

[CristianCG]

Hi there!

At miniExtensions, we built a third-party form specifically designed to integrate with Airtable. Our form allows you to create unique URLs for existing records, which can serve as a base for generating new forms. These pre-filled forms allow the edition of the fields while maintaining reusable combinations of pre-filled data that can be used as templates:

As you can see above, the URL only requires the record ID to work effectively.