I’m working on a Shortcut that finds a record on one of my tables in Airtable and then and sets one of its fields to “true”. Everything works great. But you can only fetch 100 records at a time and my table has 500 records in it. Can’t seem to figure out how to get to the next 100 page. I think my “offset” syntax is wrong. Anyone have thoughts on this?
1 Like
Ok I figured it out. I was missing a”?” as a query. So it should have been “?&offset=“ to fetch the next 100 records from Airtable. I’ve made a Shortcut that randomly picks from a list of the Rolling Stone Magazine Top 500 Albums Of All Time. It then plays the album from Apple Music, opens up Wikipedia and searches info about the album, Searches the same list on Airtable and tells it that I’ve listened to that album, and saves the pick in Notes which it checks to see if it’s already picked an album in which case it picks again till it finds one it hasn’t picked. Here are the three Shortcuts -
https://www.icloud.com/shortcuts/2449ba9621124da0b80ca7c5d2a5fc99
https://www.icloud.com/shortcuts/8585bb5322c1476d9c9fdf2251edfcad
https://www.icloud.com/shortcuts/a0b102b634384cd4a3431bc87568e1c0
3 Likes
Ooh, I like this idea! Thanks for sharing!
Thanks Kaitlin. I’ve updated it by taking out the Notes action and just used Airtable to pick the albums that way I only need two Shortcuts to run it.
https://www.icloud.com/shortcuts/8072fd297a004c93864c0ac5a15ade10
https://www.icloud.com/shortcuts/06c27a3c507b45fa8f4944764326d72e
1 Like
Hello.
I’m having the same issue.
How should I add the ?&offset= to url ?
Hi! I don’t worry about the offset anymore. I search directly for albums that I haven’t listened to on Airtable using the filterby formula.
The “app500” is the API for the “500” album table value that I store on Data Jar. .