I want to allow duplicate values in the field external order id, if the value of order type is repeat.
I am trying to use the following cote (I’m a noob):
and( [_thisrow].[order type] = “New”, Not(IN([_this],Select(FSV[External Order ID],true))))
Order Type accepts two values (enum) - New/ Repeat.
I want External Order ID to accept a duplicate value as long as order type for that particular row is Repeat
How can I do that?
Solved! Go to Solution.
OR(
[order type] = "Repeat" ,
NOT( IN( [_THIS] , FSV[External Order ID] ) )
)
OR(
[order type] = "Repeat" ,
NOT( IN( [_THIS] , FSV[External Order ID] ) )
)
This workd like a charm! Thank you SO MUCH!!!
If I could ask, what was I doing wrong?
You used AND instead of OR, you don’t need the “[_THISROW].” when you’re referencing a column value from the current context (current record), and table[column]
is equivalent to SELECT(table[column],TRUE)
.
Got it. Super helpful!!
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |