Right now, you can use any symbol you want for a currency, but it’s per column not a global setting.
We’re working on time and date formats, that should be available in the next couple of weeks.
It is indeed possible to use any currency symbol, but in some parts of the world it is customary to write it after the number, like 100500 €, not €100500.
In this matter, it would be very gentle from you guys to make able the calendar not to start on sundays… we look at calendars starting on mondays and its really confusing looking at it in other sequence. Hope you can make this option!
I agree with everyone in this thread. Lay persons (in the US) use Sunday, while accountants use Monday for start of week. US uses Mmm dd, YYYY while EU Uses dd-Mmm-YYYY, and millitary uses YYYY-MM-DD. US uses AM/PM while EU and millitary use 24HR. Crucial.
These are all great, specific suggestions, and we love hearing them—the more we know about how you all would like to use time/date/currency fields, the more we can implement future changes to these fields in a thoughtful, considered way.
In the meantime, we do have the DATETIME_FORMAT and SET_TIMEZONE functions, both of which you can use to reformat dates. It’s not ideal, but it might be useful as a stopgap measure for some of you.
In addition to date / time format and currency position discussed in this forum, I would suggest to incorporate
currency amount to be expressed in words. e.g. if the amount is $125.35, this function would express as “$ One Hundred Twenty Five and Thirty Five Cents only”. Such functionality is required in many business applications like writing cheques or printing invoices. It will be very useful in financial applications.
Basic date format are available but One more date format is suggested: dd/mmm/yyyy or mmm/dd/yyyy where mmm is first three letters of month e.g. Jul for July; Dec for December etc. This will provide uniformity in printing dates because dd/mm/yyyy or mm/dd/yyyy have different connotation depending on country.
it’d be great if you could support different decimal marks in airtable. For example, in most European countries the decimal comma is commonly used for this purpose. While this is not a big deal when you’re working with a small team, it can lead to quite a few mistakes when collecting data, e. g. using a form view.
