Solved: Dynamic Enum Lists from Non-Selected Enum List - Page 2

D_harrier · 12-24-2020 02:56 PM

Greetings!

Here is my challenge that I am trying to solve. I have a database with over 300 sites, and 5000 objects at those sites. The sites get updates monthly, and the objects get updated weekly. Uploading one master sheet and building this survey tool is the most effective way to mange.

So here is the basis of what I have. Currently have a table with two reference columns that create dynamic enum lists for each. [Sites] and [Objects]. These are EnumLists, with the base type of Ref and the ‘Main’ as the table referenced above. This portion works great.

What I need… is we have 5 areas of conditioning that needs to be done on each object per site visit. I’ve got a form created that has each area in a tab, and the EnumList of the objects below. My challenge is that ALL of the listed objects must be conditioned each visit, and each object can only be conditioned in on category.

Example:
Good Condition - Tab (header row)
Enum List:
Object 1
Object 2
Object 3

Fair Condition - Tab (header row)
Enum List:
Object 1
Object 2
Object 3

etc…

If the user selected Object 2 and 3 in the ‘good’ tab, I would want those to be eliminated as selections in the ‘fair’ tab. Only Object 1 would be listed as only it would be selected. Finally, before submitting, if any object had not been conditioned, it would be listed on a ‘missing’ list, and require the user to go back and condition.

Any help is appreciated!

Thanks

Steve

Good enough! In your expressions, instead of using Sites[Objects], use this:

SELECT(
  Sites[Objects],
  AND(
    ISNOTBLANK([Location]),
    ([Location] = [_THISROW].[Location])
  )
)

This gets the Objects column values in the Sites table only from rows where the Location column has a value and that value is the same as the Location column in current Objects table row.