Number attribute function or rule for currency symbol

Rennur

A small nuisance I was hoping someone would be able to suggest a function or a rule as a workaround.

Currency
Attribute: Number
Format (with the currency prefix): $#0.00

In the web form, If you enter a value but you don't specify the '$' sign before the value, the form spits out a validation error "Attribute has invalid format".

Is there any way that the system (via a rule or function) inserts the '$' automatically after the user has entered the value or on submit.
I have a few of the currency attributes on the form which require user input. To enter the $ for each is annoying, especially if the user is using the keypad on the right hand side. The user should be able to enter only numbers without worrying about the prefix.

Maybe I have missed a rule or a function in the User Guide for this.

Wishlist:

"Currency" as a new attribute type or a separate field to specify the $ symbol in the number attribute.

On form submit, the system checks if the user has/has not entered the $ symbol in the input and adjusts the form input accordingly.

Thank you

Rennur

I guess the only solution is to this is found in post relating to version 1.5 way back in 2006.
Currecy to text plugin & I was hoping BobK could take a look at the code and maybe suggest if a plugincan be developed for this.

Powerm

Why don't do create an attribute called "Currency" as Plaintext, with default value = $ or USD ?
You could then create an other calculated attribute called " Summary". Just do a Rule saying :

BO.Summary = BO.Currency+ BO.Amount

Rennur

You can specify the currency symbol without creating a separate currency attribute with a function CURRENCY_SYMBOL.

I have no issues with calculated number attributes as they don't require user input. You just specify a format eg. $#0.00 & a rule to calculate a value.

If I have 3 number attributes on a form, all requiring manual $ value user input, you get an error if you specify a $ symbol in the attr format but do not enter the $ symbol on the form.

If you have a number attribute with #.00% format, you cannot just enter a number, you must enter the % symbol at the end.

Rennur

You can specify the currency symbol without creating a separate currency attribute with a function CURRENCY_SYMBOL.

I have no issues with calculated number attributes as they don't require user input. You just specify a format eg. $#0.00 & a rule to calculate a value.

If I have 3 number attributes on a form, all requiring manual $ value user input, you get an error if you specify a $ symbol in the attr format but do not enter the $ symbol on the form.

If you have a number attribute with #.00% format, you cannot just enter a number, you must enter the % symbol at the end.

Rennur

Support, any thoughts on this topic?

Salesforce.com has the currency & percentage as a custom field types.
http://login.salesforce.com/help/doc/en/custom_field_types.htm

I believe Alpha Five also supports this.

Rennur

Hi Support,

The subject in this post is, please [x]:

[ ] Considered
[ ] Declined
[ ] Implemented
[ ] Planned (high priority)
[ ] Planned (low priority)
[ ] Planned (non priority)
[ ] More detailed explanation needed
[ ] Open to suggestions
[ ] Doesn't make sense
[ ] Duplicate forum post
[ ] AIM Limitation
[ ] AIM Bug
[ ] AIM BSV Required

Some posts do not get a reply and I appreciate the fact that you guys do your best and are busy making this product even more awesome than it already is, but sometimes just a quick response is more than enough.

Regards,
Rennur

aware_support

We normally recommend putting % or $ symbol as part of the attribute label or to the right of the control (as description):

Cost,$ : 25.00

Completed: 25 %

This avoids all these problems and do not force the user to enter the symbol

Rennur

Putting % in a label and not part of the number attribute format will not make the attribute a %.

Example, if I have a number attribute to store a GST % (with % in label only) which will then be used in mathematical calculations, it will not calculate the attribute as a percentage only as a number.

I can probably do with the $ in the label only. Would you consider implementing prepended and appended inputs instead of using $ sign in a label/description:

CSS via Bootstrap

Cheers

Rennur

Had some success using Presentation>Styles>Format but ran into some issues.

DOWNLOAD THE BSV HERE (direct link)

Price & Price_Total attributes

Price Presentation Style format

Delivery Address Object

Add New Product via DEFAULT IMPLEMENTATION

ADD a New Product

1. New Product Window

2. DEFINE Product Name

3. CHANGE Price

Add New Product via PROCESS

All same as per default accept the form crashes

DOWNLOAD THE BSV HERE (direct link)

Cheers

aware_support

Typing a % symbol every time to input a number doesn't make a percent either. Using number format for this is NOT a good solution.

All you need is a rule that calculates the percentage and then the symbol itself can be part of a label or attribute description.

We have done many apps with % and we use this solution all the time. It's simple and it works, so I don't know what the problem is.

Rennur

Typing a % symbol every time to input a number doesn't make a percent either.

I never said that, maybe a misunderstanding.

Here is what I have now:

Just following Appendix C and putting a suffix % in the format.

When you enter the value in the form, you have to specify the '%' as part of the input. The object is saved and field is is displayed '10.00%'.

If you don't specify the '%' symbol at the end only '10.00' you get an error

As you can see, user has to put the % in every attribute that has the '%' symbol in the format.

Using my attribute with the % specified in format (1st pic):
When using this attribute in calculations, the attribute is calculated as a percentage.

Object.Price = $20

Rule (Works):
Object.Price_Total_incGST=Object.Price_Total*SystemSettings.GST+Object.Price_Total

Object.Price_Total_incGST=$22

Is the above rule not supposed to work like that?

Now, If the format in the GST attribute does not contain % suffix.

The calculation would simply be: Price_Total*SystemSettings.GST+Price_Total

Object.Price_Total_incGST=$220

i) Whats the point of the '%' suffix in Appendix C? Is there any use for it if not used in the attribute format input?

ii) Are you advising to leave all my % based number attributes in the Object like GST, discount, surcharge, TAX etc.. as a number without using the format input & have a rule for each & when using in calculations, just use rule:

Object.Price_Total_incGST=(Object.Total_Amount*(SystemSettings.GST / 100))+Object.Total_Amount

Just to be clear, my observation regarding the $ and % in format are by no means of 'show stopper' proportions, in my opinion, its merely a 'user experience' nuisance from the front-end user point of view, having to manually enter the % symbol for each of those inputs that require it (as shown in the pics).

Would love to see examples of how someone is using the percentage fields in their apps without using the format input in the attribute.

Cheers

aware_support

Like I said, putting a percent symbol into the number format is NOT a good idea as it forces the user to type it. Leave the format alone and put the percent symbol into the attribute description or label to indicate to the user that the entered number is a percent.