Generating Unique Username and Linking the sheets
Hi,
I have a sheet which collects participants information, where the individuals who are interested in the enrolling to research study will get registered by submitting the form. And we need a column which captures a username of their interest (or at least by giving them a choice to enter their username by specifying a suffix or prefix in the help text under the field.) And within the sheet we will have an internal automated ID for every submission.
Now, I have another sheet which captures the information from participants who registered after the study period begins, and I want to link both the sheets based on username (because this will be the only common column in both sheets). Even though the participants enter the wrong username they will be able to complete and submit the form. So how do I connect both the sheets in this case? Are there any other possible workarounds? Any help is appreciated.
Thanks,
Mounika
Answers
-
Hi @Mounika, if your username is the unique ID, you’re kind of stuck. There are workarounds, maybe, but best thing would be to fix the username. Can you just update the username if you get an entry that doesn’t match?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives