Need help filtering | WordPress.org

Resolved jree300
(@jree300)

6 years, 1 month 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)

6 years, 1 month 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)

6 years, 1 month ago

Thank you!!

Thread Starter jree300
(@jree300)

6 years, 1 month 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.

Tags

In: Plugins
3 replies
2 participants
Last reply from: jree300
Last activity: 6 years, 1 month ago
Status: resolved