How do I capture data via a form and link it to a unique identifier I already have on a sheet.
Problem:
We have a list of students with Unique student ID's.
We intend to carry out a training session for students on this sheet and need to record their attendance .
Ideally if i can have a form link made into a qr code that students just scan and enter or select their student ID ( this data is already on my sheet). Once they select their ID they just click submit which should then capture date and time submitted as an attendance timestamp. Also once done the link should not allow them to use it again.
Any help partly of fully to provide a solution would be very welcome
Answers
-
I would suggest having the form attached to a second sheet then using an INDEX/MATCH or VLOOKUP to pull in the time stamp to the record sheet.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives