For readability it would be nice to be able to present numbers (especially large ones) with separators such as commas. Custom defined number formats would be even better (regex).
The only workaround i’ve found is to replace dots and commas with a Script block to match the Airtable format.
There is an example of search and replace inside de block documentation.
I’m a heavy Podio user and was looking for an alternative to learn some new exciting software. I want to use 1,5 as one and a half. NOT 1.5 as one and a half. Is this not possible in Airtable? Am I understanding this thread right?
Unfortunately, the Airtable team is 100% USA based, so my guess is that they didn’t realize that dozens of countries around the globe use different number and currency formatting.
But the real disappointment for me is that they still haven’t fixed the problem, after 4 years of complaints from international customers — many of whom have simply moved onto other products. And it would be such an easy fix for Airtable to implement.
So, unfortunately, you’d have to manually figure out your own solution for this: either create a formula to convert your numbers, or automate something with JavaScript or Integromat.
