Help

Re: Get even or odd rows from table (http request)

626 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sash_S
4 - Data Explorer
4 - Data Explorer

Hello together,

is there a way to get just even or just odd rows from a table?
Even: 1,3,5,7,9,…
Odd: 2,4,6,8,10,…

I want to use https://api.airtable.com/v0/xxxxxxxxx/${even-rows} or something else.

Maybe someone high skilled can help me with this issue :slightly_smiling_face:

Thanks a lot!

1 Reply 1
goksan
6 - Interface Innovator
6 - Interface Innovator

Hey @Sash_S

Create an Autonumber column field, I called mine row id.

Once you’ve got that in place here’s the filterByFormula query parameters you’ll want to append to the URL.

Odd:
?filterByFormula=MOD({row id}, 2)

Even:
?filterByFormula=NOT(MOD({row id}, 2))