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:La serMFP: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:La serMFP: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
(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:La
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:La
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER