Filter on checkbox
-
Question about filters:
I’m taking post submissions via airtable and have a checkbox field “Reviewed” where i have manually checked the submission and approve it for posting.I have a virtual post config for single post and archive page to show these posts. For the single post, I used the filter by formula:
AND(Reviewed=1,RECORD_ID() = ‘$1’)
That works to restrict single posts. For instance, when I test the URL for that post – it comes up 404. which is good.
BUt i also have an archive page setup in airpress. It should loop through all posts in airtable that have a check in the checkbox field “Reviewed.” FOr that, I used the filter by formula:
Reviewed = 1
The test in airpress shows me it matches 2 records, which is correct I have 2 “reviewed” records.
But the actual page shows all three records – even the one that has not been reviewed.
So, in a really long around about way…
My question is – is there another way to do filters like this or exclusions based on airtable fields being checked?Thanks.
Craig
- The topic ‘Filter on checkbox’ is closed to new replies.