An Airtable extension for Raycast - browse a list of bases, tables, and more without opening a b

[marks]

Hot off the heels of this week’s exciting API auth and documentation updates, I’m excited to show and tell you about a Raycast extension that uses the new OAuth and metadata endpoints.

First - What’s Raycast? Raycast is an extendable alternative to Apple’s Spotlight.

The new Airtable Raycast extension allows a user to browse the bases, tables, fields, and views they granted the application access to (a part of the Airtable OAuth flow).

A GIF of the basic functionality is below and you can follow this link to the Raycast extension store to learn more and install the extension.

The extension is open source at https://github.com/Airtable-Labs/raycast-extension and https://github.com/raycast/extensions/tree/main/extensions/airtable

Let me know if you have any questions or suggestions. I think there’s a lot that could be improved and would love to hear your ideas too!

Special thanks to @SeanKeenan and other teammates for their help!

–

And lastly, an obligatory legal disclaimer since this is not an official Airtable product: The software made available from this extension is not supported by Formagrid Inc (Airtable) or part of the Airtable Service. It is made available on an “as is” basis and provided without express or implied warranties of any kind.

[g4knr]

This is incredible. Great work, I love both tools so I'm very excited to give this a shot!

[marks]

Great to hear, @g4knr ! Would appreciate any feedback or feature requests. I think there's a lot of directions it could be taken in (such as creating records, viewing records, etc.)

[egordin]

This is awesome - thank you! Would love the ability to fill out an Airtable form (to create a record) using Raycast. That's got to be high on the to do list right?

[spancakes]

It would be great if we could search by the primary field or something like that. I can do this in Alfred with a tiny bit of code, but it appears more complex in Raycast.

API_KEY=""
BASE=""
TABLE=""
QUERY="$1

curl "https://api.airtable.com/v0/$BASE/$TABLE?fields%5B%5D=Name&filterByFormula=REGEX_MATCH(%7BName%7D%2C+%22(%3Fi)$QUERY%22)&maxRecords=9" \
-H "Authorization: Bearer $API_KEY" | jq '{items: [ .records[] | { title: .fields.Name, arg: .id, subtitle: "Open in Airtable", autocomplete: .fields.Name }]}'