Approved (6.10.20)
Revision note: Tense correction
  • A few examples of what you can do with Airtable that's not possible with a spreadsheet:
  • A few examples of what you can do with Airtable that are not possible with a spreadsheet:
  • - Define constraints and validation for data (e.g., this column is a date field, or URL)
  • - Lookups and functions that span different tables (e.g., if you have a "product category" table, with each category tagged with a given employee as "product owner"; you can set up a second "product SKU" table; when you tag the product category to the SKU, then the SKU table can pull in the owner and other attributes of the product category; and the product category table can display "rollups" like total sales of all SKUs in that category)
  • - Maintain auto-calculated fields (autonumber for a unique ID for each record; created and modified data that is auto-updated, etc.)
  • - Set up "views" for different purposes people to have their own custom workspace. For example, in a project management tracker, you could have a "month of May" view, an "operations" vs. "product" view, etc., for different purposes. You can also set custom permissions for each kind of views (personal views vs. locked views vs. collaborative views)
  • - You can share a table or view, publicly or with password protection
  • - You can also create Kanban boards and Forms -- so that you can visually handle records as "cards" or gather information or conduct surveys in a pinch (though these aren't the primary intended use case for Airtable, so it won't be as powerful as a specialized Kanban tracker or survey tool)
  • - There is also an extensive audit log of every change made to a table and even specific recoreds
  • *Blocks add a whole dimension of functionality*
  • ---- The Page Designer Block allows you to lay out various data fields on a PDF sheet and produce beautiful documents, such as reports, invoices, etc.
  • ---- The Maps Block allows you to map out an address column, so that you can see where all your customers or warehouses are located
  • ---- The Org Chart block allows you to instantly generate your company's org chart
  • ---- The Dedupe Block allows you to compare and merge duplicate or similar records
  • ---- The SendGrid Block allows you to programatically send emails to contacts in a table
  • ---- The Gantt Chart table allows you to visualize your project timeline
  • ---- The Scripting Block allows you to write custom code on top of Airtable as well
maguay's avatar
@maguay approved
a year ago
Approved (6. 4.20)
Revision note: First draft
  • A few examples of what you can do with Airtable that's not possible with a spreadsheet:
  • - Define constraints and validation for data (e.g., this column is a date field, or URL)
  • - Lookups and functions that span different tables (e.g., if you have a "product category" table, with each category tagged with a given employee as "product owner"; you can set up a second "product SKU" table; when you tag the product category to the SKU, then the SKU table can pull in the owner and other attributes of the product category; and the product category table can display "rollups" like total sales of all SKUs in that category)
  • - Maintain auto-calculated fields (autonumber for a unique ID for each record; created and modified data that is auto-updated, etc.)
  • - Set up "views" for different purposes people to have their own custom workspace. For example, in a project management tracker, you could have a "month of May" view, an "operations" vs. "product" view, etc., for different purposes. You can also set custom permissions for each kind of views (personal views vs. locked views vs. collaborative views)
  • - You can share a table or view, publicly or with password protection
  • - You can also create Kanban boards and Forms -- so that you can visually handle records as "cards" or gather information or conduct surveys in a pinch (though these aren't the primary intended use case for Airtable, so it won't be as powerful as a specialized Kanban tracker or survey tool)
  • - There is also an extensive audit log of every change made to a table and even specific recoreds
  • *Blocks add a whole dimension of functionality*
  • ---- The Page Designer Block allows you to lay out various data fields on a PDF sheet and produce beautiful documents, such as reports, invoices, etc.
  • ---- The Maps Block allows you to map out an address column, so that you can see where all your customers or warehouses are located
  • ---- The Org Chart block allows you to instantly generate your company's org chart
  • ---- The Dedupe Block allows you to compare and merge duplicate or similar records
  • ---- The SendGrid Block allows you to programatically send emails to contacts in a table
  • ---- The Gantt Chart table allows you to visualize your project timeline
  • ---- The Scripting Block allows you to write custom code on top of Airtable as well
awwstn's avatar
@awwstn

approved - this is great! maybe worth defining some of the core features (e.g. Blocks) in a future revision, but I love how this is written from the perspective of what a user can do, not simply describing what a feature is.

a year ago