Solved

i want to add the three fields into like eg firstname, middlename, lastname into one field as full name

Best answer by harshitb6843

You can create a customer record field by concating the three different fields if you want to use it often and also want filtering working on it.

yes you can do that by saving them separately first and on button action you can save them to the particular field using concat()

Hi,

just set a Text (or Rich Text) Field's value as concat(ri!first," ",ri!middle," ",ri!last) or ri!first&" "&ri!middle&" "&ri!last

did i need to create a custom record fields for that

for the Full name fileld

if you want to concat first name and last name, use this

concat(rv!record[ ] ," ", rv!record[ ]) , in the square brackets put the column names first name and last name

Sign up