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