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.
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.
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?
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.
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!