Filter by enumlist in user cadaster

[LeoSants]

Hi guys!

I need help in something.

I have in my user cadaster one column called "unidade", this is the locals where the worker do his job.

And i have the inventory, when this workers gets items from his locales.

The thing is, i need a slice or filter to do a simple thing, the worker only can get the items from this locales registered in his cadaster.

This is the ENUMLIST

This is the view of inventory, when this worker get the items

One example of that: Steve in his cadaster, have a LOCALE A, LOCALE B, LOCALE C, so when his going get the item, the current option in his cadaster is appear to him only this locales

[Marc_Dillon]

I don't know what "cadaster" is, is that important to your question? Is that an untranslated word here while the rest of your post is translated?

I'm not entirely sure what you're asking, but you definitely need a valid_if expression.

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

Which will probably include a SELECT()

https://help.appsheet.com/en/articles/2357314-select

And maybe you're looking for "dependent dropdowns"

https://help.appsheet.com/en/articles/961554-dependent-dropdown

[LeoSants]

Hello March, let me explain better, imagine you have a employe, and this employe can get items to do his work, tools and etc, but this employe only can get items for the locales who his is registered, so in his registered you defini this.

Is exactly i am looking for, because in my base - register, i have this employes and this locales is a enumlist, and i have other base called "inventory", and this employes only can get item for the locales in register.

Now when i test that, the app bring me one single line concatenate with ",".

Let me show in this print.

Im tryng to use slice, but i don't know this is the best solution

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2357340-split

[LeoSants]

Thanks Marc, worksssssss!

I do it a select condition within a split