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.
Is it possible to have a number/formula field populated with a fractional outlook of the number?
+3
+13I 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.