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.
Best Answer
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)