Options for creating a look up tool...
Hello!
I am trying to think of all of the ways to create a look up tool in Smartsheet that can be accessed by non-Smartsheet users, without the non-Smartsheet users being able to see the back end.
We will only be collecting the email addresses of the non-Smartsheet users and then returning the name and email address of their committee representative.
The initial entry point for the non-Smartsheet user would be a Smartsheet form, but I wonder how to proceed from there...
I could use form logic to return the name and email address of their representative.
I could use automations to email them the name and email address of their representative.
But, the issue is, there are a lot of constituents (over 5,000) and this would need to be updated at least once a quarter when the new constituents are added/removed. So, manually clicking each email address isn't really an option. Currently, automations won't allow me to copy and paste multiple values into the trigger point section or in the condition section.
Can anyone think of a better way of doing this? Perhaps setting up the back end with the constituent list and then making that work somehow?
Thank you for your help and advice!
Answers
-
Are you able to provide some screenshots for context?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi @Paul Newcome... I'm still in the planning phase, so I don't have any screenshots to provide.
-
What about sample data manually entered to mimic the desired outcome or something? I'm having trouble visualizing what you are trying to do.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 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
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!