Take information from one Tally Form and create multiple rows on Google Sheets

Beginner Questions
,
1

I have a “customer intake form” on Tally. The customer enters multiple “participants” by entering each name and email (separate fields, up to 15 pairs on the Tally form).

I need to create one row in Google Sheets for each “name and email” pair that my customer enters. They may enter up to 15, but there could be some blanks.

I am really stuck. I have tried to create an array, using advice from chatgpt but its not working after multiple iterations. I am very new to coding and a lot of this terminology is new to me.

Can you help? Thank you!

3

Hi @Cat_White,

I assume you do have multiple pages in tally or at least ask the question “first name for person X” 15 times, right?

If you use the Tally app, you should receive all of those variables and because it’s not really a dynamic field, I’d suggest to setup 15 routes with filters.
”If first name, last name and email of person X exists” → create a row for person X.

It’s not the most beautiful setup but it works! :slight_smile:

Best,
Richard