Select Items from list and add quantity?

[Evgenii_P]

I want users to select multiple items from a predefined list and specify a quantity for each. For example:

What furniture will you need for your event?

A user can select multiple items, such as "Table" and "Chair," from the dropdown list, and then specify a quantity for each, like "4 tables" and "10 chairs."

Any idea how to make it happen? 

[WillowMobileSys]

I'll assume you are aware of AppSheets supported feature of a Parent/Child where you would typically add the children one by one from the Parent Form - including any additional details for THAT child as you add it.

Instead, you are asking to use an EnumList as a quick way to select the items but then want to add the quantity in some way AFTER they have all been selected.

This is not an "out-of-the-box" feature.  You can create something.  Do note that you cannot perform the selection of items and then add the quantity all in one Save action.   It will need to be done in 2 stages.

What I would do is add a set of actions that are executed on Save of the Parent Form.  The actions will take the chosen items in the list and transform them into Child rows.  Then as a last action,  use the LINKTOFILTEREDVIEW() function to open those newly added rows into an EDITABLE table view.  In this view you can travers down each row and adjust the Quantity AND/OR any other attributes on each item you might want to keep track of in your app.

I hope this helps!

[Evgenii_P]

Thank you for your response. Here is my somewhat awkward workaround:

 Here is the formula I used for the quantity field:

SUBSTITUTE([Event Resources List], ",", "#,") & " #"

What do you think?

[ikerroo]

I came up with a slightly better workaround that might work for you. It's not perfect as you can not see the item and increment the quantity inline, but it's close. I use a google sheet for my data source. What I did was create a list for possible items to choose from. I then have a field called "Order Items" which is defined as an emumlist which allows the user to select all the items they want. I then created 10 fields in the same sheet called 'Item 1', 'Item 2', ... 'Item 10". I then created 10 virtual fields called "Item 1 Name" = INDEX(SPLIT([Order Items],","),1), for each item number. Lastly, I then use a conditional "Show" for each of the 'Item 1' -'Item 10', which only shows the field, if "ISNOTBLANK(Item 1 Name), and then have the Display equal to "Item 1 Name". 

The way it works is if you select three items in your "Order Items" field, it then dynamically adds those items to the bottom of the form with the appropriate Item Name and allows you to set the quantity. Once you select the items the fields show up immediately, so while not perfect. you get a row in the spreadsheet with the selected items and their quantity. I then use google sheets to format the list in a more user-friendly view for the viewers of the spreadsheet. 

This is the first time I've ever posted here - so I'm hoping this is helpful. 

[Steve]

I have an app that works this way. Great if there are only a small number commonly-ordered quantities.