Hi! Im creating and action and I want to display only when all the child records have some value in a specific column.
The reason is that I want the user first add specific values to childs records, and then preform an action on parent level.
any help will be aprreciated
Solved! Go to Solution.
solved!
on action behavior , show if option:
COUNT(SELECT(BASE PUERTAS[ID PUERTA], AND([ESTADO] = "CERTIFICADA",[ID OBRA]=[_THISROW].[ID])))=
COUNT(SELECT(BASE PUERTAS[ID PUERTA], [ID OBRA]=[_THISROW].[ID])))
Could be easier to write it like..
COUNT(SELECT([Related Childs][ID],[ESTADO] <> "CERTIFICADA"))=0
User | Count |
---|---|
35 | |
9 | |
3 | |
3 | |
2 |