Email / Field set up

[vr5150]

I am having problems setting up aan automated email from filemaker pro.

I would like to have my email subject look like this when sent.

-------------

Hello <<Name>>,

We can help you with the following:

<<Field1>>

<<Field2>>

<<Field3>>

<<Field4>>

Thank you,

Our Staff

-------------

In the email script is ask for either text or field.

Can I format a field to include merge fields?

When I made a paste field It looked very seperated by spaces if the field3 and field 4 where not included.

[Vaughan]

Create a calculation field that builds up the message that you want. Specify this field in the Send Mail script step.

[vr5150]

What is the calc I use for text?

I tried some of the text calc's but I couldnt get it to work.

[Vaughan]

Define the calc field...

"Hello " & name & "

[vr5150]

Thanks Vaughn it worked great.

[markhardee]

I, too, am having some oddities here.. My jobticket DB has an estimate layout for printing out estimates.. I can get everything formatted there as I like (via merge fields), but if I send the same thing as email, number formatting does not come over... The data that is returned vial email is:

We are pleased to provide an estimate on your job as follows:

Total Film Price is: 1004.4 1004.4

Total Proofing Charges are: 750

Total Scan Prices are: 0

Total Inposition Charges are

Anticipated Manipulation Charges are: 0

Resulting in a total of: 1754.4

None of the number fields are formatted into currency.. Any way of doing this?

[keshalyi]

The best way, when taking it out of the program, is to not send the actual number field, but a converted-into-text field, calculated to look how you want it. That way, it saves the number not as a number, that each program will interpret by its own whim, but as a stable string of characters

[RussBaker]

From a number field, "Money_Number_Field", this (somewhat ineleganat - sorry) calculation will return text formatted as currency as either $28,566.25 or -$89.15. It handles up to 12 digits accurately or up to 15 digits with inaccuracies in the cents area. Hey - as long as you're not emailing Bill Gates' bank balance, that should be OK?

If(Money_Number_Field<0,"-$","$") &

If(Length(NumToText(Int(Abs(Money_Number_Field))))>12,Left(NumToText(Int(Abs(Money_Number_Field))),Length(NumToText(Int(Abs(Money_Number_Field))))-12)&",","") &

If(Length(NumToText(Int(Abs(Money_Number_Field))))>9,Left(Right(NumToText(Int(Abs(Money_Number_Field))),12),Length(Right(NumToText(Int(Abs(Money_Number_Field))),12))-9)&",","") &

If(Length(NumToText(Int(Abs(Money_Number_Field))))>6,Left(Right(NumToText(Int(Abs(Money_Number_Field))),9),Length(Right(NumToText(Int(Abs(Money_Number_Field))),9))-6)&",","") &

If(Length(NumToText(Int(Abs(Money_Number_Field))))>3,Left(Right(NumToText(Int(Abs(Money_Number_Field))),6),Length(Right(NumToText(Int(Abs(Money_Number_Field))),6))-3)&",","") &

If(Length(NumToText(Int(Abs(Money_Number_Field))))>0,Left(Right(NumToText(Int(Abs(Money_Number_Field))),3),Length(Right(NumToText(Int(Abs(Money_Number_Field))),3))-0),"") &

"." &

Right("00"&NumToText(Round((100*(Abs(Money_Number_Field) - Int(Abs(Money_Number_Field)))),0)),2)

_ _ _

You can also get formatted numbers into a text field by using a script.

Create a new totally empty layout and place the Money_Number_Field on it. Format this field to display how you want the number to look. Then run this script:

Go to Layout [your new layout]

Copy Record

Go To Layout [Original Layout]

Paste [select][Money text Field]

If you have more than one field on the new layout, this will copy all the fields and the formatted contents will be pasted with TABs between them.