Save the date! Join us on October 16 for our Product Ops launch event. Register here.
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 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.