How to create a request order form for multiple items/quantities
Hello Smartsheet Community,
The basic order form from the "Workforce PPE Inventory Tracking" template set only allows one item and quantity entry per row per and per request tracking number. Is it possible to add/associate multiple items and quantities in multiple rows to one request tracking number?
The basic order form format assumes either the customer only wants to purchase one item or the customer is willing to input a multi-item purchase one line item at a time and by utilizing the single entry form multiple times, thus resulting in a different tracking number per item for one complete order.
How would I build a Smartsheet form that will accommodate multi-item orders, by placing each order item and its quantity in separate rows on the request sheet, while associating all row items in the order with one tracking number and by one-time data entry to the request sheet form?
Please advise.
Angela B.
Answers
-
Hi @Angela B.
I hope you're well and safe!
I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hello @Andrée Starå ,
Thank you for your response. I sent you an email not too long ago, I would appreciate receiving the example you've mentioned. Hopefully, your example will get me on track.
Best regards,
Angela B.
-
Hello @Andrée Starå -
Could I also receive an example of this?
I need an order form that allows the user to designate different quantities for multiple items needed for their project.
Thank you!
Miriam S.
-
Hi @Miriam S
I hope you're well and safe!
I'd be happy to share an example.
Please send me an email at andree@workbold.com, and I'll share it with you.
I hope that helps!
Have a fantastic week & Happy Holidays!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hello @Andrée Starå,
Would you mind sending me a copy as well? I've been struggling with this for a while. I tried to email you @ andree@workbold.com, but haven't received a response. Thank you so much!
Best,
Melody
-
Hello @Andrée Starå ,
Would you mind sending me a copy as well? I've been struggling with this for a while. I tried to email you @ andree@workbold.com, but haven't received a response. Thank you so much!
Best,
Paul
-
Hello @Andrée Starå ,
I know this is an older thread, but this sounds like exactly something I am looking to implement for us at our company. Could you please share your example with me? I'll also send you a PM.
Thanks again,
Ken
-
Did anyone use the sample Andre provided?
-
@Andrée Starå Would you be able to send me this as well? Thank you in advance.
-
I am also looking for this template.
@Andrée Starå Could I also please get a copy?
-
Hello,
I would like an example of how to create a request order form for multiple items/quantities as mentioned in this thread. Thank you
Brenda M
-
Hi @Kenneth Kollin @BartManion @Connie Cochran @12edrah @Brenda M
I hope you're well and safe!
I'd be happy to share an example.
Please email me at andree@workbold.com, and I'll share it with you.
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå I emailed you requesting the example of your solution. Please let me know if you need me to email you again.
-
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
@Andrée Starå can I get the example as well please?
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