I have a question regarding workflow: If I ch...

expressions
(Yossi Oulu) #1

I have a question regarding workflow: If I change a column value from “0” to “1” and I would like to execute two Webhooks when this happens. If I create two workflows with the expression

AND([_THISROW_BEFORE].[Status]<>[_THISROW_AFTER].[Status], [_THISROW_AFTER].[Status]=“1”)

in each one of them, will both workflows be activated?

(Reza Raoofi) #2

The answer is yes, both workflows will be executed; you could also use this expression: AND([_THISROW_BEFORE].[Status]=“0”, [_THISROW_AFTER].[Status]=“1”)

That is if [Status] is a text column; if it is number column type, you would of course remove quotation marks.

(Yossi Oulu) #3

Thanks. Regarding the “1” instead of 1 For some reason sometimes when I set Status to be number e.g. [Status]=1

it gives me the error: “The expression is valid but its result type ‘Number’ is not one of the expected types: Ref” I understand that status is a reference, it is a reference to a table with key of type Number, but its value is indeed 1… what is the issue here?

If I use “1” then it does not complain. Not always this is so, any idea?

(Reza Raoofi) #4

Not sure, this a completely different question than your above post, need more details, but off the top of my head, perhaps the base type in that Ref column does not match and has remained as text.

#5

Hi @Yossi_Oulu I find you have to set the base type of the column if is going to be different from the default,

and save it and then go back and set the Ref and save it again.

(Yossi Oulu) #6

@Lynn that might explain it. Thanks… ill try