Link google sheets to update a question on the form | Community
Skip to main content
Answered

Link google sheets to update a question on the form

S
  • SOS
  • Explorer
  • 1 reply

Would like your support on figuring out if these are possible. 

Q1. Link a self updating list that’s on google sheets as a dropdown field on a typeform. 

Q2. Pull a question from the google sheet based on the dropdown selection

To make it a bit more sensible, here’s how this scenario would work. :sweat_smile:

  • Person A submits typeform 1
  • Data is pulled to a google sheet and a unique ID is provided. (this is done for each submission)
  • Person B given Person A’s unique ID and is asked to respond to some answers given by person A in typeform 1.
  • Person B goes to Typeform 2. 
  • Has to select the unique ID from the Drop down (Q1 above)
  • The form should pull a response (based on the unique ID) given by Person A in typeform 1 as a question to Person B. (Q2 above)

Hope it makes sense!
Is this possible on typeforms? How should I go about doing this?

Best answer by Liz

Hi @SOS Welcome to the community! :grin: Happy to help answer all the questions!

Q1 & Q2 - It isn’t possible to connect a dropdown field to a list outside of the Typeform, so you’ll need to update the list manually in the form builder. 

Though, you can show different questions based on the answer by using the logic jump steps here. 

The workaround I can think about this would be to use a combination of hidden fields and logic jumps to pass data into the form and show different questions based on the hidden field data. Will you only be storing the data in a Google Sheet? Or do you happen to have a CRM you’ll be adding the data to? 

View original

2 replies

S
  • SOS
  • Author
  • Explorer
  • 1 reply
  • July 15, 2021

Would like your support on figuring out if these are possible. 

Q1. Link a self updating list that’s on google sheets as a dropdown field on a typeform. 

Q2. Pull a question from the google sheet based on the dropdown selection

To make it a bit more sensible, here’s how this scenario would work. :sweat_smile:

  • Person A submits typeform 1
  • Data is pulled to a google sheet and a unique ID is provided. (this is done for each submission)
  • Person B given Person A’s unique ID and is asked to respond to some answers given by person A in typeform 1.
  • Person B goes to Typeform 2. 
  • Has to select the unique ID from the Drop down (Q1 above)
  • The form should pull a response (based on the unique ID) given by Person A in typeform 1 as a question to Person B. (Q2 above)

Hope it makes sense!
Is this possible on typeforms? How should I go about doing this?

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 14884 replies
  • Answer
  • July 15, 2021

Hi @SOS Welcome to the community! :grin: Happy to help answer all the questions!

Q1 & Q2 - It isn’t possible to connect a dropdown field to a list outside of the Typeform, so you’ll need to update the list manually in the form builder. 

Though, you can show different questions based on the answer by using the logic jump steps here. 

The workaround I can think about this would be to use a combination of hidden fields and logic jumps to pass data into the form and show different questions based on the hidden field data. Will you only be storing the data in a Google Sheet? Or do you happen to have a CRM you’ll be adding the data to? 

Life is a series of awkward moments separated by snacks.

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs