Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Which field type to enter a page number?

Topic Labels: Formulas
Solved
Jump to Solution
299 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey guys,

Which field type should I use to enter page numbers for each of my table listings? I want to be able to do some calculations on them later e.g. average page number for 10 rows of book listings. I tried using the number (#) field type but it adds an unnecessary decimal place. So for example a page number entered as 350 changes to 350.0.

I was going to use the single line text field but wondered if that would prevent me running calculations later on.

Thanks in advance if anyone can help.

1 Solution

Accepted Solutions

Use a number field, but change the formatting from decimal to integer.

See Solution in Thread

2 Replies 2

Use a number field, but change the formatting from decimal to integer.

Awesome, thanks. :smiling_face_with_sunglasses: