dynamic enumlist

AppSheet AppSheet Q&A
1

Hi all,

I am struggling with an expression. I need to get a dynamic filled drop down box based on a selection of an other dropdown box in the same table/formular.

I have a table with people who offer services like barkeeper, hostess, etc. → EnumList: PERSON[Services] and PERSON[PersiID] is the key in this PERSON Table.

I have a table of Events where I have two drop down boxes. The first one ist the requested services (also an enumlist) and a second dropdown box where I need the persons(personID) based on the selection of the first drop down.

So if I have an event where only barkeepers are requested, in the second drop down there should only show the persons who are barkeepers.

I have this validIf expression in the EVENT[PersonID] table without errors, but the result is not correct:

select (personal[PersID],in([Service], PERSONAL[service]), true)

Any suggestions?

thanks!

2 
FILTER(
 "personal",
 IN(
  [_THISROW].[Service],
  [service]
 )
)
FILTER() - AppSheet Help

IN() - AppSheet Help
Dependent drop-downs - AppSheet Help

2 Likes
3

Almost :slightly_smiling_face:

If I select a barkeeper I get now all the barkeepers, If I select Barkeepers and Hostess, the list is impty because no one has this combination.

I need the persons (who have multiple disciplines) if either one of them is selected too.

Thank you!

4

Then tweak the filter expression to include an OR() statement

1 Like
5

Yikes, I didn’t see that:

Then everything gets waaay more cumbersome and I don’t have time right now

2 Likes
6

Persons who have any of the required services:

IF(
  ISBLANK([Services],
  Person[PersonID],
  FILTER(
    "Person",
    ISNOTBLANK(
      INTERSECT(
        [Services],
        [_THISROW].[Services]
      )
    )
  )
)

Persons who have all of the required services:

IF(
  ISBLANK([Services]),
  Person[PersonID],
  FILTER(
    "Person",
    ISBLANK([_THISROW].[Services] - [Services])
  )
)
1 Like
7

Thank you Steve, I needed the first statement.

Robert

1 Like
8

Thank you anyway. :slightly_smiling_face:

1 Like