Regional Support (Time, Date, Currency formating)

#21

Hey guys, I really need to have my currency changed.
I need it to accept comma to decimals.

R$ 1.000,00

Any chance?

3 Likes
#22

Is this really so hard to implement? Why hasn’t the development team done anything in all these years? It’s a tiny change but makes a ton of a difference in Europe. Why force this not very practical American system on everyone???

3 Likes
#23

Wow, almost 3 years! I guess there’s no interest in implementing this… sad.

1 Like
#24

I would also really like to set Monday as the starting day of the week not Sunday.

This is currently not possible to achieve with DATETIME_FORMAT(SET_TIMEZONE(Date,'Europe/Berlin'),'ww').

Would be really nice if you could implement that feature!

1 Like
#25

@Katherine_Duh
Please, regional support! :pleading_face:
Mainly number format!
I can’t implement to use Airtable professionally use without this feature!!!

#26

And do you know what’s intriguing?
On iOS app, everything is right! :open_mouth:
Why can’t we have it right also on PC?

1 Like
#27

Are there any news regarding this or when it is expected to be implemented?

#28

Bump! Please support European number formatting!

#29

Any update on this? I would like to implement Airtable in my business, but I would need comma decimals to do this.

1 Like
#30

Looking into Airtable right now. But indeed completely useless for us because we need the decimal comma. Don’t understand why this is not possible. Used in (very) large part of the world.

#31

I just imported a CSV into a new base.

I’m in England, so the system that generates my reports automatically uses the DD/MM/YYYY HH:MM format for dates.

When I imported the data, everything looked fine. At the time it was a text field.

I decided to change the field type to Date. Before any of the data was converted, I made sure to choose ‘European’ in the dropdown.

The problem is that upon clicking ‘Okay’, Airtable does not associate the choice of date format with the pre-existing data in the fields.

So what happens is that any dates before the 12th of a month are reversed (for example the 9th of December becomes the 12th of September), and any dates that occur after the 12th of the month are simply wiped as they’re not recognised as a date.

This leads to a table that looks more like this:

Is it possible for the Date field to take the date format choice into account before it decides how to parse this data?

1 Like
#32

Hi Matt. A quick thought… Maybe you could format your source file date field in the American way, export to your Csv, import to airtable. Airtable should treat your field as a date and not a text so you finally can change it to European format.

#33

Hi Emilio, good idea. I’ll try it.

Definitely think this is a bug worth fixing, though.

#34

Hello,
I have excactly the same problem when importing cvs with local date format (Switzerland).
I have already notified the Airtable team on this behavior.
Hope it will be corrected soon

#36

Anyone find an answer/response to this date format issue?

#37

it wouldn’t be as bad if entering decimal values with a different separator (,) wasn’t muscle memory. It keeps happening that i enter expenses for my business and 145,95 ends up as 145950 wich is factor 1000 wrong. At least it makes the error easy to spot. but entering lots of bills really isn’t fun! im glad there are international alternatives to Airtable such as Zenkit

#38

Definately essential for professional use of Airtable in our business.

#39

Any news about currency to get at least symbol after the amount?

Are there real willingness or actions to localization of Airtable? A lot of requests are quite old…

#40

After months since first requests for support of a decimal comma (3,14 instead of 3.14) have appeared here nothing has changed in Airtable. That’s a pity. Instead we’ve got a new field type and a new design.

A new field type is nice - but it does not make Airtable more usable to many, many potential users in Europe. I won’t be able to entice anyone of my customers to use Airtable as long as their clerks and office workers cannot use their native number format. Even simple applications cannot be moved from Excel to Airtable without regional input and output formats. I cannot imagine how much revenue will not be generated due to this lack of basic international functionality. It’s so basic, even, that the iPad/iPhone versions of Airtable have it - but the online and desktop versions are lacking it (at least for the decimal comma).

Please, Airtable team, provide all the basic formatting options relevant in most parts of the world outside the US. You’ve created a great tool - but all its cool features are facing a basic constraint: internationalization. It’s not just techies and nerds and geeks using your product. Or at least it shouldn’t :wink:

21 Likes
#41

It’s a great tool and I’m happy to pay 24$ a month, but: Converting data from spreadsheets as a german user is a pain in the neck because Airtable ignores non-US Standards. I manually have to search and replace csv-data from 1.240,00 to 1,240.00. Also I have to convert standard (at least in Germany) Date formats from 03.04.2017 to something like 4-3-17 before I can use my data: Converting in Airtable will break everything. That’s really annoying and shouldn’t be a big problem to fix. Please, Airtable, I understand America comes first, but could Europe be second? Thanks!

15 Likes