Is it possible to have a number/formula field populated with a fractional outlook of the number?

594 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am looking for a solution to implement fractional fields in my table. These would hopefully be also calculable. I haven’t found any questions in this regard but please send me that way if you are aware of the similar topic.

1 Reply 1
8 - Airtable Astronomer
8 - Airtable Astronomer

I do not believe that Airtable has any built-in support for displaying numbers as fractions.
It’s conceivable that you could come up with a solution that includes:

  • An extra text column for each number-type column that you want to represent as a fraction
  • A script that converts decimal numbers to fractions
  • An automation that runs that calls the script whenever certain columns are updated and saves the result into the text column