Thank you in advance for any help ya’ll can lend.
I need help getting info from Jotform into a manageable format for invoicing guests attending a party.
Setup: I receive a filled in form with a list of up to 32 different guests with the following info: Name, Email which is then sent over to an google spreadsheet.
Challenge : I need to take , essentially, a bunch of disparate columns of info on one submission for all guests, and add each guest as a separate row on a spreadsheet.
So instead of
Submission 1 | Guest 1 Name | Guest 1 Email | Guest 2 Name | Guest 2 Email |
I’d like it to convert to :
Guest 1 Name | Guest 1 Email |
Guest 2 Name | Guest 2 Email |
I’ve explored using formatter and the Line Itemizer, but can’t get them to appear on separate rows. I need to do this for up to 32 different guest on one form submission.