I have a field (label_heading) that I would like to fill with 3 other fields - first_name, middle and surname. I can copy and paste with a script, but it only shows the last copy and paste - the surname. I have also tried to make it (the label_heading field) a calculation, but it shows nothing. As in first_name& " "&middle&" "&surname. What am I doing wrong?

Thanks in advance for your assistance,

Roger

Hi Roger,

If you wish to set a Standard text field (named label_heading) with this concatenation (via script), it would be something like:

Set Field [label_heading, first_name & " " & middle & " " & surname ]

If you wish to use a text calculation, it would be:

first_name & " " & middle & " " & surname

I suspect your script wasn't working because, for copy/paste, the resultant field must be on the current layout ... or ... you weren't concatenating them within the script itself (as above) by attempting to copy each one individually(?). I would also verify that all fields involved are text data types.

Otherwise, unless there is something else, this should work fine for you.

LaRetta

The calculation should work as you have stated it. Is it set to be text? It could be improved to skip missing parts with IF statements.

If( not IsEmpty(First_Name), First_Name, "") & If( not IsEmpty(Middle), " " & Middle, "") & If( not IsEmpty(Surname), " " & Surname, "")

You can use Case instead of If and remove the null false results. Or you can get tricky,

First_Name & Case( not (IsEmpty(First_Name) or IsEmpty(Middle)), " " ) & Middle & Case( not (IsEmpty(First_Name & Middle) or IsEmpty(Surname)), " " ) & Surname