Forms Designer Forum

Hi,

I have problem about number column. I calculated this value in SP Form Designer. When I save this item, Sharepoint shows this value without point. How can I resolve this issue?

Hello, ksertkaya!
What culture are you using for the site? This might play a role, perhaps you need to relace . with , It depends on the culture.
If this doesn't help, can you show us your script?

My code is just fd.field('a').value() * fd.field('b').value()

Spform use point. But number column delete it.

Dear ksertkaya,
Please, check locale settings for your site. We get similar result in our tests if the culture selected has different decimal symbol. You can even try it yourself, if you replace dot with coma, it's likely to save the value correctly.

While your browser settings are definitely correct as we can see on the attached screenshots, it's SharePoint site settings which are more important here.

You can check it yourself if you go to Site Settings: Then go to Regional Settings: And here you can see the locale that determines number formatting for the site: If the locale is set to United States or another culture that also has dot as decimal symbol, then the result is very strange. I recommend you to check a default form to see if it has a dot or a coma as a decimal symbol.

More importantly, I am not sure why the code fails and puts the wrong symbol, but we can solve this issue if we figure out the reason behind saving the incorrect value. If it's culture, you'll either be able to change culture or if it is undesirable, we can write some custom JS for you to replace dot with coma after multiplication.

Resolved. Thanks a lot!

Excellent! You are very welcome!