• Resolved OrgSpring

    (@orgspring)


    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

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Filter on checkbox’ is closed to new replies.