I have an action set up (on table Districts) to go to another view within the app (table Assigned Coaches), which is set to Display Prominently. I would like the button to only appear if there are actually any assigned coaches to the district. I have a ref column set up (Short Name) that is the same on both tables.
I believe the solution lies in an โOnly if this condition is trueโ expression, but I just donโt have the fluency to figure it out. Iโve tried several things with INDEX(), IN(), and CONTAINS() and have read all the help files on these. The closest I came to is:
CONTAINS(Coach Assignments[Short Name],[Short Name]=[_THISROW].[Short Name])
But this doesnโt return a True/False value.
Any assistance would be most appreciated.
Solved! Go to Solution.
Hi @David_Hundt
Maybe this ?
ISNOTBLANK(
FILTER("Coach Assignments",
[District]=[_THISROW].[District]
)
-LIST("")
)
EDIT:
I forgot some explanations going with my answer.
With CONTAINS, you are comparing strings of characters.
I think in your case, you just want to test if an item is in a list, and more specificly if a filtered list is blank. This is why I use a FILTER combined with an ISNOTBLANK expression.
Hi @David_Hundt
Maybe this ?
ISNOTBLANK(
FILTER("Coach Assignments",
[District]=[_THISROW].[District]
)
-LIST("")
)
EDIT:
I forgot some explanations going with my answer.
With CONTAINS, you are comparing strings of characters.
I think in your case, you just want to test if an item is in a list, and more specificly if a filtered list is blank. This is why I use a FILTER combined with an ISNOTBLANK expression.
Thanks so much, @Aurelien! It worked perfectly. I really appreciate the explanation to go along with it.
You are welcome
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |