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.
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
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.
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
-
I figured! thanks for the info I will give that a try
Help Article Resources
Categories
Check out the Formula Handbook template!