Skip to main content
Member tips

Tracking form names in Google Sheet submissions

  • Jun 20, 2024 10:42 PM UTC
  • 4 replies
  • 212 views
Tracking form names in Google Sheet submissions
john.desborough
Forum|alt.badge.img+6

Just a quick note that helps me keep track of ‘which form’ a user response comes from. (bad grammar and all that ..) 

I have a bunch of typeforms that push data into a single Google Sheet. I consolidate the details into a master tab. Each form contains a set of similar data but to make it easier to identify where the user record comes from, i use a custom variable

To keep track of the form in the responses, I create the custom variable v_form_name in each form and give it the name of the form - like in the image below: 

that variable data is submitted along with the responses to the Google Sheet. 

Now, when i consolidate the records from the various input forms into a ‘master tab’ - using email address as the unique identifier/key field to connect all the inputs - i have a column that gives me the names of the forms that have been used to submit the data record. 

I can filter on that field and figure out how many folks completed the ‘newsletter’ form in this example. 

 

That’s my little hack for today.. hope it might come in handy for some of you.. 

 

cheers

des

4 replies

James
Community Team
Forum|alt.badge.img+5
  • Community Team
  • Jun 21, 2024 9:28 AM UTC

Great little hack @john.desborough 😎 Definitely something I’ll use. Will feature this tip on the front page of the Community for extra visibility, as I think a lot of folks will appreciate this.

Now, time for me to get my sheet together...


john.desborough
Forum|alt.badge.img+6
  • Author
  • Certified Partner & Champion
  • Jun 21, 2024 2:00 PM UTC

@James - i know that there are other ways to do this that may be more elegant technically, but this was the simplest most effective method for me (going back 4 years to early days of Typeform for me lol) 

simple is better …. coffee helps me think i have my sheet together.. lol.. 

and thanks!

 

des


  • Navigating the Land
  • Feb 17, 2025 2:25 PM UTC

Oumrane 


Bako nasiru
  • Navigating the Land
  • Feb 17, 2025 3:43 PM UTC

And it’s better to knows