You are viewing limited content. For full access, please sign in.

Question

Question

multiple entries Populate in one single line field

asked on October 18, 2018

I've been using LF forms with my company for over a year now. Most of the forms were already created for before I arrived, but I have been learning on my own (just now discovered this Community group).

 

On our form, a user would enter in a number (which would populate from one database) and fill the next three lines, then the fifth line would be based on the number entered in the first line (5th line pulls from 2nd database). Is there a way to do ONE single line field, and have the entry from the first line populate (possibly as uneditable text?) and concatenate it with the data from the 2nd database?

A little more explanation (if needed): In the two databases, say the number "12345" exists in Database 1, and in database 2, the number "003" is paired with that number.... that being said....

IF the number "12345" was entered in Line 1, it would carry down to Line 5 and populate the line to show "12345003". Currently I have it to fill just "003", but need BOTH numbers.

Is that possible? If so, How?

Thanks for any and all help and guidance.

0 0

Replies

replied on October 18, 2018

You could keep what you have with the separate lookups, then have a sixth field with the formula =Concatenate(field2,field3) <- not the exact formula

Once you have that sixth field working, you could hide field 2 and/or field 5 so you only showed the concatenated field from the two lookups. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.