Skip to main content

Hi Team,


I have created 1 view and 1 form within air table. As soon as i submit the form 1 row gets inserted in the view. Subsequently, The view is attached to Run Script which gives call to external REST API.


Below are the fields displayed on the form. FYI. I have mentioned the fields type as well in the bracket.


Field names: customer(Single Select),source category(Multiple Select) and source url(Long text) ,target category(Multiple Select),target url(Long text) and email(Single Line text) etc.


Requirement: I would like to dynamically pre-filled the source category and target category fields based on the selection of the value of customer field.


Could you please guide and point me to the example/link where i can get idea how this is possible to do in air table?

Hi @Manoj_Dhake

Airtable forms are quite simplistic but they do have conditional questions and have a feature that lets you ‘prefill’ the fields based on unique URL: https://support.airtable.com/hc/en-us/articles/234982508-Prefilling-a-form

If this does not meet your needs you may want to look into other form solutions, JotForm is popular with Airtable users.


Hi @Manoj_Dhake

Airtable forms are quite simplistic but they do have conditional questions and have a feature that lets you ‘prefill’ the fields based on unique URL: https://support.airtable.com/hc/en-us/articles/234982508-Prefilling-a-form

If this does not meet your needs you may want to look into other form solutions, JotForm is popular with Airtable users.


@Vivid-Squid .Thank you for your suggestion.


I have multiselect field type in the form which also need to be auto populated. I tried to fill this field as mentioned in the documenation here But it didn’t work for me.


Do you know how to pre-fill field having multi select field type?


Please find screen shot of my form along with form url. The pre-fill url which i have tried so far.


(https://airtable.com/shrhGxpa21QrdOIke?prefill_customer=ADOC&prefill_Source%20Category=MathAndLogic%2CInformationTechnology)
https://airtable.com/shrhGxpa21QrdOIke?prefill_customer=ADOC&prefill_Source+Category=MathAndLogic,InformationTechnology


2025 Update:

You have 2 ways of doing this:

  1. Use Airtable’s dynamic filtering in linked records feature.
     
  2. The easier & more powerful option is to use Fillout’s advanced forms for Airtable.
     

    Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to have dynamic filtering that is more powerful than Airtable’s filtering.

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


Hi @Manoj_Dhake

Airtable forms are quite simplistic but they do have conditional questions and have a feature that lets you ‘prefill’ the fields based on unique URL: https://support.airtable.com/hc/en-us/articles/234982508-Prefilling-a-form

If this does not meet your needs you may want to look into other form solutions, JotForm is popular with Airtable users.


@ScottWorld .

I would like to display the multi select field with some static values. And as per my understanding, The purpose of Prefilling-a-form/Prefilled Forms App is different than my requirement. Instead of selecting the values on the form, I wants to create static list for multi select field type.

I am aware of the way to define static values as option using below option. But the problem is that my static values are different for each customer. So, I wants to maintain single form as well.


e.g. The form should look as below after i hit the pre-filled form link. Keep in mind that, the values for Source Category are just displayed as static list but not selected any value.



2025 Update:

This is a relatively new feature in Airtable. It is called dynamic filtering in linked record fields. You can read more about this in Airtable’s support article here.

However, you can also get this feature — with significantly more power — by using Fillout’s advanced forms for Airtable.

Fillout offers hundreds of features that Airtable’s native forms don’t offer, including the ability to have dynamic linked record fields, the ability to update Airtable records in 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


That is not possible with Airtable’s forms. You can only do that with the form from MiniExtensions.com, or the combination of JotForm + On2Air: Forms.


@ScottWorld ow it’s possible to implement dynamic drop down feature with Miniextension? Can you please point me to example?


2025 Update:

I would recommend doing this with Fillout. Their instructions are located here.

If you’d like to do this with MiniExtensions, their instructions are located here.

I would highly recommend using Fillout to do this, as they offer hundreds of features that Airtable doesn’t offer.

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


Reply