Jan 19, 2017 04:20 PM
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
0 voters
Jan 20, 2017 01:42 AM
Cool stuff! :slightly_smiling_face:
Jan 20, 2017 03:23 AM
any way of adding this to wordpress.com hosted sites? :confused:
Jan 20, 2017 07:32 AM
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 :slightly_smiling_face:
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.
Jan 20, 2017 02:35 PM
This is pretty awesome! Do you have a sample wordpress site running this plug-in?
Jan 20, 2017 02:59 PM
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.
Jan 20, 2017 03:03 PM
Great, thanks Chester… good work!
Jan 21, 2017 07:20 AM
This. Is. Awesome.
My head is swimming with ideas.
Thank,you for,making this available for free.
Jan 22, 2017 08:17 PM
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.
Jan 23, 2017 07:55 AM
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
Jan 23, 2017 09:01 AM
Let’s move the support conversation here to the Wordpress support forum for this plugin.
Quick answer is, visit http://airtable.com/api
Jan 23, 2017 09:09 AM
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
Jan 23, 2017 01:33 PM
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.
Jan 23, 2017 01:53 PM
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.
Jan 25, 2017 03:53 AM
I would appreciate a screencast demo or something like that. I don’t get it to work :frowning:
Jan 26, 2017 10:57 AM
Me too please… Can’t get this to work at all.
Jan 26, 2017 08:41 PM
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.
Feb 01, 2017 04:37 PM
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?
Feb 03, 2017 03:56 PM
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
Feb 03, 2017 04:16 PM
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.