• 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)
  • Plugin Author Chester McLaughlin

    (@chetmac)

    Interesting, before I dig in further try this:

    {Reviewed}=TRUE()

    Thread Starter OrgSpring

    (@orgspring)

    I had an issue with redirect.
    That fixed it, and I did the filter as you suggest too.
    That worked.
    Thanks again.
    This is fantastic.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Filter on checkbox’ is closed to new replies.