Search results by user ID 6461

Money fields on screens now showing double "$"s

Cindy — Tue, 09 Sep 2014 05:03:57 GMT

Recently it seems like some of the "Money" fields on screens of displaying leading "$" as "$ $". It doesn't seem to happen the first time it load...but second time has this appears fairly consistently.

Thoughts?

I'm wondering if it's a regression issue with the latest release.

--Cindy

Re: Formatting number in email.

Cindy — Tue, 15 Jul 2014 04:40:05 GMT

Something else I tried. Getting the numeric value...finding the "." with the character function...offsetting by 3 additional places and getting the left part via the character function again. That seems to work...but it seems like an insane work around to just format a random number that was originally a money field to look like money again.

Re: Formatting number in email.

Cindy — Tue, 15 Jul 2014 04:17:15 GMT

So here's something I tried.

I created a new table called "aaaaa". I created one column called "dollarsandcents" in it of type "Money" and I created a default screen to go along with it. On that automatically created screen I added a new section with a text box. I then extended the "select" action on the automatically sgenerated grid to "Retrieve Value From Table" using the "Screen Active RecordID" and populated into a text field either directly via the "Retrieve" action or via and action result and then pushing it to the text box. In either way the value shown suddenly has 4 decimal places (and no commas and such). I guess the trext boxes that are directly linked to the table seems to inherit formatting that maybe you can't get via pulling it via the "Retrieve" seems to loss the formatting.

Thoughts?

--Cindy

Formatting number in email.

Cindy — Wed, 25 Jun 2014 06:38:59 GMT

I'm trying to send out an email with details that include some dollar amounts. It seems like when I put the amounts into Action Result I can't seem to get $$$ formating. Is there some way of limiting to 2 decimal places as well as inject commas?

--Cindy