Hi All,
I'm searching a solution for following problem:
I have the table "kontakt" with fields like kon_surname and kon_firstname.
The record is used as a lookup in another table "order". But in the Customer Field of "order" I want to show the information of kon_firstname + kon_surname.
So far I couldn't find a solution how to get a value combined of 2 fields visible there.
Would be great if someone could help me.
Thanks a lot!
BR, Oli
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
how to create a value combined of 2 (or more) field values
-
kev1n
- nuBuilder Team
- Posts: 4307
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 446 times
- Contact:
Re: how to create a value combined of 2 (or more) field valu
Hi Oli,
You can use CONCAT() to combine multiple strings that are displayed in the description field of a lookup object.
You can use CONCAT() to combine multiple strings that are displayed in the description field of a lookup object.
You do not have the required permissions to view the files attached to this post.
Re: how to create a value combined of 2 (or more) field valu
Thank you! Perfect and easy solution !!