About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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?
Question

How do I pre-populate a JotForm Enterprise dropdown menu from values in Airtable without manual input?

  • 22 September 2023
  • 1 reply
  • 125 views
lflynn72

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!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

SamB
Rank
Userlevel 7
Badge +11

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