Skip to main content
BOOK A DEMO

Search

Localization problems

ArdeviaForum
  • Discussion Created

Original Post by Petri Puoli-Honka (Imported from Ardevia Forum)

Hi,

 

I've used Ardevia Trial for a few days and I'm liking it so far.

 

I do have a problem with localization.
When I make calculations in forms with functions decimal values are output with a dot(.), like this 123.45. Our Sharepoint is set to Finnish localization and we use a colon(,) instead of the dot. So the correct value for us should look like 123,45.
This is a problem because Sharepoint does not recognize the output as a number if it has a dot instead of a colon in it.

0

Comments

3 comments

Date Votes
  • ArdeviaForum

    Original Post by Andrii Katsiubka (Imported from Ardevia Forum)

    Hi,

    There are few ways how to resolve your problem.


    Solution 1: Replacing dot by comma

    • Open Expression builder for Calculated expression
    • Set expression type to "Function code"
    • Modify your expression logic as follow:
    • Code:
    var result = <Your Calculation logic>;
    return result.toString().replace(/\./g, ',');
    • Do not forget replace <Your Calculating logic> by your expression

    Solution 2: Use localization option

    • Open Expression builder for Calculated expression
    • Set expression type to "Function code"
    • Modify your expression logic as follow:
    • Code:
    var result = <Your Calculation logic>;
  return result.toLocaleString("<Language indentifier>");
    • Do not forget replace <Your Calculating logic> by your expression, and <Language indentifier> by Language indentifier what you need (eg. "en-US", "de-DE", "uk-UA")
    0
  • ArdeviaForum

    Original Post by Petri Puoli-Honka (Imported from Ardevia Forum)

    Hi,

     

    Thanks for your help.
    But doesn't these two methods require the input to be with a dot in the numbers when i input them in the fields.
    Is there a way to change the locale for all the number fields in the form? I have many fields that require the user to input numbers, so it would be nice if they all behaved the same way, not only the sum field with the automatic calculation.

     

    With this solution it seems like I have to make my inputs with a dot and the result would be with a colon.

     

    - Petri

    0
  • ArdeviaForum

    Original Post by Petri Puoli-Honka (Imported from Ardevia Forum)

    Is there any solution to this problem?
    Unfortunately this issue renders the forms unusable for my application.

    0

Please sign in to leave a comment.