Home About Books Podcasts Archives Search Feed

Most recent post:

Creating a Recommended podcast episodes” Airtable that updates with iOS Shortcuts

As I write this sentence, I have no idea how to do this. But by the end of the blog, hopefully I’ll have figured it out. If at the end of this I still have no idea how to do it, I’ll still post the blog but write Help!” on twitter, perhaps @ other people who might know better how to do this stuff.

Here’s what I want to have happen. When I listen to a podcast and like it, I want to say to my phone recommend podcast.” I want those two words to trigger automatic computer things that do the job of putting an entry in a spreadsheet.

I want to do this because I figure it’s the perfect way to learn more about the Airtable API, and put all the podcast episodes I like into one place.

So, here’s what I did.

I created the Airtable database and filled in the recommended shortcuts from this blog going back to fall last year.

I searched Routinehub for a few Airtable shortcuts that might show me how to put this together.

I took a few minutes to figure out where the API documentation resides on Airtable.com. It’s in Help”!

I watched Automators 24: Blog Post Editorial Calendar in AirTable with Shortcuts. Then, I downloaded the sample base and shortcut from the tutorial.

So based on that advice, I made a txt file with the API key. I grabbed the url and placed it in the shortcut. And I modified the fields to match my database.

Then, I pre-pended these shortcut items with my current Share Overcast” shortcut items.

I got a No URL Specified” error. So I watched the video again and fixed my error. I’d accidentally selected Get URL from file” as opposed to URL.

It didn’t give me an error the next time, but it also didn’t actually send anything to Airtable. So I deleted the txt KEY file and just pasted in the key and renamed some of the columns. This time it got a little farther, but I got a new error:

{“error”:{“type”:“INVALID_VALUE_FOR_COLUMN”,“message”:“Field Last Modified” cannot accept a value because the field is computed”}}

So I deleted the Last Modified” field and tried again. And this time it worked! I got this result:

{“id”:“recAvI1IWUE7ibpfk”,“createdTime”:“2019-08-19T18:06:03.000Z”,“fields”:{“Episode Title”:“Kotaku”,“Last Modified”:“2019-08-19T18:06:03.000Z”,“Episode URL:“https:\/\/overcast.fm\/+FKOa63VXI}}

The airtable database updated with the Overcast URL and the title that I wrote in (unfortunately Overcast will only give me a URL, nothing else).

Then I put the txt file for the API key back in, since that was never actually a problem. My columns just needed to be types in properly.

I added in Ask for Show Title” and Ask for description” text inputs so that they can be included along with the URL. Getting that automated will be extra credit on this project, but as it stands, I’ve made this work for now.

Posted on 20/8/2019   #Airtable     #Shortcuts  

Recent posts:

Logbook, August 12-18, 2019  ·  19/8/2019 Cura, August 15, 2019  ·  15/8/2019 Logbook, August 4-11, 2019  ·  12/8/2019 Apple USB 3 to Lightning Camera Adapter Review  ·  12/8/2019 Photos from The Summit  ·  10/8/2019 Cura, August 8, 2019  ·  8/8/2019 Animal Crossing New Leaf  ·  8/8/2019 Logbook, August 3, 2019  ·  3/8/2019 Logbook, August 2, 2019  ·  2/8/2019 Logbook, August 1, 2019  ·  1/8/2019 Logbook, July 31, 2019  ·  31/7/2019 Cura, July 31, 2019  ·  31/7/2019 Logbook, July 30, 2019  ·  30/7/2019 Logbook, July 29, 2019  ·  29/7/2019 Logbook, July 28, 2019  ·  28/7/2019 Logbook, July 27, 2019  ·  27/7/2019 Logbook, July 25, 2019  ·  25/7/2019 Logbook, July 24, 2019  ·  24/7/2019 Logbook, July 23, 2019  ·  23/7/2019 Logbook, July 22, 2019  ·  22/7/2019 Logbook, July 21, 2019  ·  21/7/2019 Logbook, July 20, 2019  ·  20/7/2019 Logbook, July 20, 2019  ·  20/7/2019 Logbook, July 18, 2019  ·  18/7/2019 Logbook, July 17, 2019  ·  17/7/2019 Logbook, July 16, 2019  ·  16/7/2019 Keeping a Logbook  ·  16/7/2019 Podcast Recommendations, July 16, 2019  ·  16/7/2019 More Things, July 15, 2019  ·  15/7/2019 G1 Climax Airtable, refined  ·  14/7/2019

Next page →