Automators 24: Blog Post Editorial Calendar in AirTable with Shortcuts

Episodes
1

Here’s a screencast showing how Rose runs her editorial schedule through Airtable as discussed on the Automators episode 24.

AirTable Base: https://airtable.com/invite/l?inviteId=invYziVPUsMs643Yi&inviteToken=66f69ccb994b805857e316de3ccd26896be4ad65b9482f72d23952446d32a19b

Shortcut: https://www.icloud.com/shortcuts/a911c16fac084266abc5ae6e5d34c647

2 Likes
2

Thank you for this. I’d like to take it a step further. I have a similar editorial calendar, but one of the fields is an array of record IDs which pull from a related table.

So for example, let’s say I have a field “Title” in table “Editorial Calendar”, and a field “Series” which pulls a list of “series” from a table called “Shows” within the same base. My question is whether I can present the user (me) with a list of available options based on the contents of the relevant field in “Shows” so I can have that filled into the new record.

I hope that’s clear. Kind of hard to describe.

3

What you will need to do is to get the records from the show table, and build a dictionary where the key is the title, and the value is the id of the record. Then you choose from those and use the output of the choose from list to put into the dictionary to create a record.

Here’s a rough sample: https://www.icloud.com/shortcuts/f525c08d99014203b0a244dd773e4cd2

Please note: this is untested, and the URL and Get Contents of URL actions aren’t set up.

image
9D463400-2981-46C4-A26E-43D7EF10A02F.png1242×3523 501 KB

1 Like
4

Excellent. Thank you. I’ll give a that a try and learn something new. It’s such a thrill to keep learning things like this at my age. :smile:

2 Likes
5

I’m sure this is an obvious mistake, but I’m getting stuck. I’ve entered my API key as a text file, but I get an error like this:

{“error”:{“type”:“TABLE_NOT_FOUND”,“message”:“Could not find table Social%20content%20calendar \-H in application apptykdqjOtFjQSEk”}}

The URL from the Airtable API has a space followed by a backslash, hyphen, H ( -H). If I don’t include that, I get an “invalid request” error. If I do include the backslash, I get the “Table not found” error (with or without the -H). Any idea what I’m doing wrong?

6

I would try copying and pasting just the URL from the API documentation again, it sounds like something has got a bit stuck somewhere. You definitely don’t need \ -H - that’s part of a curl command which is built into the actions in Shortcuts.

7

Well, I had the URL right, but I am not very good at following directions. I slowed down and actually did what you said to do in the “get contents of URL” step, and lo and behold, it works! Thank you very much!

1 Like