Create a LOOP in condition in Action

[maxcime]

Hi all, 

I need to create a new condition in Action (Only if this condition is true).

The action button will be display only if all the children list is not empty if a variable is over a certain value.

The database is: an Analysis has some risks that have some action to do if the risk has value over 24 (for example). So I need to check if all the risks that have a value over 24, they have almost an action associated.

Can I do this in appsheet or I must use AppsScript?

Thank you so much, best regards!

[Marc_Dillon]

Huh? Show some examples.

[maxcime]

Hi all,

sorry for the delay. I try to explain better:

I have this structure:

Analysis, with many risks, with many actions, example:

Analysis

Analysis ID	Analysis Name
1	TestAnalysis

Risk

Risk ID	Risk Name	Analysis ID Ref	Value
1	Risk1	1	12
2	Risk2	1	26

Action

Action ID	Action Name	Risk ID Ref
1	Action1	2
2	Action2	2

If one risk has the value >= 24, I must insert some actions.

In the Analysys detail, I can APPROVE this analysis only if all the risks that have value >= 24 have some action.

So, my button APPROVE will be shown only if the condition is TRUE. To do this I need a Condition Loop/For, I think. Is it possibile?

Thank you so much!

Best regards

[lynchk21]

There is probably an easier way, but from what I understand above, I think you should be able to use an IN and SELECT function to write a condition. Something like this maybe:

IN([_thisRow].[analysis ID], SELECT(Risk[analysis ID ref], AND([Value]>=24, [analysis ID ref]=[_thisRow].[analysis ID ref])))

Making a slice with only risk values above 24 might be a better solution. 

[Marc_Dillon · Accepted solution]

So every Risk that has a value >= 24 must have at least 1 related Action?

ISBLANK( SELECT( [Related Risks][id] , AND( [Value]>=24 , ISBLANK([Related Actions]) ) ) )