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.
How do I generate unique identifiers for responses from multiple forms, linked to a single Google spreadsheet?
google spreadsheets;google forms