Question

Forms making a decision based on whether a field is empty?

Forms

Updated January 20, 2017

asked on January 19, 2017

I am working on a Forms BP and I need it to skip to the next step if a working Lookup based field is empty.

There is no "is empty" decision maker variable in the output of a Forms activity. Is there a way that I can do this?

0 0

Answer

SELECTED ANSWER

replied on January 19, 2017

If you are referring to a condition on a Gateway, you can do that based on if the field is empty. For example, see the picture below.

In this case it is checking to see if the Address field is equal to "", which equates to empty.

3 0

replied on January 19, 2017

That's a lot simpler! Thanks Blake, I didn't realise that was an option. :o)

1 0

replied on January 20, 2017

Oh dear, that is incredibly simple! Thank you! I was thinking of all this crazy ways to do it and this is just better, I'll implement it like this.

-Alex Zapata

0 0

Replies

replied on January 19, 2017

Hi Alejandro,

You will probably be offered better solutions, but one approach would be to add another field in the form (hide it from users) which has a calculation in the Advanced field properties along the lines of:

=IF(LEN(insert lookup field name here)<1,"Empty","Not Empty")

Then in your process diagram, insert a Gateway with the outflow decision being based on whether the checking field in the form contains "Empty" or "Not Empty".

Cheers,

Mike

1 0

You are not allowed to follow up in this post.

Question

Question

Forms making a decision based on whether a field is empty?

Answer

Replies

Sign in to reply to this post.