Hi Dell, thanks for listening. Here's the formula:
stringvar details;
stringvar name;
stringvar position;
stringvar company;
// fill the name value
name := {vnl_Event_Speakers.ATTENDEE_TITLE};
// fill the position value
if (Trim({vnl_Event_Speakers.ATTENDEE_COMPANY}) = "")
then(
position := ""
)
else(
position := ", " & Trim({vnl_Event_Speakers.ATTENDEE_COMPANY})
);
// fill the company value
if (Trim({vnl_Event_Speakers.ATTENDEE_CO_ID}) = "")
then(
company := ""
)
else(
company := ", " & Trim({vnl_Event_Speakers.ATTENDEE_CO_ID})
);
// concatenate them and return
details := name + position + company;
details;
I hope this offers some insight...
IP Logged
