Answered

Link google sheets to update a question on the form

  • 15 July 2021
  • 2 replies
  • 137 views

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?

icon

Best answer by Liz 15 July 2021, 15:06

View original

2 replies

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?

Userlevel 7
Badge +5

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? 

Reply