Link to home
Start Free TrialLog in
Avatar of Jaziar
Jaziar

asked on

Appending Field Values to A text String

I have 5 fields in my form
                                   (field)           (field)       (field)      (field)    (field)
What is Your Product : ProMono   ColorMono    LaserMFP     SS     Connect

The User Has the Option to add a value to one or all fields.

In a view I can simply do a value

@Trim(ProMono:ColorMono:LaserMFP:SS:Connect);

And get what I need.  The problem is I need to add the values to a email subject line -  I think it is too much but the client is wanting it.  Here is what I have thus far

Mail := @Trim("Jaziar Mindstrom");
message := "Testing";
DBTITLE := @DbTitle;
Prod := @Trim(ProMono:ColorMono:LaserMFP:SS:Connect);
subject := "[ Country : " +  COUNTRY+" ] " + "[ Customer Name: " + EmeaEndUser + " ] " + "[ EMEA SPR #: " + EmeaNum  + " ] " + "[ Product Name: " + Prod + " ] ";
@MailSend(Mail; ""; "";subject; ""; message + @NewLine+@NewLine; [IncludeDoclink])


What happens is for every  entry in Prod, it creates a dupilicate entry in the subject with the value.  

Example  [Counrty] [Joe Smoe] [SPR 1] [prod1] [Counrty] [Joe Smoe] [SPR 1] [prod2] [Counrty] [Joe Smoe] [SPR 1] [prod3]

All is want is [Counrty] [Joe Smoe] [SPR 1] [prod1, prod2, prod3]

Thanks

ASKER CERTIFIED SOLUTION
Avatar of qwaletee
qwaletee

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jaziar
Jaziar

ASKER

Great - check my next question :)