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

#1

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

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

Pulling Airtable data into WordPress to display in a data table
Want to use the Airtable API with Wordpress? It just got much easier!
EXport Airtable Records in a Custom PDF Report
Wordpress Plugin
#2

Cool stuff! :slight_smile:

#3

any way of adding this to wordpress.com hosted sites? :confused:

#4

Short answer, no. You could always request it, however Wordpress.com states that only the “most popular” plugins are included so my humble little Airpress has a long way to go :slight_smile:

With so many managed Wordpress hosts (MediaTemple, GoDaddy, WPEngine to name three of hundreds) you could always consider switching to Wordpress.org — it’s not as hard as it may seem.

#5

This is pretty awesome! Do you have a sample wordpress site running this plug-in?

#6

Short answer, not yet but you can checkout the screenshots.

Long answer is that I do have multiple live client sites that I’m in the process of migrating to the plugin (from the original code I wrote pre-plugin) and I have a local development “test” site I’m using to ensure updates don’t break existing functionality. One of my next steps is to put that test site live using the template base “Restaurant Guide” that Airtable provides as the backend. In the meantime, check out the screenshots for the plugin to get a glimpse of the test site in action. The screenshots show configuration, post editor, and final output.

#7

Great, thanks Chester… good work!

#8

This. Is. Awesome.

My head is swimming with ideas.

Thank,you for,making this available for free.

#9

Hi. I set this up and the connection is working but when I try to go to a virtual post all the content in my AirTable comes out. I wonder if this has something to do with the “Filter by formula” field? I didn’t know what to put in there so I deleted it. When I use the same input in your screenshots {RECORD_ID} = ‘$1’ I get no results.

Is there a better place for me to post these types of questions?

Thanks - very excited about this plugins potential.

#10

Hi Chester - I have downloaded and installed your plugin and I’d like to access and display (and edit?) data from an Airtable database of volunteers’ details.
Your plugin shows screenshots of every screen but the Connection screen. I’m OK with the API but the next 2 fields

  • is the APP ID the Database Name?
  • where do I get the APP URL?
    Very appreciative of your efforts - is there any documentation anywhere please?
    Just on an interface level - it would be really useful to have some of box sizes on the configuration forms a bit wider so long urls and api keys etc can be seen in full.
#11

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

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

#12

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

#13

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.

#14

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.

#15

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

#16

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

#17

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.

#18

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?

#19

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

#20

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.