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 Canvas Zapier Chatbots

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.

Best answer

Typeform Issue - Update Dropdown, Multiple Choice or Ranking Question Options

  • 17 November 2021
  • 6 replies
  • 559 views
M
Userlevel 2
Badge +1

I am setting up a Typeform as a daily Jobsite Log questionnaire for our Supervisors. One of the questions is a Dropdown Multiple Choice, asking which Jobsite the Supervisor is reporting from. I set up a trigger in Airtable when a New Record is added to our Accepted Projects (populated by a Zap from Quotient to Airtable), that it is added to the Dropdown Multiple Choice.

Whenever the Zap runs though, it deletes all previous options and only populates the drop down with the last zapped info. Is there a way to keep that Typeform Dropdown updated with whatever is present in a table? Ideally, add all new projects, and remove projects as they get archived. I figure I can use google sheets as a placeholder for that data if Airtable won’t work.

icon

Best answer by GetUWired 17 November 2021, 15:05

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

6 replies

jayeshkumarbhatia
Userlevel 6
Badge +6

Hey @mannyv86 ,

 

Can you post the screenshot of your Zap setup?

M
Userlevel 2
Badge +1

 

jayeshkumarbhatia
Userlevel 6
Badge +6

Hey @mannyv86 ,

 

The reason your previous options are getting deleted is because when you update something, previous records will get deleted. 

 

To solve this issue, add an action to search for options that exist in Typeform. Now in your Typeform last action, give inputs from Airtable, as well as Typeform.

 

Your updated Zap will run like below -

So when a new record is added in Airtable → Lookup previous options of Typeform → Update Typeform options ,to inputs from Airtable and Typeform.

 

Hope i was able to explain you!

 

 

 

 

M
Userlevel 2
Badge +1

Thank you for the logic explanation! I’m wondering if it would be possible to add the step to remove projects that are removed from the Project Table so that the dropdown only shows currently active projects.

GetUWired
Userlevel 7
Badge +12

Hi @mannyv86 

I think you will need to get creative with this one but it is definitely doable! I don’t believe there is a way to look up the dropdown options using what typeform has built out in zapier, just a way to look up responses

If the dropdown options are a list of all your active projects in Airtable you could explore using their api to pull all projects from a particular view. Then pass the returned list of project names as the value into the dropdown (https://airtable.com/api) this is the most straightforward approach and can be built using Webhooks by Zapier

 

M
Userlevel 2
Badge +1

:drooling_face:

Looks like this process is above my pay grade so I’ll seek someone out to help with the Airtable API side of things. Thanks GetUWired!

Terms & Conditions