Filtering an enum list

[Bcoley]

So I have an enum list which I want to populate from a table of personality traits. The personality traits table has a corresponding contactid that is a reference to a Contact table. However, I want the user to enter several new traits in the personality trait table for themselves and then choose the top 3 traits. So I have a field in the Contact table which is an enum list that is connected to the personality trait table; however, it brings back all the personality traits for everyone instead of just the person whose record I’m on. How can I filter the list to only see that user’s personality traits for them to choose the top 3? I tried basing the data validity on a slice but it didn’t work…don’t know if I’m thinking about this all wrong. I also tried doing a “REF_ROWS” function in the data validity but it only brings back the ID because it has to link to the ID. Any help appreciated.

[Steve]

Valid If to select a contact’s own traits:

SELECT(
  Personality Traits[Trait Name],
  ([_THISROW] = [ContactID]),
  TRUE
)

Sorted alphabetically:

SORT(
  SELECT(
    Personality Traits[Trait Name],
    ([_THISROW] = [ContactID]),
    TRUE
  )
)

Allow only 3 (untested):

SORT(
  IF(
    (COUNT([Top 3 Traits])) < 3),
    SELECT(
      Personality Traits[Trait Name],
      ([_THISROW] = [ContactID]),
      TRUE
    ),
    [Top 3 Traits]
  )
)

[Bcoley]

Steve- thanks for all your help…syntax is everything so thanks for this

Bryan Coley
Chief Creative Officer

Reel Experiences

REEL EXPERIENCES

REEL EXPERIENCES- connecting your team with your favorite movies

We use your team's favorite movies to increase connection, collaboration, engagement & celebrate diversity. Team Building that's insightful!

[Wojciech_Sz]

Hi!
How to filter “Kondygnacja” to show in list only rows with contains “Inwestycja” name in it? Pic related.

[Steve]

help.appsheet.com

Dropdown from Valid_If

How to create a dropdown that depends on a particular list of values.

[Wojciech_Sz]

Can you help me with that? I still cannot do this properly.

[Steve · Accepted solution]

Try something like the following as the Valid If for the Floor column:

FILTER(
  "table",
  AND(
    ISNOTBLANK([column]),
    ([column] = [_THISROW].[Inwestycja])
  )
)

replacing table with the name of the table referenced by the Floor column, and column (twice) with the name of the column in that referenced table that would match the value in the Inwestycja column of the Assets table.

[Wojciech_Sz]

It works, thanks!

Going one step more…
Is this possible to automatically make growing numeration of every part of this scheme?
For example:

1. Sun/1/1 , Sun/1/2 and so on
2. Sun/1/1, Sun/2/2/ and so on

image|281x500