Condition for Behavior

[alhazen]

Hello guys,

I need your help

I want the "add" action to appear when [related hazards]>=1.
I used this formula COUNT(schedule[Related hazard])>=1, but it didn't work. is the formula I'm using wrong?

Thank you for your help.

 

[TeeSee1]

Try

 COUNT([Related hazards]) >= 1

[alhazen]

[Related Hazard] is a ref type column in the Schedule table, meanwhile i set the "add" action for hazard table. It's definitely not working.

I tried use this formula Count(select(Schedule[related hazards], [id]=[_THISROW].[schedule]))>=1, but still not working

[dbaum]

Add is not a row-level action and, so, can't reference values from a current row, such as a parent id.

I don't have experience with your specific scenario, but maybe the following would work for the context you mention?

COUNT(hazard[id]) >= 1

Maybe you could meet your need in another way? For example, don't even show the [Related hazards] column in the form if it's empty?

ISNOTBLANK([_THIS])

[Steve]

There is no trivial way to accomplish what you want. To get it, you'll need to add a slice of the table that doesn't allow adds. You could either use that slice to display the hazards and add an action button to allow adds, or add a virtual column that uses the slice and use Show_If to display the hazards list that's appropriate to allow adds.