Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Airpress, the Wordpress plugin (formerly named Airfields) has launched!

6631 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m proud to announce the public release of Airpress, a plugin for Wordpress.org websites!

f8489fd96f348bab078cc641c28af3d21379bd92.png

Airpress gives you access to all your Airtable data, allowing you to create Wordpress websites that are fully integrated with your precious Airtable data. Read more on http://wordpress.org/plugins/airpress

Do you think you’ll install the Airpress plugin?

  • Nope. I’m good with Airtable
  • Nope. I don’t have a Wordpress website
  • Sure. I might give it a try sometime
  • Yes! I need to display Airtable data right now!

0 voters

69 Replies 69

Let’s move the support conversation here to the Wordpress support forum for this plugin.

Quick answer is, visit http://airtable.com/api

175b8cf159e217f2726db36c568b22248fe43fd5.jpg

The filterByFormula field is how you “map” a URL to a record (or records). So if you don’t enter a filter by formula, then ever record in that table will be returned on each request.

For example, if I’m using Airpress Virtual Posts to display restaurants, I might do something like this:

example.com/restaurants/recXXXXXXXXXX

So the ‘URL Pattern to match’ would be:

^restaurant/(.*)

and the filterByFormula would be:

RECORD_ID() = ‘$1’

$1 equals whatever is ‘matched’ by the parenthesis in the ‘URL Pattern to match’.

I would recommend using a custom column called ‘Slug’ or ‘Post Name’ in Airtable. So for a restaurant named, “Joe’s Dingy Tavern” you would probably want the slug/postname to be, “joes-dingy-tavern”.

In that case, your filterByFormula would be:

{Slug} = ‘$1’

Then you could access this Virtual Post by visiting:

example.com/restaurants/joes-dingy-tavern

Here’s a helpful resource for experimenting with regular expressions:
http://www.phpliveregex.com/p/iFW

Let’s move support discussions to the Wordpress support forum:
https://wordpress.org/support/plugin/airpress

Devin_Balkind
6 - Interface Innovator
6 - Interface Innovator

Thanks. Very helpful information. The API URL/APP ID graphic is useful. I’d add that to your wordpress.org docs as well as an explanation of the filter. I did as you suggested and it worked well. But I haven’t gotten the name of the row to show up as the WordPress post name. Will experiments how to do that and post in the wordpress.org forum if I can’t figure it out.

I’d recommend publishing the text of the screenshot images so please can copy/paste into their sites, which would give them working code that can show them the power of this plugin.

I’ll be experimenting much more with this plugin on a few sites (I’m all about WordPress + AirTable!) so will make further posts with challenges and recommendations for improved documentation on the WordPress.org forum.

Thanks for this plugin. Very exciting possibilities here.

Thanks for the feedback.

When you say, “…the name of the row…” I’m not sure what you mean. You should be entering a field name into the “Airtable Field to be used as post_name” setting. And that field must contain a string that conforms to Wordpress’ post_name parameters… i.e. all lower case, alphanumeric, etc.

Let me know how it goes, and if it’s still not working maybe we could do a Google Hangout.

I would appreciate a screencast demo or something like that. I don’t get it to work :frowning:

Me too please… Can’t get this to work at all.

Coming soon! In the meantime, if you can share or private message me screenshots of your virtual post or virtual fields configuration screens that would be helpful.

Gabriel_Gallagh
4 - Data Explorer
4 - Data Explorer

This looks awesome!
I’m kind of trying to go in the other direction though.
I want my Airtable to reflect data in WordPress.
Two-way sync on some fields would be awesome!
Will AirPress help me at all with that?

For example, If I want a list of all my woocommerce orders and user accounts (as 2 different sheets) in airtable with the orders table having a field that links to the relevant user record and the users table having a field that links the relevant orders records. Ideally, I could edit certain fields in airtable and the changes would be reflected in Woo (like changing a user’s billing address).

I get that that’s not what this was made to do but I’m wondering if it gets me any closer?

Mitchell_Perigo
4 - Data Explorer
4 - Data Explorer

Thank you for the great plugin! The host to my website (pressable) does not support reading the exif information from the images (read_exif_data). When I display the Photos from my airtable, the image is showing in landscape when it was really taken in portrait (on an iphone)… Is there a workaround for this without having to adjust my images?

Note: The thumbnails appear to be transformed correctly, it’s only an issue when viewing the full size image. I’m thinking that the exif data is stripped when airtable produces the thumbnails

If the Airtable interface is showing the image “correctly” but the API is serving it “incorrectly” you should submit a bug report and/or feature request to Airtable. Personally I would expect (or trust) Airtable, Wordpress or any other web service to accurately read-and-apply EXIF data.

If you really need a quick hack, you could create a new field right “next to” the image field that specifies a rotation (0, 90, 180) and use css to apply a transform.