Hi.
Am I pushing the limit of behavior rules by running a query on children records to determine if an action button should be displayed?
In the example below the action button GA1 Run Start is displayed even if the behavior query returns a negative value.
Solved! Go to Solution.
It sounds like @Steve got you fixed up. For what its worth, when I am checking for existence of rows I typically use COUNT(). Depending on what I need/want, I use COUNT() = 0
or COUNT() > 0
.
ISBLANK() just never feels right to me when its a list of values being returned. For example what happens if only one item is returned and it is a blank?
EDITED: so I would implement it very close to what @Steve did but using COUNT() like this:
COUNT(
FILTER(
"Log bdt",
AND(
[Bon de travail ID] = [_THISROW].[Bon de travail ID],
USEREMAIL() = [Usager],
ISNOTBLANK([Date debut]),
ISBLANK([Date fin])
)
)
) = 0
User | Count |
---|---|
35 | |
34 | |
27 | |
23 | |
18 |