Skip to Content (Press Enter)
OutSystems.com
Personal Edition
Community
Support
Training
Training
Online Training
Developer Schools
Boot Camps
Certifications
Tech Talks
Documentation
Documentation
Overview
ODC
O11
Forums
Forge
Get Involved
Get Involved
Jobs
Ideas
Members
Mentorship
User Groups
Platform
Platform
ODC
O11
Search in OutSystems
Log in
Get Started
Back to Forums
Francisco Neto
359
Views
13
Comments
Input widget as currecny
Question
Hi,
Is there a way to format an input widget as currency? This is, is it possible that in the input widget appears 12.000,60€ instead of 12000.6 ?
Thank's in advance,
Best Regards,
FN
Paulo Ramos
Staff
Hi,
Check the FormatCurrency built-in function:
https://www.outsystems.com/help/servicestudio/7.0/Default.htm#language_reference/built_in_functions/formatting_functions/formatcurrency_function.htm
Note that this will return a Text value, so you may have to handle conversions between your Currency/Decimal value (which you probably have in your entity) and an auxiliary Text variable (a local var in the screen/web block).
André Vieira
Staff
Hi Francisco,
I can find attach an eSpace with a webblock that replaces an input with a currency input.
See if you can work with it. if you have questions post back here.
Cheers,
André
CurrencyInput.oml
Francisco Neto
Hi André,
Excellent work.
Works perfectly!
Cheers
Francisco Neto
Hi André,
Iwas trying to use your currencyinputwidget on a table records but I can't figure out what to put in controlName. I've tried the Name of the input (Like if it was nameofinput.id but only nameofinput) but it doesn't work.
Can you help me, please?
Joop Stringer
Hi all,
I've tried to use the currencyInputWidget, however it disturbs the AJAX ...
As mentioned in this thread:
https://www.outsystems.com/NetworkForums/ViewTopic.aspx?Topic=Format-Input-Fields-
It is also mentioned here:
https://www.outsystems.com/NetworkForums/ViewTopic.aspx?Topic=Currency-input
I'll upload an OML to test it. We need this very urgent
CurrencyInputWidget.oml
Joop Stringer
Would be nice to have one of these incorporated in platform
https://www.jquerypriceformat.com/
https://plugins.jquery.com/plugin-tags/number-format
https://plugins.jquery.com/project/autoNumeric
Renato Gonçalves
Hi Joop,
In order to be able to correctly use this widget (or any other) on the Agile Platform you need to specify all node types, so in this particular eSpace you need to add the line
node.type = Text;
to the CurrencyInputField WebBlock script, in order for the hidden object to be created with the correct type.
Best regards,
Renato Gonçalves
1 reply
26 Dec 2011
Show thread
Hide thread
Daniel Martins
Attached you can find the Currency_Input e-Space with the Renato's fix:
node.type = Text;
Thank you!
I also changed the code in order to be possible, to have on the same page, inputs with differents parameters: thousandsSep, decimalSep, decimals, currencySymbol, currencyToLeft
For that, i added the necessary arguments on the AddCurrencyField function and init Code too.
Note: Requirement - Service Studio 6.0.1.9
CurrencyInput.oml
J.
Â
MVP
how old/obsolete is this workaround?
Are there any new insights lately?
Mark Jurkovich
Has anyone used the currency input successfully in an editable table? When I tried it broke the table. I could no longer add a new record. It just locked up and eventually crashed the page.
Daniel Martins
Hi Mark,
Please consider to use the following forge component:
https://www.outsystems.com/forge/component/505/simple-currency-input/
Hope it helps you!
Best regards
Mark Jurkovich
Sorry I didn't make myself clear. Thats the one I was trying to use that seems to break editable tables. I thought this whole post was talking about that currency input. Has anyone used the component daniel mentioned in an edtable table?
Mark Jurkovich
I did finally get it to work in an editable table. I had 2 input fields to format. They were in their own cell and container. I had to get them both in the same container with one simple currency web block. In the web block parameters I had to set targetInputs to a concat of both id's. Putting both in one cell/container messed up the formatting of my editable table but I should be able to fix it and keep everything in the same container.
Originally I had 2 web blocks one in each cell/container. I think this is what was causing the new record action to lock up and crash the screen.
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
See the full guidelines
 Loading...