Need help filtering

  • Resolved jree300

    (@jree300)


    7 years, 4 months ago

    Hi! Great plugin! I followed this tutorial: https://www.youtube.com/watch?v=0gvT6Myt1Ck to create an event list from my Airtable. Everything works great so far.

    My question is this: In my Airtable I have a checkbox column named “Publish”. I would like only the records that have that checked to show up in the event list in WordPress. How can I make that an additional parameter for filtering only published records? Right now it shows every record that I have in that particular table.

    Thanks in advance for your help.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Chester McLaughlin

    (@chetmac)

    7 years, 4 months ago

    In your configuration, enter this into your “Filter by Formula” field:

    {Publish} = 1

    You can refer to the formula reference by Airtable for more:
    https://support.airtable.com/hc/en-us/articles/217113757-Using-checkbox-fields-in-formulas

    Thread Starter jree300

    (@jree300)

    7 years, 4 months ago

    Thank you!!

    Thread Starter jree300

    (@jree300)

    7 years, 4 months ago

    Sorry to bother you again but I can’t find the answer for this.

    The {Publish } = 1 filter works perfectly but now I realize I need to break down my list into multiple sections based a date field aptly named “Date”. So they all need to be filtered by “Publish” but I need to separate loops by “Date” as well.

    Can the date filter be written into the list template? Or do I need to create separate Airpress virtual posts for each that filter both by “Publish” and “Date”, if that is even possible?

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

The topic ‘Need help filtering’ is closed to new replies.