Exclusive gateway not working as expected

asked on August 31, 2023 • Show version history

Hi all,

I'm currently on Forms update 3.

I believe forms doesn't allow you to return the latest value for a column variable, so I followed this post.

Here are my outflow paths:

I created a hidden value within a form to get the amount of rows. I am able to get the correct amount of rows.

In the above exclusive gateway, it's defaulting to Service Task (3) when it should be going to End timer.

In the Email Service Task (3) task I am telling it to email me the latest value:

As you can see, it's able to get a value. The string has no spaces before or after.

Any insight as to why it's defaulting to that?

Since Checked = Checked shouldn't it go to End timer?

0 0

SELECTED ANSWER

replied on August 31, 2023

First, the variables in the gateway conditions should not be wrapped in curly brackets.

When you add the tokens to an email, among other things, you'll see them wrapped in brackets because that's a placeholder for dynamic content, but it doesn't add them when you use the UI to add a gateway condition.

Also, make sure the "last row" field is a Number type otherwise it would be evaluated as a string/text by default which isn't what you want. See the following link:

Using Conditional Expressions (laserfiche.com)

If it still doesn't work after all that, then you may be having the same issue that other user mentioned about not being able to use variables for the index.

If that's the case, then just update your hidden field so that it retrieves the actual value of the last row rather than just the index of the last row.

For example,

=INDEX(Table_Column,COUNTIF(Table.Column,"<>"))

That might be more efficient anyway; if the only reason you need the index is to reference the value, then you might as well just grab the value on the front end.

Then, you can just use that field directly in the gateway condition without all the complication.

1 0

replied on August 31, 2023

Thank you, Jason!! This resolved my issue. I took out the brackets and used /dataset/number(value) to convert the string.

1 0

Question

Question

Exclusive gateway not working as expected

Answer

Replies

Sign in to reply to this post.