Adding first name lastname name to one field

Classic Servoy
1

Hello,

I have 2 data feilds “first_name” “last_name” I need to be able to display these in one feild eg “firstname lastname” or a label, would I do this with a calculation?. Previously I have acheived this by placing two feilds on the form and using horizontal justification, but it does cause problems depending on the length of each name.

2

Hi Phil

Yes, just use an unstored calculation field:

return first_name + ' ' + last_name;

If you want to Search on this field or sort it in a table you will need to make it a stored calculation. To do this just create a standard field with exactly the same name - I tend to use names like name_firstlast_cs with the ‘cs’ denoting its a calculated stored field.

HTH

Graham Greensall
Worxinfo Ltd

3

Many Thanks Graham, works like a charm.