adding multiple locations

[Pieosonic]

Hi totally new to this so excuse me, i have an inventory app i managed to customize.

im looking to alter the quantity of an item but located in different locations, as in stock stored in different locations but using the same item number/part number.

ive added some screen shot, hope you can help and thanks for reading this.

[Gustavo_Eduardo]

Hello, have you thought about adding an EnumList-type column with a Ref base in a locations table?

[Pieosonic]

thanks for the suggestion, i wouldn't know how to do this, do you have anymore information on this?

[Gustavo_Eduardo]

Sure, add a table with locations.

Then add a column in the table you want the "multiple locations" and set it to Enumlist type. Go to the column configuration and, where it says "base type", choose ref and search for the newly created table of locations.

Then in "valid if" or in "suggested values" write TableOfLocations[id]

There you can have several locations assigned to a single line

[Pieosonic]

This didn’t work for me unfortunately.

[Pieosonic]

I have tried with no luck, this is the app I'm customizing: https://www.appsheet.com/templates/Manage-inventory-levels-stock-value-and-vendor-details?appGuidStr... 

any help is appreciated. i will look into it more tomorrow but if you could explain using the template above would be great.

thanks again.