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

Question

Question

Forms Calculation to populate a field from two others

asked on October 2, 2017 Show version history

On other answers posts it seems that we can use Forms calculations to copy information from one field to another.  These calculations seem to be based on Excel.  

What we have are two fields"  First Name and Last Name.

In other parts of the forms we have various instances of Applicant Name.  All I want is for Applicant Name to populate with the First Name Last Name.

With Forms Calculations, one field works fine.  However, when I try two, it doesnt work.  Using Excel formula logic the following works (in Excel):   =A1 &" " & A2

But when I put this into the Forms calculation, nothing works:  =First_Name & " " & Last_Name

Putting in =First_Name & Last_Name works but has no space.

Is there a way to simply get a space in between the two?

EDIT - I have also tried:  =CONCATENATE(First_Name, " ", Last_Name)  works fine in excel but not in forms.  Seems to be totally limited to a space character.

Thanks,

Chris

0 0

Answer

SELECTED ANSWER
replied on October 2, 2017

From previous discussions here the concatenation with a space is a know issue.
You can use some java script as seen in this post:
https://answers.laserfiche.com/questions/94948/Combining-Forms-Fields-Values  

 

0 0
replied on October 2, 2017

Thanks, was trying to stay away from JS but if there is an issue with the built in space we will go with it.

0 0

Replies

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

Sign in to reply to this post.