Question

Zero ("0") in empty field being populated by forms during a concatenate function

Forms

Updated March 12, 2019

asked on March 4, 2019

I have 3 fields First Name, Middle, Last Name. Middle Name is not required and we are using a hidden field to concatenate the 3 fields into one. this was working fine until recently when it (forms) started putting a "0" (zero) in the space for middle name if there was nothing in the field. Has anyone else run into this? In the past if I entered John Doe with no middle name it created the hidden field of John Doe - now it creates John 0 Doe.

0 0

Replies

replied on March 5, 2019

I tried to reproduce this in 10.4 and couldn't. Could you provide more details like what version of Forms you are on, the exact calculation you are using, what (if anything) changed before you started seeing this issue?

It may be easiest to open a support case so the support team can look at the issue more closely.

0 0

replied on March 5, 2019

We are on 10.3 for Forms. I had removed a hidden field from a couple of the forms in a process and then added them back when it was determined it was needed for a email notification. I was able to use the same exact concatenation on a test form I created without any issue. It seems like the act of removing and adding it somehow corrupted it.

We have a work around for now that adds an"if" statement in the concatenate function so that we did not have to delete and re-add the variable since it is used in many places throughout a very large forms process.

0 0

replied on March 11, 2019

Hi Christine,

Generally empty number field would be treated as 0, but single line field would not. But in some functions empty string in single line is also treated as 0, like VALUE(Variable).

Which kind of field did you use in the formula? And what is the detailed formula that you used to generate the name?

0 0

replied on March 12, 2019

We have added an "IF" statement to get around the issue, but it is a single line variable for middle name, which sometimes does not exist. When it did not exist it was putting a "0" for the middle name which some people were mistaking for an "O" It was just concatenating first, middle, and last name.

0 0

replied on March 12, 2019

Did you used lookup rules/field rules on the fields? If so, can you try remove the rule and see if the formula itself work as expected?

0 0

You are not allowed to follow up in this post.

Question

Question

Zero ("0") in empty field being populated by forms during a concatenate function

Replies

Sign in to reply to this post.