Front-end Filters for airtable List

  • I was wondering how I can add filters on the front-end so that visitors can manipulate the list from Airtable. Even just using one column form airtable that, in this case, is a drop down selector. Without having this ability, I’m not sure this type fo implementation with be right for us, but it’s so close I wanted to reach out.

    I followed your video here in order to create the list on one page, but I am a designer with a basic understanding of HTML and CSS and am having difficulty understanding everything you’ve posted on the plugin page, so I apologize if the answer is there and I literally just don’t understand the language.

    The styling is plain, both on this list and the individual post pages, but I didn’t want to dig in on that until I knew I could utilize filtering.

    Thanks!

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

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

  • I don’t think you can do that without touching the front-end side and filtering with some javascript solution, or otherwise switching to php to filter your data with an extra parameter which you use to alter the AirPress query.

    It’s def doable, but not with the plugin’s native functionality.

    If all you want to do is have one column in Airtable manipulate a page or several pages, you can just utilize formulas within Airtable to manipulate the information sent to WordPress through Airpress. You don’t need to add php filter functions if you don’t want to.

    Example:

    Column 1 in Airtable is the name of a book your selling, Column 2 is the price of the book, and column 3 is a dropdown with 2 options, “Regular Price” and “On Sale”.

    What you would do is add a 4th column named “Final Price” and use a formula. IF({Column 3}=“Regular Price”, {Column 2}, {Column 2}*0.10)

    What this would do is if the book was marked “On Sale” it would give it a 10% discount otherwise it would use the full price in Column 2 as the the Final Price. Then just send the Final Price to your site using a shortcode [apr field=“Final Price”]

    This can all be done by adding PHP filters but with no coding experience this is how you would manipulate information on the website from Airtable just using one column in Airtable.

    Not sure if this is what you were asking; and I know my example doesn’t pertain to your particular website but if you want to manipulate information on a page or multiple pages using one column in Airtable without using PHP this is how you do it

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Front-end Filters for airtable List’ is closed to new replies.