Chester McLaughlin

I’d love to take a look if we could do a screenshare or if you can send me a dump of your DB. At this point I’m wondering if there are some hidden/orphaned configs in the DB or if there is some collision with another plugin.

You can contact me via https://chetmac.com/contact

If you’re able to give me access or a DB dump I could troubleshoot more deeply. In the meantime, here is a resource I found describing a purported solution:

https://forums.envato.com/t/error-warning-preg-match/77270

Please proceed with caution and ALWAYS have backups!

I don’t see any issues on my sites that use Airpress, so I’m thinking that one of your regular expressions is being too greedy.

Install the “rewrite-rules-inspector” plugin so you can see exactly which rewrite rule is “grabbing” your pages.

Also, can you copy paste the value for the “URL Pattern to Match” field for each VirtualPost you have configured?

Lastly can you verify that you have no VirtualField configurations setup?

If you send me your contact info via https://chetmac.com/contact I can also reach out and maybe do a screenshare to dig a littler deeper if need be.

I’ll check it out now…

While it’s possible there is a bug or something to improve within Airpress, a quick google search turned up other plugins show this message and suggesting disabling DEBUG = true in your wp-config.php file.

If you can share your VirtualPost/Field Regex and the URL (or test url) that shows this error I can better troubleshoot/diagnose.

There is not currently a way filter results (i.e. to selectively choose certain rows) using shortcodes.

You may specify your query criteria (filterByFormula, maxRecords, etc) either using PHP or using the VirtualPost configuration screen.

Keep in mind that you can specify the VALUE and the FIELD in the VirtualPost configuration.

For example, if your “URL Pattern to Match” is “^list/field/([^/]+)/value/([^/]+)/?$” and your Filter by Formula is “{$1} = ‘$2′” then it will match both example.com/list/field/Status/value/Maybe/ and /list/field/District/value/SoMa/

So you can see how flexible your regular expressions can be.

Regardless, you’ll typically want to use something that is URL compliance (all lowercase, no spaces and no other non-url characters).

If you’re concerned about the number of VirtualPost configs you need to create you should probably just use PHP to configure it… or maybe there’s a more flexible way to use multiple parameters in your VirtualPost config.

Sure. https://chetmac.com/contact

To follow up on my own comment: From a strictly technically standpoint, SEO is simply the process of adding tags to your HTML (or XML in the case of sitemap.xml). So using WordPress and Airpress you can create a template page and populate anything on that page with anything from Airtable. Exactly how you do this depends on your specific setup.

Airpress doesn’t have anything to do with sitemap.xml

It is possible to customize your sitemap.xml file, so you could add an index of Airpress/Airtable records, but that’s not something Airpress does automatically.

What I do for SEO requirements on sites that use Airpress is to modify the page template PHP file to include the exact OG and META tags that I want. If you’re using Yoast this also requires disabling some Yoast features on the Airpress Virtual Post pages to avoid conflicting meta tags.

Airpress is a fairly low-level tool requiring knowledge of PHP and WordPress internals to do anything beyond some basic ‘virtual page’ stuff.

Airpress is three things 1) A robust API for fetching and caching Airtable data locally in the WP database (as transients) and 2) A set of deeply integrated WP hooks that allow that data to be presented as a page. 3) A set of simplistic shortcodes that provide a way to display (and even loop) data in the post editor.

The type of integration you’re describing would require a custom plugin that utilizes the #1 Airpress Feature (robust API) to map Airtable Records and Fields into WordPress (and Woocommerce) Posts and Fields. This will be a highly customized process based on your own particular Airtable base structure and workflow requirements.

I have done several such integrations and they are sufficiently complex, however Airpress will at least help carry the (significant) burden of talking to Airtable.

One ‘gotcha’ that I run into is that wp_cron isn’t reliable when using WP Engine or other heavily cached setups. So if you’re relying on wp_cron to execute the synchronization you’ll want to setup an actual cron script to “power” wp_cron.

Let’s schedule a Zoom Screenshare so we can more effectively troubleshoot. Send me a message at https://chetmac.com/contact/ with your contact info and a good time to spend ~15 minutes looking at the problem.

Thanks!

I apologize, I just found out my contact form on my website isn’t working. If you had tried to reach out you can submit the form again from https://chetmac.com/contact or direct message me on this forum.

Absolutely, Reach out to me at https://chetmac.com/contact and we can do a screen share to walk throw possible solutions.

Absolutely.

If you’ll be using this on (just about) every page/post, you’ll want to use Virtual Fields but if you’re only going to use this on one or two pages, it’d be more efficient to use Virtual Posts.

Either way, there will be a URL fragment that must match a value in a specific Airtable column. The entire matching row will be saved into the WordPress $post->AirtableCollection object where it can be accessed via shortcodes such as [apr field=”My Other Field”].

The other option is a completely custom shortcode that uses Airpress to do just about whatever you want.

If you hit me up at https://codementor.io/chetmac I’m confident we can get the basics working in 30 minutes.

Try changing the title/slug of your template. I typically prefix all my Airpress page template titles and slugs with “AIRPRESS TEMPLATE:” (or airpress-template) because these pages should never be accessed directly. Plus this will keep the URL from “resolving” when no records are found and should result in a 404.

Let me know.