8/28/2021
46

Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. The Airtable API only allows 5 API calls per second. We cache your content & settings on our server so you're not likely to hit that limit. Make sure to turn off development mode on your site to enable caching. We do not currently cache list/cards data so we advice to have a maximum of 2 lists/grids on your website. The embedded gallery updates as you add more info in Airtable. Filter buttons based on views. Search function within the view. Supports playing video attachments! Supports for rendering HTML content in a formula field. Clickable linked records: now you can connect multiple tables together and navigate between them.

Here at TaxJar we work with a lot of interesting datasets to help online sellers figure out sales tax:

My ip address location is wrong country

  • Amazon FBA warehouses
  • Due dates and filing deadlines
  • Product tax exemptions
  • Sales tax holidays
  • And more

We also provide sales tax content across a variety of static and dynamic websites using Middleman, Nanoc, and WordPress. Some of this content overlaps on multiple sites. As our marketing team continues to grow, we need a way to collaborate on this type of presentational data in a single location so it can remain up-to-date and relevant everywhere.

This is why we love using Airtable, a collaborative spreadsheet app with a wonderful and easy to use API. Using Airtable allows our marketing team to easily make changes in a friendly UI. From there we can pull the JSON data and present it however we like, whether it’s a simple list, a sortable table, or even an interactive map:

Getting Started with Airtable

For static websites, integrating with Airtable is straightforward. You’ll want to create a read-only user and use the API key generated for that user to ensure your datasets can only be read, not modified:

Under the account page, click the Generate API key link to generate a new API key for your read-only user:

Log out of your read-only account and log in to your main account. From your main Airtable account, share your bases with the read-only account. Make sure permissions are set to Read only:

Airtable team

Now you can access the API docs specifically tailored for your base:

Keep in mind the API is limited to 5 requests per second. If you exceed this rate, you’ll receive a 429 status code and may need to wait 30 seconds for subsequent requests.

Using the Airtable API

Airtable.com

For this example, we’ll write a quick Vue.js component with Axios to pull JSON data from Airtable and populate it in a Bootstrap table:

To make our AJAX request, we’ll need to provide a URL to a specific Airtable base and a table within that base. You can get the URL using the cURL examples inside the Airtable API docs:

Since we’re using a read-only API key with limited access, we can safely include this key in our JavaScript code to pass in the Authorization header:

At a bare minimum, that’s all you need to get data from Airtable! The rest comes down to formatting and displaying the data to your liking. Let’s scaffold a Vue component with a Bootstrap table template:

Piece of cake 🍰 In your website or app, include the component with the columns you’d like to show from your Airtable:

Perhaps you want to re-use this component across multiple bases and tables / views? Or filter and sort records? Let’s add more props:

Remove the base data param:

Lastly, let’s update our getData method to use the base prop and pass some additional GET query params in the request:

Easy! We now have a dynamic filterable sortable Airtable component that we can use anywhere in our static website. You could take this component even further by supporting fields, maxRecords, pageSize, and other parameters from the Airtable record list endpoints. Use the additional props for your <vue-airtable> markup if needed:

That’s a quick rundown of how we use Airtable at TaxJar. If you have any questions or ideas for other Airtable use cases, let me know in the comments below!

Microsoft today launched Lists, a new 'smart tracking app' for Microsoft 365 users. That may sound a lot like a todo list app and since Microsoft already offers Microsoft To Do, you may wonder why it would bother with Lists, but it seems like Lists goes well beyond a basic to do app. Indeed, Lists seems more like a competitor to Airtable, with the additional all of the usual Microsoft integrations one would expect.

Download

The way Microsoft describes it, Lists is a tool to 'track issues, assets, routines, contacts, inventory and more using customizable views and smart rules and alerts to keep everyone in sync.' It features deep integrations into Teams, SharePoint and other Microsoft products and will launch this summer on the web, with mobile apps slated for later this year.

© Provided by TechCrunch

Based on what Microsoft has shared so far, Lists will feature a bunch of pre-made templates for things like team contacts, event itineraries, business travel approvals and onboarding checklists.

As you can see from that list, it seems like Microsoft has purposely kept the service pretty flexible, so that it can accommodate a lot of use cases. In that respect, it reminds me a bit of services like Trello (and the Lists mobile app bears a striking resemblance to the Trello app).

To enable all of these use cases, Lists include different ways to visualize your lists. For now, there are three views: grid, gallery and calendar. The standard view is 'grid,' which may remind you a bit of Airtable, if you have ever used that. Calendar view explains itself, while the gallery view is ideal for anything that's more visual. And since Lists seems to be all about flexibility, you can also create custom views.

© Provided by TechCrunch

Airtable Page Designer

Unlike Airtable, though, Lists doesn't seem to feature a Kanban view or the ability to enter data through custom forms.

Airtable Site

Airtable Site Builder

Another major feature of Lists is its system for creating rules. 'Once you decide on the outcome, click through if/then steps to evolve your rules,' writes Microsoft in today's announcement. 'Choose people, status, and value changes to send notifications or programmatically update values elsewhere in the list. Finally, use rules to set reminders to keep you and your team informed.'

Since all things Microsoft currently lead to Teams sooner or later, the company is obviously stressing that Lists are obviously integrated with Teams, too, similar to other apps inside the company's communications platform.

© Provided by TechCrunch

Airtable Sites

© Provided by TechCrunch