Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I pre-populate a JotForm Enterprise dropdown menu from values in Airtable without manual input?

Is it possible to pre populate a dropdown menu from values in airtable (or anywhere actually) and load it into a JotForm Enterprise form? I used to use On2Air to create a select and subselect dropdown that worked with JotForm but now they are sunsetting that application in November so now I have to find a new way. We have a lot of data so manual building of this list is really not feasible.

 

Basically it’s a Member dropdown- choose Member- show all addresses for that particular Member. We use JotForm so I need to stay with that platform; JotForm only has a widget for a dynamic dropdown but it’s manual. 

Thanks- I asked about this a month ago, got a response but it wasn’t what I needed and it was closed.

Any help or ideas on how to do this is appreciated!

Hello there, @lflynn72! 🙂

To pre-populate the dropdown menu fields in JotForm from values supplied by Airtable, you’d likely need to use a “Create Form” type of action for JotForm. There isn’t such an action currently but we do have an existing feature request for that type of action to be added. So I’ve gone ahead and added your vote to that and added details of your requirement to be able to populate dropdown menu fields on the form that is created. I can’t make any promises around when this feature might be implemented but we’ll be sure to email you as soon as it is.

In the meantime you could look at using a API Request (Beta) action (or build an App Extension if you’d need to use this action in multiple Zaps) to create a form and populate it’s dropdown menu fields with the relevant options. It’s a bit more of an advanced action to set up as it would involve you working with JotForm’s API documentation to set up the action. You can find out more about how to set up this type of advanced action here: Create an API Request in your Zaps. If this is something you’d be interested in exploring it looks like you’d want to take a look at JotForm’s API documentation here: https://api.jotform.com/docs/#post-forms which gives details on how the API request to create a new form should be configured. 

Alternatively, if you can export a list of the options from Airtable as a CSV file (separated by a line break) you could copy and paste that list directly into JotForm. See https://www.jotform.com/answers/506333-can-we-import-dropdown-options-from-a-list-in-csv-or-excel-file for more details. Jotform also appears to have a Spreadsheet to Form Widget widget which might be of some use: How to Use the Spreadsheet to Form Widget.

Hope that helps. If you do manage to get a solution in place with any of the above, or if you find a different solution here please let us know!

Terms & Conditions