Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Ability to select default date format

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
DavidVM
6 - Interface Innovator
6 - Interface Innovator

I would love the ability to set a standard date format across all of my bases when a date is used in a formula field, or for the formula field to use the same date format as is set in the date field it refers to.

Itโ€™s not a huge issue to use the DATETIMEFORMAT function in the formula field, but when you have to do this 20-30 times, it would sure be nice to be able to set a default across the base, or to simply mirror the formating in the date field being referenced.

6 Comments
Hannah_Wiginton
10 - Mercury
10 - Mercury

Trying to remember if @Kamille_Parks was working on a new app that does currencies and dates or just currencies?

Kamille_Parks
16 - Uranus
16 - Uranus

I made an app that has the capacity to change the configuration options of several/every field of a particular type at once including:

  • Date and Date-Time fields: date and time formats
  • Checkbox and Rating fields: color and icons
  • Percent and Number fields: precision
  • Currency fields: precision and symbol
  • Duration: format

It will eventually be able to also edit the following:

  • Single and Multiselect fields: match all select options including colors across fields
  • Record Link fields: โ€œprefers single record linkโ€

Due to API limitations the app will not be able to adjust Rollup or Formula field configurations.

The app is not available yet, and I have not decided whether or not I will ever release it even when its โ€œfinishedโ€. For those curious, it currently looks like this:

image
image
Edited to add: If youโ€™ve selected more than one field to edit, the first dropdown in the second screenshot lets you select a field as a โ€œbaseโ€, meaning you can just import that fieldโ€™s current settings and apply it everywhere. Otherwise just edit the appropriate settings.

DavidVM
6 - Interface Innovator
6 - Interface Innovator

Interesting. Iโ€™m glad to see someone working on this. I would love to see Airtable add the ability to set default options out of the box, but I imagine that these features arenโ€™t high on their list of priorities as theyโ€™re more of a want than a need.

The one that takes most of my time is the date format. I almost always want YYYY-MM-DD which is never the default, but I can see that it would be very useful to ensure consistency of rating fields, single and multiselect, etc.

Please post back here if you ever decide to release it. Iโ€™d love to check it out.

Kamille_Parks
16 - Uranus
16 - Uranus

I agree. My goal with this particular project is to just offer it up to Airtable as a feature to add to everyone. Iโ€™ve said before โ€œI want Airtable to make me obsolete.โ€ Otherwise it would just become another product I would sell. Its useful enough (and frankly, easy enough to code which is why I was able to make it in about two days) that it should just be adopted as a settings panel of some sort.

Hannah_Wiginton
10 - Mercury
10 - Mercury

wow, @Kamille_Parks!! :star_struck:

Thatโ€™s lovely!

DavidVM
6 - Interface Innovator
6 - Interface Innovator

Thatโ€™s awesome! Thanks for all you contribute to this community. It is appreciated :pray: