I started by importing an excel into my data, but when I then integrate the list into my interface, the data type changes for currency specifications.
Example: 1.200.000€ -> 1200000
How can I prevent this and can I change this afterwards?
Thanks for your tips and hints.
Hi Tommi S,
Your data is saved in the database as a number and it is correct.
You can control how do you display on the screen using the built-in FormatCurrency function, like in this example:
Thank you for your answer, I will try it :)
You're welcome Tommi!
You can see on my screenshot the description of the function so you can use its parameters to format the currency to your use case.
Sorry if the question is stupid. But where can I find the expression value box where I can enter your suggested solution?
Thank you very much
Hi Tommi,
No problem.
On your screen canvas in Service Studio, your value must be represented with an Expression widget.
You can double click that expression or the Value property on the right panel after selecting the Expression.
It worked out perfectly. Thank you again! :)
Hello Tommi,
You could use format functions to achieve your goal, more info in the link below: https://success.outsystems.com/Documentation/10/Reference/OutSystems_Language/Logic/Built-in_Functions/Format#FormatCurrency
Good day!
Kindly refer to this post.
https://www.outsystems.com/forums/discussion/40075/import-excel-data-to-record-table/#:~:text=If%20your%20Excel%20data%20has,from%20Excel...%22.
Before the Create node, you can use convert function within the Assign widget to ensure that it will stay as integer or decimal value.
Hope this helps,
Kind regards,
Chris