Form to populate answers against unique ID
Hi Team,
I need to collate data from employees for an upcoming project. Has the form got functionality to recognise unique identification between answers and link it to relevant row yet?
My ideal sheet would have all employee names, their unique staff ID and relevant fields I will ask them to give me answers for via the form shared to all.
Current plan is to use VLOOKUP between answer sheet and master sheet.
Another option would be to go by requesting for updates from unique users within original sheet but this removes logic from the form and mandatory fields..
I wonder if there is a more efficient way?
Many thanks,
A
Best Answer
-
Hi @Aiva , that’s excellent! I’m 100% confident that using Dynamic View for your situation is the way to go. If you have any issues getting that going, just let me know and I’m happy to walk you through examples of how I’ve done exactly what you are wanting to do!
Will
Answers
-
Hi @Aiva , do you have access to Dynamic View? This is the classic use case for DV. It allows you to create a filtered view on "current user" that would allow you to give that access to all employees to get the additional data you need from them into your ideal sheet.
If you don't have DV, then there are likely smart ways to use an Update Request automation to accomplish your goal. Let me know if you need more help working through that route!
Best,
Will
-
Hi @Will Jeffords ,
I have DV view but never used it so will look into that! Many thanks for pointing this point
-
Hi @Aiva , that’s excellent! I’m 100% confident that using Dynamic View for your situation is the way to go. If you have any issues getting that going, just let me know and I’m happy to walk you through examples of how I’ve done exactly what you are wanting to do!
Will
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives