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

Brainy

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.

Participating Frequently

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

Employee

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

Known Participant

did i need to create a custom record fields for that

Known Participant

for the Full name fileld

New Participant

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