[SOLVED] [compatible validation / masking pairs should be tried] Numeric field data is truncated

More
9 years 11 months ago - 9 years 11 months ago #54352 by chaaya
Decimal values are truncated from the "," onwards when the field is defined as follows:

Field type: "Text (number/time/etc...)
Server-Side validation: "DECIMAL"
Value Validation Mask: Currency ($).

For example if enter a price of 11000, it will be displayed as $11,000.00 at the input. When I click Apply the value changes to $11.00. In the database the value is saved as 11.

I am using version 3.0 BETA6b.
I am using Joomla 3.4.1
PHP version 5.6.8
Last edit: 9 years 11 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago - 9 years 11 months ago #54353 by ggppdk
Hello

please note that not all server validation / form masking options are compatible !

-- you can not use
server validation "decimal", with input form masking "currency"
instead (try) using decimal mask


-- if currency format is required (when displaying), you can set the value prefix parameter to be:
$


-- about formating a decimal, i will add new 4 new parameters in viewing, because this is indeed commonly needed


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...
Last edit: 9 years 11 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #54354 by ggppdk
Hello

about entering see my above answer, about parameter to support decimal output:
- # number of digits
- decimal point character
- thousand separator character

you can backup and test with v3.0.0 B7 nighlty4
github.com/FLEXIcontent/flexicontent-cck/releases


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #54356 by chaaya
Yes. It works this way. I downloaded the nightly one and working on it now.
No need for the currency mask anymore I suppose.

Thank you.

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #54357 by chaaya

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.364 seconds
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Save