Hi all
I’m struggling to retrieve airtable entries using Shortcuts.
Can retrieve the first record in the format of a dictionary. But not all records for a specific field.
Any help is sooo welcome!!
Can you post an example of what you have so far?
See if this helps any.
Here’s an example table “Fruit” in my “Fruits” AirTable workspace. It has two columns - “Type” and “Colour”.
I’ve blurred out some of the specific access details (e.g. API key), but here’s what my example workflow looks like to access it and pull back all of the rows (well I limited it to 9,999) from the table. It retrieves the data, grabs the records, then for each record grabs the fields. I then use the fields to build up a list - just an example showing how output can be built.
Hope that points you in the right direction.
2 Likes
Are you sure the 2 Get Dictionary Value steps are needed? You may want to try without the first Get All Values action.
It helped a lot. I’m now able to retrieve the data AND understand the logic!! Thanks!!!
I don’t…it was part of my experiments 
thanks!!!
I would suggest that next time you post this sort of thing as a different question as it isn’t something directly related to AirTable and Shortcuts. It’ll then help people find it in searches. Also do remember to post details of inputs for any examples. Data can be as much an issue as an algorithm.
Here’s an approach for the date query that should work:
It takes a date from input, calculates the difference in days between it and the current date/time. If that is zero, the date parts are the same. If it is non-zero, they are different.
At the end of the day, dates are just numbers. They represent a counter that counts forward (or backward) from an agreed point in time. Think about how you would compare numbers and you shouldn’t go too far wrong.
Hope that helps.
Thanks it does help!!
Kept the question here as it followed up from my previous one, but you’re right not the easiest for someone else to find.
I’m not completely following - these dictionaries are still mysterious to me. I have my shortcut set up the same way as your example, but I don’t understand how you’re able to specify that you want to get the dictionary values for ‘type’ and ‘color’. How/where do you tell Shortcuts to fetch these? When I add the ‘dictionary value’ bit to the text field, and subsequently tap it to specify what it is that I want, I can pick file size, extension etc, but I can’t set any custom thing. What am I missing?
Update: Ah, you have to tap ‘type’ and pick ‘dictionary’ and then you get an option to enter the thing you want the value for!
1 Like
Exactly 
Shortcuts doesn’t know innately what you are working with necessarily, so specifying the type of data you are working with can be necessary. When you do, as you saw, the options/parameters change accordingly.
1 Like
I recognize that I’m commenting on an old post, but I think this gets pretty close to what I’m trying to do. I’m trying to use the GET methodology described above, but to filter it so that I can obtain only a single record from the sheet — a record keyed to a specific date. My use case is that I’ve created an Airtable sheet with columns for “Date,” “Psalm,” and “Old or New Testament Reading”. For each day, I then have an entry for the Psalm I’ll read that day (e.g., “Psalm 23”) and an entry for another passage I’ll read (e.g., “John 3:16”). I’ve got another shortcut that will fetch those passages from a separate API if I enter the passages, but I’d like to be able to set variables for that shortcut by pulling the relevant passages from the day from my Airtable sheet.
To borrow from the shortcut @sylumer posted above — it’d be as though the database contained only a single entry for “pear,” and I wanted to filter for that, then have it return the value “green” (plus one other value from the same record).
Has anyone implemented something similar? (I can post my attempted shortcut, but I suspect it’s not even close to correct so I don’t think it’d be helpful.)