Trying to add form submissions onto a Spreadsheet that has a column of unique randomized numbers

JonathanMDLG

Hello all,

I was wondering if someone can let me know if there is an easy way or even a workaround to my issue. I have a list of randomized coupon codes in a column, and I need the form submission to populate the next available row with a coupon code.

The issue I have right now is that, I have the column of 500 coupon codes, and whenever someone submits the form, the submission data starts at row 500 and skips all the rows that have a unique coupon code.

The coupon codes are made elsewhere in advance in the beginning of the year, and are used/processed as requests come in.

Thanks in advance everyone. I appreciate it a ton!

Kind regards,

Jonathan M. DeLeon Guerrero

Victoria_Indimar

Hi @JonathanMDLG ! If I'm understanding correctly, you have existing rows with coupon codes in one column and you're wanting a form submission to populate the existing row to "assign" it a coupon code?? Is that right? If so, then that will not work. Form submission will also generate a new row, it cannot add to an existing row.

If you're wanting to assign a coupon code, you could store the coupon codes in something like a "master coupon code" sheet and then when a new form entry is submitted, it populates/pulls the coupon code from the "master coupon code" sheet. You could do something like auto number the form submissions so they match a numbering scheme assigned to the coupon code (an ID). Does that make sense? Would something like that work for you?