display an action if all child records have some value

[jcmoras]

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 

[jcmoras · Accepted 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])))

[Suvrutt_Gurjar]

If you could mention the action type and where the action is based -parent or child table, then possibly the community could help you better.

[jcmoras · Accepted 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])))

[AleksiAlkio · Accepted solution]

Could be easier to write it like..
COUNT(SELECT([Related Childs][ID],[ESTADO] <> "CERTIFICADA"))=0