Chester McLaughlin

If Categories was a related table, you could configure your VirtualPost to fetch Categories and then populate those records with the related Drinks. Then you could loop/iterate through the Categories which would allow you to show them as “grouped”.

Otherwise you’ll need a little bit of custom PHP in order to either group the records or to sort them by category and detect when the category changes. I typically recommend creating a custom shortcode in your functions.php file that handles this.

Correct. Think of filterByFormula as completely replacing the ‘filterByFormula’ each time you call it whereas addFilter appends a filter to the ‘filterByFormula’ string (by default using AND instead of OR).

It’s possible custom coding using the Airpress API would be the best way to go.

If you want you can schedule a time to review on a screenshare with me at https://chetmac.setmore.com

Create two pages in WordPress. The first titled “AIRPRESS: List” and the second titled “AIRPRESS: Item”

Then create two VirtualPosts in Airpress.

Virtual Post 1
URL Pattern to Match: ^my-items/?$
Test URL: my-items/
Map to this page: AIRPRESS: List
Leave filter by formula blank for now as this will match all records in the specified table.

Virtual Post 2
URL Pattern to Match: ^my-items/([^/]+)/?$
Test URL: my-items/recXXXXXXX
filterByFormula: RECORD_ID() = “$1”
This will search the specified table for a record with the id of recXXXXXXX

If you’d like help you can schedule a support screenshare at https://chetmac.setmore.com/

Can you send me a link to where I can learn more about this PHP Code Widget? I’m assuming it’s a plugin?

In the meantime, try turning on debugging (https://www.ads-software.com/support/article/debugging-in-wordpress/) and checking logs.

My first guess is that it may be a “race condition” where the PHP Code Widget is processing the code before (or in a different scope) than Airpress.

One guess I have is that you’re trying to directly access your template page… following this might work for you:

1) Create a page with a Post Name (i.e. slug) of “airpress-list-template” and a title of “Airpress: List Template”
2) open “mywebsite.com/airpress-list-template” in your browser. Now never go there again as it is just a template, not a page meant to be viewed. ??
3) Create an Airpress VirtualPost configuration that uses a valid table name. You can leave the formula field blank for now. Make sure the URL pattern is “^my-list/?$” and the test url is “my-list/”
4) Now open the following URL in your browser: “mywebsite.com/my-list” and you should NOT get a 404. If you view your Airpress debug log you should see that it is fetching all the records from whatever table you configured in step 3.

If you’re still not able to get past square one contact me via https://chetmac.com/contact or https://www.codementor.io/@chetmac and we can line up a screenshare to figure it out

This is possible using the core Airpress code, however it will require custom development.

You can contact me via https://chetmac.com/contact if you’d like to discuss scope/cost for such a project.

If your hosting is somewhere like WPEngine, their caching setup could be the issue.

1) Where is this website hosted?
2) Are you using VirtualPosts or VirtualFields?
3) What does your Airpress log show when you A) load the page as admin and B) load the page as a non-user?

You can send me a message via https://chetmac.com/contact with your wordpress handle @samrq123 and your other contact info so we can setup a 15 minute screenshare to troubleshoot.

From my local testing, it does work—however the output can be full of warnings and errors when not logged in (i.e. when you can’t see the private post).

I just pushed an update that exits gracefully when a post/page is private. Go ahead and try it out and let me know.

I copy/pasted your example and created a test base with matching fields and it all worked out fine on my “bare install” wordpress test site.

If you send me your contact info via https://chetmac.com/contact we could do a quick screenshare to track it down.

Is this on a VirtualPost or VirtualField configuration?

Ensure your quotes are this " not this ”

• This reply was modified 4 years, 11 months ago by Chester McLaughlin.

We found the cause of the “no collection” error (at least one of them) doing a screenshare with @fmdc — there was a missing front-slash on the API Url in the Airpress Connection configuration.

The URL should be: https://api.airtable.com/v0/

@adambatey if you want to send me your contact info via https://chetmac.com/contact we can do a screenshare and see if we can nail down the issue you’re having as well.

@fmdc Go ahead and resend now, I’ll watch for it. I get a ton of spam through that form.

Send me a message via https://chetmac.com/contact/ and I’ll do a Zoom meeting/screenshare and see if we can’t figure out the issue.

@fmdc Please regenerate your Airtable API Key as that last set of screenshots displays it publicly. https://airtable.com/account