Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Nov 18, 2022 03:09 AM
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!
Nov 24, 2022 03:36 AM
Hey @Sash_S
Create an Autonumber column field, I called mine row id.
Autonumber
row id
Once you’ve got that in place here’s the filterByFormula query parameters you’ll want to append to the URL.
filterByFormula
Odd: ?filterByFormula=MOD({row id}, 2)
Even: ?filterByFormula=NOT(MOD({row id}, 2))