Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 30, 2022 01:04 AM
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?
May 31, 2022 12:17 PM
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.
Jun 08, 2022 02:09 AM
@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
Jun 08, 2022 02:17 AM
You may want to use @kuovonne’s Prefilled Forms app to help you create your form links:
Jun 08, 2022 04:03 AM
@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.
Jun 08, 2022 05:18 AM
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.
Jun 08, 2022 06:48 AM
@ScottWorld ow it’s possible to implement dynamic drop down feature with Miniextension? Can you please point me to example?
Jun 08, 2022 07:09 AM