Question

Gateway Conditional Expression using table column token contains

Forms Version 10

Updated June 22, 2020

asked on January 28, 2019

I have a form that has a table with a Condition column. The Condition is a Radio Button with 4 options and one of the options is "Needs Maintenance". In my process modeler, there are 2 routes; Needs Maintenance, and all others. I am struggling to get the Gateway Conditional Expression to work properly because the token for the column is a multivalue token and I am not seeing an option for using contains. How do you create conditional expression for a multivalue token?

I tried to make the Default route the Needs Maintenance branch with a Does Not Equal condition on the No Maintenance branch, but everything processes through the No Maintenance branch

What do I need to do to be able to use a contains or not contains condition?

0 0

Answer

SELECTED ANSWER

replied on January 28, 2019

Here's an idea

I created a form with a table that has a radio button column just like yours. My choices are choice 1, choice 2, and choice 3 with values of choice_1, choice_2, choice_3 respectively. I would use a hidden field to determine whether Needs maintenance was checked anywhere. In my example, let's say that's choice_1.

Create a hidden field called "Needs Maintenance?" and set the calculation to be

=COUNTIF(Table.Column_1,"choice_1")

where table.column1 is your radio button column and choice_1 is the value for the Needs Maintenance choice. This calculation will go through each row in the table and add 1 whenever Needs Maintenance is selected. Then for your gateway, if Needs Maintenance > 0, at least one of the rows needs maintenance and should go to that user task.

1 0

replied on June 22, 2020

Just a quick note to let you know your response helped me as well. I needed to do this exact thing on a form and this worked beautifully! I have marked your response as "Helpful." Thank you!!

1 0

Replies

replied on January 29, 2019

Thank you! That did exactly what I needed.

0 0

You are not allowed to follow up in this post.

Question

Question

Gateway Conditional Expression using table column token contains

Answer

Replies

Sign in to reply to this post.