Form
I am in need to create an order form but unsure of how to do it. Form has multi select dropdown list with all the inventory. Each person will select based on their request but then I need an box with the quantity of each item requested. Any ideas on how to do this?
Best Answer
-
If you want to select multiple items in one cell (multi select) and also assign specific quantities to each item, it will be difficult to do so.
I would instead break down your order workflow into a two columns for each item. First, what is being ordered and then the quantity needed.
You can make this easy with a field in the form to select the number of items needed and then use form logic to show appropriate fields for this many items.
With multi select, it will get complicated and difficult to pair the quantities to the appropriate item. Single select will also allow you to query a database or create one and stay up to date on orders, sales figures, or whatever it is that is of interest to you.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Answers
-
If you want to select multiple items in one cell (multi select) and also assign specific quantities to each item, it will be difficult to do so.
I would instead break down your order workflow into a two columns for each item. First, what is being ordered and then the quantity needed.
You can make this easy with a field in the form to select the number of items needed and then use form logic to show appropriate fields for this many items.
With multi select, it will get complicated and difficult to pair the quantities to the appropriate item. Single select will also allow you to query a database or create one and stay up to date on orders, sales figures, or whatever it is that is of interest to you.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
I figured! thanks for the info I will give that a try
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!