valid_if expression

[provisrudd]

So i have a form where you can choose between two options "Remove" or "Return"

Another section of the form ask how much?

Is there an expression to use if the choose the option to "Remove" that the value can either be 0 or a negative value and vice verse with Return with positive values?

Would this be an OR statement?

[Rafael_ANEIC-PY]

Hello @provisrudd , you can use this expression, as you know, in your valid_if():

SWITCH(
[Options],
"Remove",[_THIS]<=0,
"Return",[_THIS]>=0,
TRUE
)

[provisrudd]

I keep on getting error?

The column type is number

[Options] is enumlist

SWITCH function is used incorrectly: Cannot convert input 2 of type 'Text' to 'List of Text'

[Joseph_Seddik]

Your "Options" column should be Enum, not EnumList.

[provisrudd]

Hello,

Its got to stay as enumlist because I have other combinations. 

OR([Action]=list("Return"),[Action]=list("Return","Closing Count"),[Action]=list("Remove"),[Action]=list("Remove","Opening Count"),[Action]=list("Opening Count"),[Action]=list("Closing Count"),[Action]=list("Restock"))

Is there a workaround possibly?

[Joseph_Seddik]

There’s a solution not a workaround. Do you want to base the decision based on the existence of “Remove” or “Return” among other possible values or just “Remove” or “Return”?

[provisrudd]

oh yah that would be great if it could be based on the existence rather than just those terms. 

[Joseph_Seddik · Accepted solution]

IFS(
  IN("Return", [Options]), [_This] > 0,
  IN("Remove", [Options]), [_This] <= 0,
  TRUE, TRUE
)