3

I have linked multiple Google forms to a single Google spreadsheet (each one to a new tab in the sheet) and I now want each response be assigned a unique identifier when it is received.

I've tried methods on here that generate sequential numbers based on the row, but as I have multiple forms, that will end up with duplicate numbers across tabs.

Is there a way to prefix each identifier with a word?

I tried to do this by combining using the tab name with the row number but couldn't get it to work.

Improve this question
1
  • I see two options: 1) Create a custom script to add a unique ID to each submission on the form submission. 2) you could use a QUERY() formula to query each and include a column for the tab name and then combine that with the timestamp in another column. To do the QUERY() option try adapting the first formula in this post
    – Karl_S
    Mar 30, 2017 at 14:41

1 Answer 1

Reset to default
1

Each Form Responses has a unique Timestamp which will be unique. You can convert that into a string and use that as an identifier. Here's one such example (assuming cell A3 has the form response timestamp)

=REGEXREPLACE(TO_TEXT(A3), "\D", "")
Improve this answer
1
  • That's great for unique identifiers, but what if I need it to be sequential? Can I set a prefix and starting number for the rows in each sheet?
    – pwq
    Mar 17, 2017 at 14:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.