Skip to main content

· 2 min read
Dan Ferguson

The Cash Kings Betting is helping Australians grow their wealth through passive income and new-age market opportunities.

They're a digital-first company, focusing on delivering curated educational content, along with building the tools to help give their clients the edge they need to rise amongst the rest. They drive success through their strong community and client support team, founded on perseverance and learning.

Why Airtable?​

The team over at The Cash Kings Betting are truly customer focused. Their industry is heavily data-driven, yet the technology is stuck in the stone ages. When it comes to timing the market, you need to shave as much time between analyists finding opportunities, and delivering this information to the client as possible.

They also needed something that could grow with their team, and enable them to work with increasingly more dynamic data, whilst being intutive enough for non-technical stakeholders to work with effortlessly. It needed to get out of their way, so they could focus on doing what they do best.

This is why they chose Airtable.

Their team got to work - moving content like tips, results, and analyses from a variety of sources like Google Spreadsheets and Wordpress into Airtable, instantly centralising their vendor sprawl. Quickly, non-technical team members were able to build the tracking sheets of their dreams, with the ability to create joins and links between rows, sheets, and even bases (read: spreadsheets).

Suddenly, everything was in the one place. Duplicate data was reduced to almost zero, and there were proper controls in place for who could access, edit, and update what.

Their development team quickly got to integrating their data onto the frontend - now able to power their results sheets, data-driven pages and customer experience in real-time; no longer needing to wait for manual work to be done, or daily automations to run in order to update multiple different sources of information - it was now all in one.

But hold on... Airtable announced that they were no longer the serving of static files in the form of attachments! All of that work. Was it all for naught?...

Airproxy map

☁️ Airproxy, to the rescue.​

Airproxy's (self-admittedly 😏) powerful platform features allowed The Cash Kings Betting's team to keep their focus on delivering amazing experiences to their customers, and left all of the caching of data and content to the nerds (us! 🤓).

With a Business tier, The Cash Kings Betting was able to...

  • use Airtable as a CDN, hosting their static files,
  • serve their content to thousands of clients, even on the busiest of seasons without worrying about anything crashing, and of course
  • they could keep their data centralised, breaking down data silos, allowing them to keep finding new opportunities and increasing the likelihood to cross-pollinate success across the brand!

Can we help you?​

Are you in a similar position? We'd love to help you focus on your product, and not your infrastructure. Reach out to our team to setup a call, or get started with a free account and try Airproxy out for yourself!

· One min read
Dan Ferguson

Airtable recently announced quite a serious change to how their API is going to operate; and frankly, it's a serious shift that affects a lot of users.

Even months after the change, the community still has questions about how the new system works, what they can do to adapt their businesses to the changes, and whether Airtable can still provide the functionality they need to keep innovating.

We at ☁️ Airproxy were shocked to see this change. While we understand that Airtable may want to focus on internal systems, it leaves many businesses wondering whether it's the right platform for them.

However - if you're in the same boat as us, wondering what to do, we've got a solution.

Introducing ☁️ Airproxy​

Airproxy is a tool that enables you to use Airtable in production, fearlessly. Scale instantly, serve static files, globally, all while keeping your response times low. We do the heavy lifting, so you can focus on doing what you do best.

Interested? Give Airproxy a whirl for free, and see just how powerful you can be with Airtable, and Airproxy. #airstack ☁️🥞

Want to see how Imperial Wealth is using Airproxy to power their global, data-intensive business? Check out their case study below!

· 2 min read
Dan Ferguson

Imperial Wealth is a one-stop platform for everything you need to learn, and capitalise on new-age markets; providing education, tools, and services in domains such as Betting (arbitrate, +EV, middles), Forex (commodities, stocks, forex), and Cryptocurrency (mining, DeFi, trading).

Why Airtable?​

When Imperial Wealth was designing their platform, they knew they needed a platform that was versatile enough to enable them to response to market changes quickly, empower their development team to iterate quickly and allow their industry experts to deliver information quickly to clients as soon as it becomes available.

This is why they chose Airtable.

Airtable allows Imperial Wealth to stay one step ahead of their competition; focusing on delivering exceptional value to their clients, rather than dedicating precious resources to the management of platforms like Wordpress.

However, as they continued to grow, they ran into problems; and if you've used Airtable in production, you'll know them too - the API has a hard time scaling. On top of that, Airtable recently made a change that meant that you now can't host static files like images on their service and use it as a content delivery network.

This presented Imperial Wealth with quick a dilema - would they need to ditch Airtable and move to another platform? If so, which one? How many resources will they need to dedicate to this? How can they keep it reliable, fast, and allow their team to focus on product, not infrastructure?

Well, that's where Airproxy comes in.

☁️ Airproxy, to the rescue.​

When we heard of Imperial Wealth's issues, we knew we could help. With a Business tier, Imperial Wealth could quickly sign up, setup a Personal Access Token and with a simple swap of their API endpoints, they were off to the races.

With their Business tier, they're able to:

  • Serve up to 20,000 users per month, globally,
  • Serve up to 500,000 requests per month, instantly,
  • Set custom Time-To-Live (TTL) settings on each table,
  • Protect their data, with APIs for each base, and
  • Serve all of their assets like images using a global CDN.

Our teams can now easily use the data they need to create great content for our users, and our developers can focus on other important tasks instead of optimizing our Airtable integration. Airproxy has been a game-changer for our business and I highly recommend it to anyone looking to unlock the full potential of Airtable's API.

- Daniel Pugh, CDO @ Imperial Wealth

Can we help you?​

Are you in a similar position? We'd love to help you focus on your product, and not your infrastructure. Reach out to our team to setup a call, or get started with a free account and try Airproxy out for yourself!

· 2 min read
Dan Ferguson

Are you looking for a better way to manage your agile team and projects? While there are many project management tools out there, such as Jira and Monday.com, Airtable offers a unique and versatile solution.

Airtable is an online platform that allows teams to collaborate and manage their agile projects in one central location. With Airtable, you can create customizable views and organize your project information into different tables and blocks. This makes it easy for your team members to see what needs to be done, who is responsible for each task, and when it's due.

One of the key benefits of using Airtable for agile management is its ability to integrate with other tools and platforms. This allows your team to easily share information and collaborate on projects in real time. For example, you can use Airtable to track the progress of your agile sprints, and then use integrations with project management tools like Trello or Jira to manage your individual tasks and issues.

Additionally, Airtable's integration with Zapier enables you to automate certain tasks and processes. For example, you can use Zapier to automatically send email reminders to your team members when a task is due, or to trigger a notification in Slack when a task is completed. This helps to streamline your agile workflow and ensure that your team stays on track and meets its deadlines.

Another advantage of using Airtable for agile management is its user-friendly interface. Unlike complex project management tools like Jira and Monday.com, Airtable has a clean and intuitive design that makes it easy for team members to navigate and use. This allows even those who are not familiar with agile principles or technology to contribute and collaborate on your projects.

In conclusion, Airtable is a powerful platform that can help teams collaborate and improve their agile management practices. From customizable views and integrations with other tools, to automation and a user-friendly interface, Airtable offers a unique and versatile solution for agile teams. Give it a try and see how it can help your team streamline your agile workflow and achieve success.

· 2 min read
Dan Ferguson

Are you tired of using clunky and outdated programs to organize your data? Are you looking for a more intuitive and user-friendly platform to manage your spreadsheet information? Look no further than Airtable.

Airtable is a versatile online platform that allows you to import your Excel or Google Sheets data and manage it in a more flexible and visually appealing way. With Airtable, you can create customizable views, organize your information into different tables and blocks, and even access your data on the go with the Airtable mobile app.

One of the biggest benefits of using Airtable over traditional spreadsheet programs is its ability to integrate with other tools and platforms. This means you can easily share your data with your team members and collaborate on projects in real time. Additionally, Airtable offers a wide range of integrations with popular services such as Google Drive, Slack, and Zapier, giving you even more flexibility and control over your data.

Another advantage of Airtable is its user-friendly interface. Unlike Excel or Google Sheets, which can be overwhelming for those who are not familiar with spreadsheets, Airtable has a clean and intuitive design that makes it easy to navigate and use. This makes it an ideal platform for individuals and teams who want to manage their data without having to spend a lot of time learning complex spreadsheet formulas and functions.

So, how do you import your Excel or Google Sheets data into Airtable? It's simple:

  1. Sign up for an Airtable account and log in to your account.
  2. Click on the "New Base" button in the top right corner of the screen.
  3. Select the "Import" option from the menu that appears.
  4. Choose the Excel or Google Sheets file you want to import, and click on the "Open" button.
  5. Airtable will automatically convert your spreadsheet data into a new base, which you can then customize and organize according to your preferences.

With Airtable, you can easily import your Excel or Google Sheets data and manage it in a more flexible and user-friendly platform. From customizable views and integrations with other tools, to a clean and intuitive interface, Airtable offers a wide range of benefits over traditional spreadsheet programs. Give it a try and see how it can help you streamline your data management process.

· 2 min read
Dan Ferguson

Are you concerned about the security of your data on Airtable? As more and more businesses turn to online platforms to manage their data and collaborate with their teams, security has become a top concern. Fortunately, operating on the Airtable platform itself is very secure.

Airtable offers a number of features to help you protect your data and control who has access to it. For example, you can restrict editing of certain columns to specific roles, ensuring that only authorized users can make changes to sensitive information. Additionally, Airtable supports single sign-on (SSO) through popular identity providers like Google and Microsoft, allowing you to easily manage and control access to your Airtable account for your business users.

Another security feature of Airtable is its encryption at rest. This means that your data is automatically encrypted when it is stored on Airtable's servers, ensuring that it is protected from unauthorized access. Airtable also uses secure sockets layer (SSL) technology to encrypt data in transit, so your information is protected when it is being transmitted between your device and Airtable's servers.

However, it's important to note that the Airtable API is not designed for serving your business data directly to your clients. While the Airtable API is powerful and flexible, it is not intended for use in production environments where you need to control access to your data and ensure its security.

That's where Airproxy comes in. Airproxy is a service that enables you to safely and securely serve your Airtable data to your clients, without compromising its security. With Airproxy, you can easily control access to your data by using per-base API keys, ensuring that only authorized users can access your information. Additionally, Airproxy uses SSL technology to encrypt data in transit, so your data is protected as it is being transmitted between your clients and Airproxy's servers.

In conclusion, Airtable is a secure platform for managing and collaborating on your data. With its encryption at rest, SSL encryption, and control over access to your data through roles and SSO, Airtable offers a high level of security for your information. However, if you need to serve your data directly to your clients, Airproxy offers an additional layer of security and control over access to your data. Give it a try and see how it can help you protect your information and maintain control over who has access to it.

· 2 min read
Dan Ferguson

As a business owner or marketer, you know the importance of having a strong social media presence. But coordinating and executing a successful social media strategy can be a daunting task, especially if you're working with a team. That's where Airtable comes in.

Airtable is a powerful online platform that allows teams to collaborate and manage their social media strategy in one central location. With Airtable, you can create customizable views and organize your social media content into different tables and blocks. This makes it easy for your team members to see what needs to be done, who is responsible for each task, and when it's due.

One of the key benefits of using Airtable for your social media strategy is its ability to integrate with other tools and platforms. This allows your team to easily share information and collaborate on projects in real time. For example, you can use Airtable to draft and review social media posts, and then use integrations with platforms like Hootsuite or Buffer to schedule and publish the content.

Additionally, Airtable's integration with Zapier enables you to automate certain tasks and processes. For example, you can use Zapier to automatically send email reminders to your team members when a social media post is due, or to trigger a notification in Slack when a post is published. This helps to streamline your social media workflow and ensure that your content is delivered on time and to the right channels.

Another advantage of using Airtable for your social media strategy is its user-friendly interface. Unlike complex project management tools, Airtable has a clean and intuitive design that makes it easy for team members to navigate and use. This allows even those who are not familiar with social media or technology to contribute and collaborate on your social media efforts.

In conclusion, Airtable is a powerful platform that can help teams collaborate and execute a successful social media strategy. From customizable views and integrations with other tools, to automation and a user-friendly interface, Airtable offers a wide range of benefits for businesses and marketers. Give it a try and see how it can help your team streamline your social media efforts.

· 2 min read
Dan Ferguson

To use the Airtable API with Express scripts, you will need to follow these steps:

  1. Sign up for an Airtable account and create a base that includes the fields you want to use with the API.

  2. Generate an API key for your Airtable account. You can do this by going to the Airtable API dashboard and clicking on the "Generate API key" button.

  3. Install the Airtable Node.js client library. This library provides a simple and easy-to-use interface for interacting with the Airtable API from your Express scripts.

npm install airtable
  1. In your Express script, require the Airtable library and create a new instance of the Airtable object, passing in your API key and the ID of your Airtable base.
const Airtable = require("airtable");
const airtable = new Airtable({ apiKey: "YOUR_API_KEY" });
const base = airtable.base("BASE_ID");
  1. Use the methods provided by the Airtable object to make API requests and manipulate your Airtable data. For example, you can use the "create" method to create new records in your Airtable base, or the "update" method to update existing records.
base("Table1")
  .select({
    view: "Grid view",
  })
  .eachPage(
    function page(records, fetchNextPage) {
      records.forEach(function (record) {
        console.log("Retrieved", record.get("Name"));
      });
      fetchNextPage();
    },
    function done(err) {
      if (err) {
        console.error(err);
        return;
      }
    }
  );

base("Table1").create(
  {
    Name: "New item",
    Description: "This is a new item",
  },
  function (err, record) {
    if (err) {
      console.error(err);
      return;
    }
    console.log(record.getId());
  }
);
  1. Use the Express framework to route and handle the API requests and responses, and to integrate the Airtable functionality into your web application.
const express = require("express");
const app = express();

const Airtable = require("airtable");
const airtable = new Airtable({ apiKey: "YOUR_API_KEY" });
const base = airtable.base("BASE_ID");

app.get("/items", function (req, res) {
  base("Table1")
    .select({
      view: "Grid view",
    })
    .eachPage(
      function page(records, fetchNextPage) {
        res.send(records);
        fetchNextPage();
      },
      function done(err) {
        if (err) {
          res.status(500).send(err);
          return;
        }
      }
    );
});

app.listen(3000, function () {
  console.log("Listening on port 3000");
});

This code creates an Express app with a route that retrieves all the records from the Table1 table in your Airtable base and sends them back in the response to the client.

To use this route, you would send a GET request to http://localhost:3000/items and the response would be a JSON array of records from the Table1 table.

Overall, using the Airtable API with Express scripts is a straightforward process that allows you to easily integrate Airtable functionality into your web applications. By following the steps outlined above, you can use the Airtable API with Express to create, read, update, and delete records in your Airtable bases.

· 2 min read
Dan Ferguson

Whether Airtable is a suitable backend for your website depends on a number of factors, including the specific needs and requirements of your website, your budget, and your technical capabilities.

Here are a few potential benefits and drawbacks of using Airtable as the backend for your website:

Benefits​

Easy to use​

Airtable has a user-friendly interface that makes it easy to manage and organize your data, even if you don't have a lot of technical experience.

Flexible data management​

Airtable allows you to create custom tables, views, and fields to store and display your data in the way that makes the most sense for your website.

Collaboration features​

Airtable has built-in collaboration features that make it easy for multiple people to work on the same data, which can be useful if you have a team working on your website.

Drawbacks​

Dependence on a third-party service​

Airtable is a cloud-based service, which means that you're relying on their servers and infrastructure to store and manage your data. This can be convenient, but it also means that you don't have as much control over your data and you're at the mercy of Airtable's uptime and performance.

Cost​

Airtable has a free plan, but it is limited in terms of the number of records and the amount of data you can store, as well as the features that are available. If you need more storage or advanced features, you'll need to upgrade to one of the paid plans, which can be relatively expensive.

Request limit​

The Airtable API has a limit of 5 requests per second, which can be a limitation if your website receives a high volume of traffic. If you exceed this limit, your requests will be throttled and you may experience delays in getting the data you need.

Overall, Airtable can be a good backend solution for some websites, especially if you need an easy-to-use platform with flexible data management and collaboration features. However, you should carefully consider the potential drawbacks and whether they are acceptable for your website before deciding to use Airtable as your backend.

· 2 min read
Dan Ferguson

To use Airtable with WordPress and React, you'll need to create a WordPress plugin that exposes an API endpoint for your React app to access the data in your Airtable base.

Here's a general outline of how you can do this:

  1. Install the airtable npm package on your WordPress site:
npm install airtable
  1. Create a new WordPress plugin and add the code to require the airtable package and create a new Airtable object with your API key and the base ID for the Airtable base you want to access:
const Airtable = require("airtable");
const airtable = new Airtable({ apiKey: "YOUR_API_KEY" });
const base = airtable.base("BASE_ID");
  1. Add an API endpoint to your plugin that uses the base object to retrieve the data from the Airtable base and return it in the response to the client. For example, you could create an endpoint that returns the data from a specific table in your base:
add_action( 'rest_api_init', function() {
    register_rest_route( 'myplugin/v1', '/items', array(
        'methods' => 'GET',
        'callback' => 'get_items'
    ) );
} );

function get_items() {
    base('Table1').select({
        view: 'Grid view'
    }).eachPage(function page(records, fetchNextPage) {
        return records;
        fetchNextPage();
    }, function done(err) {
        if (err) {
            return new WP_Error( 'cant-get-items', __( 'Error getting items from Airtable', 'my-text-domain' ), array( 'status' => 500 ) );
        }
    });
}

This code creates an endpoint at /wp-json/myplugin/v1/items that will return the data from the Table1 table in your Airtable base when a GET request is sent to that endpoint.

  1. In your React app, you can use the fetch API or a library like Axios to send a GET request to the API endpoint and retrieve the data from the Airtable base. For example:
import React from "react";
import axios from "axios";

class MyComponent extends React.Component {
  state = {
    items: [],
  };

  componentDidMount() {
    axios
      .get("/wp-json/myplugin/v1/items")
      .then((res) => {
        this.setState({ items: res.data });
      })
      .catch((err) => {
        console.error(err);
      });
  }

  render() {
    return (
      <ul>
        {this.state.items.map((item) => (
          <li key={item.id}>{item.fields.Name}</li>
        ))}
      </ul>
    );
  }
}

This code uses Axios to send a GET request to the API endpoint and then updates the state of the component with the retrieved data. The data is then displayed in a list in the component's render method.

· One min read
Dan Ferguson

We are excited to announce the public release of Airproxy, the world's leading edge caching service for Airtable's API. Airproxy allows you to access your Airtable data with millisecond response times and unlimited scaling capabilities, so you can focus on building great experiences for your users.

At Aaiga, we have been serving thousands of clients around the globe for multiple businesses, and we are thrilled to be able to offer this powerful tool to the public. With Airproxy, you can unlock the full potential of Airtable's API and take your business to the next level.

Some of the key features of Airproxy include:

  • Edge caching: Airproxy caches Airtable API responses on the edge, so you can access your data with lightning-fast response times, no matter where you are in the world.
  • Unlimited scaling: Airproxy allows you to scale your Airtable integration to meet the needs of your business, without worrying about hitting the API request limit or experiencing delays.
  • Global availability: Airproxy has a global network of edge nodes, so you can access your data from anywhere, anytime.
  • Easy to use: Airproxy is easy to integrate with your Airtable base, so you can get started quickly and start enjoying the benefits of edge caching.

We are confident that Airproxy will revolutionize the way you use Airtable's API, and we can't wait to see the amazing things you will build with it. Sign up now and start using Airproxy today!

· 2 min read
Dan Ferguson

If you want to create multiple records in your Airtable base in a single API request, you can use the Airtable API's "create" endpoint with an array of record objects in the request body. This allows you to create multiple records at once, which can be more efficient and convenient than making separate API requests for each record. In this article, we will explain how to create multiple records in Airtable using the API.

First, you will need to sign up for an Airtable account and create a base that includes the fields you want to use for your records. Once you have created your base and added the necessary fields, you will need to generate an API key for your Airtable account. You can do this by going to the Airtable API dashboard and clicking on the "Generate API key" button.

Next, you will need to use the Airtable API endpoint for creating records to create your records. The API endpoint for creating records is https://api.airtable.com/v0/base_id/table_name, where base_id is the ID of your Airtable base and table_name is the name of the table in your base where you want to create the records.

To create multiple records in a single API request, you will need to make a POST request to the API endpoint and include an array of record objects in the request body. Each record object should include the field names and values for the record you want to create. You can also include additional information, such as the record's ID or attachment fields, as needed.

Once you have made the POST request to the API endpoint with the array of record objects, the records will be created in your Airtable base. You can then use the Airtable API to read, update, or delete the records, as needed.

In conclusion, creating multiple records in Airtable using the API is a simple and efficient way to manage your data. By following the steps outlined in this article, you can easily create multiple records in a single API request and maintain your Airtable base with minimal effort.

· 2 min read
Dan Ferguson

Airtable is a cloud-based database and collaboration platform that is popular for its user-friendly interface and flexible data management features. However, it is not without its drawbacks. Some potential drawbacks of using Airtable include its cost, the API request limit of 5 requests per second, limited customizability, and dependence on a third-party service. While Airtable offers many benefits, it is important to carefully consider these limitations before using it for your data management needs.

Some potential drawbacks of using Airtable include:

  • Cost: Airtable has a free plan, but it is limited in terms of the number of records and the amount of data you can store, as well as the features that are available. If you need more storage or advanced features, you'll need to upgrade to one of the paid plans, which can be relatively expensive.
  • Limited customizability: While Airtable provides a lot of flexibility and features, there are still some limitations in terms of how much you can customize the way your data is stored and displayed. For example, you can't create custom field types or add custom validation rules for your data.
  • Dependence on a third-party service: Airtable is a cloud-based service, which means that you're relying on their servers and infrastructure to store and manage your data. This can be convenient, but it also means that you don't have as much control over your data and you're at the mercy of Airtable's uptime and performance.
  • Request limit: The Airtable API has a limit of 5 requests per second, which can be a limitation if you have a high volume of requests. If you exceed this limit, your requests will be throttled and you may experience delays in getting the data you need.

Overall, Airtable is a powerful and flexible tool for managing and organizing data, but it's not without its limitations. You should carefully consider these limitations and how they might impact your use of Airtable before you decide to use it.

· 2 min read
Dan Ferguson

Are you looking to integrate your Airtable account with other applications or services? One of the first steps in doing so is to generate a personal access token.

Here is a step-by-step guide on how to get a personal access token on Airtable:

  1. Log into your Airtable account and click on your profile avatar in the top right corner. From the dropdown menu, select "Account".
  2. Scroll down until you see the "API" section and click on the 'Try it now' link.
  3. Next, click 'Create Token'. You will be prompted to enter a name for your API key. This is simply a label that will help you identify this key in the future.
  4. Add the appropriate scopes - we recommend only giving the key access to the scopes that are absolutely necessary. For Airproxy, these are data.records:read and schema.bases:read.
  5. Then, add the bases that you want the key to have access too. For Airproxy, we recommend you select All current and future bases in all current and future workspaces so that we can register all of your bases, and any you create in the future. Don't worry though, you have total control over what's made public on your Airproxy Dashboard.
  6. Finally, click 'Create token'.

Your personal access token will be displayed on the screen. Copy this token and save it in a secure location.

To use your personal access token, you will need to provide it as a parameter when making requests to the Airtable API.

It is important to note that your personal access token grants access to all of the bases and tables that you gave it access to in step 5. Be sure to keep it secure and only share it with trusted individuals or services.

In addition, you can always revoke a personal access token by going back to the "API" section in your Airtable account settings and clicking on the "Revoke" button next to the key you want to revoke.

By following these steps, you can easily generate a personal access token on Airtable and take the first step towards integrating your Airtable account with other applications or services.

· 3 min read
Dan Ferguson

Airtable is a cloud-based database and collaboration platform that makes it easy to manage and organize your data. It's user-friendly interface and flexible data management features make it a great tool for project management, and its built-in collaboration features make it easy for teams to work together on the same data.

Here are a few steps for using Airtable as a project management tool with your team:

  1. Create a new base in Airtable and add the tables you need to track your project's data. For example, you might have tables for tasks, milestones, and team members.

  2. Define the fields and data types for each table. Airtable provides a range of field types, such as text, date, number, and attachment, that you can use to store different types of data.

  3. Add records to your tables to track the data for your project. For example, you could add a record to the tasks table for each task you need to complete, and a record to the milestones table for each milestone in your project.

  4. Use views to organize and display your data in the way that makes the most sense for your project. Airtable provides a range of pre-defined views, such as grids, calendars, and kanban boards, that you can use to organize and display your data. You can also create custom views if you need to display your data in a specific way.

  5. Share your base with your team and give them the permissions they need to access and update the data. Airtable allows you to control who has access to your base and what actions they can perform on the data. This makes it easy to collaborate with your team and ensure that everyone has the information they need to work on the project.

  6. Use Airtable's collaboration features to communicate and coordinate with your team. Airtable allows you to leave comments on records, assign tasks to team members, and track the progress of your project using the data in your base.

By using Airtable as a project management tool, you can easily manage and organize your project's data, collaborate with your team, and track the progress of your project. Give it a try and see how it can help your team be more productive and efficient.

Airtable can be critical in agile project management rituals. Here are a few examples of how you can use Airtable in your agile workflow:

  • Sprint planning: Airtable's kanboard views make it easy to create and manage your sprint backlog. You can add records for each user story, assign them to team members, and track their progress as you work through the sprint.
  • Daily stand-ups: Airtable's collaboration features allow team members to update the status of their tasks and leave comments on records, which can be useful for coordinating during daily stand-up meetings. You can use Airtable's calendar views to see the progress of each team member's tasks over time.
  • Retrospectives: Airtable's flexibility allows you to create custom tables and views to track feedback and action items from retrospectives. You can add records for each feedback item and assign action items to team members, and use views to track the progress of each action item.
  • Release planning: Airtable's kanban views make it easy to visualize the flow of your work and see what's coming up in the next release. You can add records for each user story, move them through the different stages of your release process, and use views to see the overall progress of your release.

Overall, Airtable can be a valuable tool for agile project management, providing a flexible and user-friendly platform for tracking and coordinating your work. Whether you're using it for sprint planning, daily stand-ups, retrospectives, or release planning, Airtable can help your team be more productive and efficient.

· One min read
Dan Ferguson

Airtable templates are pre-built bases that you can use as a starting point for your own data. They include pre-defined tables, views, and records, as well as examples of how to use different features in Airtable.

Here are a few examples of how you could use Airtable templates:

  • Project management: The Project Management template includes tables for tracking tasks, project milestones, and team members, as well as a dashboard view that shows an overview of the project's progress. You can use this template as a starting point for managing your own projects.
  • Event planning: The Event Planning template includes tables for tracking attendees, vendors, and schedules, as well as a calendar view that shows the events and their associated details. You can use this template to plan and manage your own events.
  • Recipe collection: The Recipe Collection template includes tables for storing recipes, ingredients, and meal plans, as well as a gallery view that shows the recipes in a visually appealing way. You can use this template to organize your own recipe collection.

To use an Airtable template, you can visit the Templates page in your Airtable account and click on the template you want to use. This will create a new base with the pre-defined tables, views, and records, which you can then customize and use for your own purposes.

· 2 min read
Dan Ferguson

If you want to upload files to your Airtable account using the API, there are a few steps you need to follow. The Airtable API allows you to create, read, update, and delete records in your Airtable bases, including files. In this article, we will explain how to upload files to Airtable using the API.

First, you will need to sign up for an Airtable account and create a base that includes a file attachment field. This field will be used to store the files you want to upload through the API. Once you have created your base and added the file attachment field, you will need to generate an API key for your Airtable account. You can do this by going to the Airtable API dashboard and clicking on the "Generate API key" button.

Next, you will need to use the Airtable API endpoint for creating records to upload your files. The API endpoint for creating records is https://api.airtable.com/v0/base_id/table_name, where base_id is the ID of your Airtable base and table_name is the name of the table in your base where you want to upload the files.

To upload a file through the API, you will need to make a POST request to the API endpoint and include the file attachment field in the request body. The file attachment field should be in the form of a JSON object, with the file name, content type, and URL of the file you want to upload. You can get the URL of the file by using the Airtable API endpoint for uploading files, which is https://api.airtable.com/v0/base_id/table_name/file_id.

Once you have made the POST request to the API endpoint, the file will be uploaded to your Airtable base and attached to the record you specified in the request body. You can then use the Airtable API to read, update, or delete the record and its attached file, as needed.

In conclusion, uploading files through the Airtable API is a straightforward process that allows you to manage your files and records in an organized and efficient way. By following the steps outlined in this article, you can easily upload files to your Airtable account using the API.

· 2 min read
Dan Ferguson

Airtable is a cloud-based platform that combines the features of a database, a spreadsheet, and a project management tool. It allows users to create custom fields and views for their data, and to easily import, export, and share data between different systems. Airtable is known for its flexibility and customization, which makes it ideal for managing complex or multi-faceted content, such as product catalogs, project management, or event planning. It also has a robust API and integrations with other popular tools and services, which makes it a powerful and versatile platform for managing and organizing data.

Common use cases​

  • Project management: Airtable's customization and collaboration features make it a popular tool for managing projects and teams. Users can create custom fields and views to track project tasks, deadlines, and progress, and can share data and collaborate with team members in real-time.
  • Event planning: Airtable's flexibility and integration with other tools and services make it a popular choice for organizing and managing events. Users can create custom fields and views to track event details, attendees, and logistics, and can easily import and export data to and from other systems, such as Google Calendar or Mailchimp.
  • Inventory management: Airtable's database and spreadsheet features make it a powerful tool for managing inventory and stock levels. Users can create custom fields and views to track product details, quantities, and locations, and can easily import and export data to and from other systems, such as accounting or e-commerce platforms.
  • Content management: Airtable's customization and collaboration features make it a popular choice for managing and organizing content, such as blog posts, articles, or media assets. Users can create custom fields and views to track content details, status, and authors, and can easily share and collaborate on content with team members.
  • Data analysis and visualization: Airtable's integration with other tools and services, such as Google Sheets and Slack, make it a powerful platform for analyzing and visualizing data. Users can import data from other systems, create custom views and charts, and share data and insights with team members and stakeholders.

These are just a few examples of how Airtable can be used. It is a versatile platform that can be adapted to a wide range of purposes and use cases.