emailing summary data...

[Fritz Jung]

I will be emailing my bosses so daily info 'summaries'

Problem... if I copy from a field and paste it into a field (that the email will grab)

$1,025,284.25

pastes in like

1025284.2512789

how can I paste in so that it is properly formated?

[mse]

Oh, goddess...

[Lee Smith]

Hi Fritz,

I don't know what mse is trying to say other than utter nonsense.

I think what is happening here is you are copying a number field that you have formatted to 2 decimals and a dollar sign. However when you copy the field, it is copying what is actually there.

You need to convert the field to text before copying. There are several calculations that have been tossed around that will accomplish this, but none are perfect, meaning that they will break depending on the raw number.

The best solution is to put your number field on a separate layout, all by itself (formatted as it is now) and then create a script that goes to the layout and copies "All Fields" and then returns to a layout where your "text" (summaries?) field is and pastes it" Seems harder then it really is.

Here is a calculation by Russ Baker that covers most of the normal too.

If your text field for text is named "summaries", just paste this calculation into it, and make the results equal text. Otherwise, substitute the name of your new calculation field for "summaries".

If(summaries<0,"-","") &

"$" &

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

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

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

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

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

"." &

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

HTH

Lee

[mse]

Why not simply merge "summaries" into a "daily email" text?

Am I missing a clue?

[Lee Smith]

yes

[Fritz Jung]

Thanks much Lee,

I was afraid that I'd have to calc this out, BUT thanks to you I can simply 'do it up' -

I really appreciate this effort.

thanks

Fritz