Filling names in on a form
I'm working on a cell phone porting project. I created a sheet that has each employees name, department, device, and phone number. I also created a form to send to the managers of each department. I want the manager to be able to see the names of employees and then select if they are "keeping and porting" or "returning" their device. If they are "keeping and porting" I want them to be able to select a date/time to meet with IT to do the device switch. I got all automation/formatting figured out. The part I need help with is can I and if so how can I auto-populate the employees names for each manager on their form?
Best Answers
-
You could build custom URLs for each manager, using URL string query to populate fields. These URLs could even be automatically created from your list of employees via a formula.
Have you also looked at using Update Requests instead?
-
Thank you that was very helpful
Answers
-
You could build custom URLs for each manager, using URL string query to populate fields. These URLs could even be automatically created from your list of employees via a formula.
Have you also looked at using Update Requests instead?
-
Thank you that was very helpful
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives