How to link response's from 2 forms | Community
Skip to main content
Answered

How to link response's from 2 forms

  • February 14, 2024
  • 4 replies
  • 225 views

 

Hello! I have linked two typeforms so that when a user completes the first one (registration data), I collect their information and instead of ending on a final screen, I redirect them to a URL that is another typeform where they can select an option. I have programmed both typeforms to automatically download the responses to a Google Sheets. My question is: is there a way for the response to the second typeform to be linked to the first one so that I can identify which user has selected each option? Thank you very much!

Best answer by john.desborough

@HobeenTeam @Liz - you would need to pass an identifier from the first form to the second as a hidden field ie email address, so that you can use the email address in both forms to link the data

you would have to use a ‘separate’ tab in the second spreadsheet (my recommendation) to pull the data from the main typeform tab (using arrayformula() function) and then do a look up to the ‘other form’ data using the email address as the lookup field and then bring the associated data from that row/sheet into the reporting tab… 

there are a bunch of examples around that show how that might work - including a couple of workshops where i’ve shown that.. 

 

des

View original

4 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14884 replies
  • February 14, 2024

Hi @HobeenTeam If you’re trying to link the two forms within the Google Sheet, I don’t believe there’s a way to do this offhand, but @john.desborough (master of Google Sheets) might be able to confirm!


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5267 replies
  • Answer
  • February 14, 2024

@HobeenTeam @Liz - you would need to pass an identifier from the first form to the second as a hidden field ie email address, so that you can use the email address in both forms to link the data

you would have to use a ‘separate’ tab in the second spreadsheet (my recommendation) to pull the data from the main typeform tab (using arrayformula() function) and then do a look up to the ‘other form’ data using the email address as the lookup field and then bring the associated data from that row/sheet into the reporting tab… 

there are a bunch of examples around that show how that might work - including a couple of workshops where i’ve shown that.. 

 

des


  • Author
  • Explorer
  • 1 reply
  • February 15, 2024

Thank you very much! I'm going straight to look for those tutorials!


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14884 replies
  • February 15, 2024

Let us know how it goes, @HobeenTeam !


Reply