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!
Solved! Go to 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]) ) ) )
Huh? Show some examples.
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
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.
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]) ) ) )
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |