How to create a service work order using a smartsheet form?
I'm trying to set up a work order form for my service techs. I want to automatically pre-populate customer information from my sheet to the work order form so my techs know where to go and then they can fill out the remaining fields.
Can I have some fields automatically filled out from my attached sheet to the form? Ex. Columb Name=Address and Value=123 St Name.
Thanks in advance!
Best Answer
-
Hi Donny
This isn't possible out of the box, but you can still achieve this by following the steps below- Use your first sheet that contains the customer information.
- You need to add a column in this sheet and use join function (https://help.smartsheet.com/function/join) to join your URL with the form fields. The column will generate link to the form, with query string (https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values). This will pre-fill the form with the customer information.
- You can then share this link with your service techs, where the fields from the first sheet will be already filled in.
Let me know if this helps. If you are not an expert with Smartsheet, I can help you build this. Feel free to buzz me on LinkedIn.
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/
Answers
-
Hi Donny
This isn't possible out of the box, but you can still achieve this by following the steps below- Use your first sheet that contains the customer information.
- You need to add a column in this sheet and use join function (https://help.smartsheet.com/function/join) to join your URL with the form fields. The column will generate link to the form, with query string (https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values). This will pre-fill the form with the customer information.
- You can then share this link with your service techs, where the fields from the first sheet will be already filled in.
Let me know if this helps. If you are not an expert with Smartsheet, I can help you build this. Feel free to buzz me on LinkedIn.
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/ -
Hey Amit, thanks for the quick response. I am very green with smartsheets so i'll let you know how I make out.
Thanks again, much appreciated!
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