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

Yossi_Oulu · 12-18-2018 04:00 PM

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?

RezaRaoofi

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

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?

RezaRaoofi

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.

Lynn

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

@Lynn that might explain it. Thanks… ill try

Allison_Romero

I am currently having this same issue. Can anyone help?

In Table 1, ClientID is a number column and is the key. I am inserting this ClientID in Table 2 using an action and the ClientID there will refer back to Table 1. The action won’t deploy from a workflow because “The expression is valid but its result type ‘Number’ is not one of the expected types: Ref”

I have tried setting ClientID in Table 2 to a number, saving, then changing back to ref and the problem persists. Please help.

Steve

A column of type Ref expects the key column value of the row to which you’re referring. Apparently, ClientID is not the key column for its table.

See also:

Allison_Romero

But ClientID is the key column of Table 1:

Steve

Please post a screenshot of his error and the complete expression to which it refers.

Allison_Romero

Here is Table 2, showing the Reference to Table 1:

Here is the action:

Here is the error:

Steve

Ah. Hmm… Interesting. I’d call that a bug! Try this:

([ClientID] & "")

Allison_Romero

Thank you for your help. I worked a way around it and will just go with that

Yossi_Oulu

this is a bug I reported a while ago.
it pops and goes without apparent reason.
what i do to overcome it is to define a virtual field of type ref instead of the original one. and leave the real field without ref.

בתאריך יום ה׳, 30 ביולי 2020, 22:11, מאת Allison Romero via AppSheet Creator Community ‏<appsheet@discoursemail.com>:

Allison_Romero

Also wanted to add that I have another action that references that ClientID from table 1 in an action and there is not an error

Table 3 referencing Table 1

Action with no error in the expression - if it causes an error in Table 2, why not Table 3?