[SOLVED] Format a field as currency

Hi all,

I need to format a field as currency (ex.: 100.000.000€) at least as display not so much as edit. How can I do it?

I put in the "Profile Value Layout" - [value]€ And the result is 100000000€ but there's any way to add the period (.)?

Thanks for the help

We've no support for field masks (formatting for text inputs). You'll probably need to use a text field for the edit display then use a Code field using CB Code Field and custom PHP for the profile display to format it as a currency.

Hello Krileon,
do you have a documentation please, how I can do this: "You'll probably need to use a text field for the edit display then use a Code field using CB Code Field and custom PHP for the profile display to format it as a currency."?
Thanks!

No, we don't provide any sort of documentation for custom coding like that. Basically you'll be using 2 fields. 1 is the text field where they input whatever they want. The other is a code field provided by CB Code Field. In that code field you'd substitute in the value of the text field (e.g. [FIELD_NAME]) and run it though whatever PHP you like to format it however you like.

If you still want input masking, which is just JS, then you'll need to try and output your custom JS using CB Auto Actions on the before profile edit and before registration form display triggers (available in the dropdown when creating an auto action) using the Code action.

Hi,
first of all, great job and good service. But with this topic I am a little bit lost. I need many price fields and would like to make searches with price limits, so I need:
1) fields with i.e: 200,00 € (stored as 200.00 €)
2) search for profiles with fields value i.e. > 150,00 €
3) calculation with the values (i.e. field 1 - field 2)
I thought this can I manage with CB and the way you described in your reply is complicate (I need one field, in which the user makes the input and sees the output in the profile).
Hopefully there is a simplier way for 1)-3), which works with CB core fields?
Thanks, best regards
Eric

add:
ah, I found: www.joomlapolis.com/forum/153-professional-member-support/213707-solved-mathematical-calculation-fields?limitstart=0
so calculations can be make, 3),
Question: can be made also with string-fields ?

add:
question: can I use a string field and put in the validation for [*,**], so that the user can only put in currency format?

Integer fields can't handle decimals at this time. I've already a feature ticket to improve integer fields and rename them to Number fields so it can handle decimals. Best I can suggest for now if you need decimals is a text field and custom regexp validation rule to enforce it being a currency. Below is the forge ticket were I've noted some planned improvements; likely more will be added to the ticket.

forge.joomlapolis.com/issues/7620