![]() The Dedupe Block allows you to compare and merge duplicate or similar records The Org Chart block allows you to instantly generate your company's org chart 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 Page Designer Block allows you to lay out various data fields on a PDF sheet and produce beautiful documents, such as reports, invoices, etc. There is also an extensive audit log of every change made to a table and even specific recoredsīlocks add a whole dimension of functionality 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) You can share a table or view, publicly or with password protection You can also set custom permissions for each kind of views (personal views vs. "product" view, etc., for different purposes. For example, in a project management tracker, you could have a "month of May" view, an "operations" vs. Set up "views" for different purposes people to have their own custom workspace. Maintain auto-calculated fields (autonumber for a unique ID for each record created and modified data that is auto-updated, etc.) 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) Define constraints and validation for data (e.g., this column is a date field, or URL) Extensive modeling (e.g., financial models) or for power users of formulasĪ few examples of what you can do with Airtable that are not possible with a spreadsheet:.An internal wiki (it doesn't work well for notes, visual embeds, etc.).People often use Airtable to build lightweight internal tools and apps with a table-like interface: A visual (and colorful) UI that allows you to intuitively keep up on what's going on in a given database.Need for integrations with 3rd party tools. ![]() Lots of real-time collaboration on the data (particularly when different people need different cuts on the data).Maintaining data integrity in a way that spreadsheets aren't cut out for. ![]() Finally, Airtable has a number of native integrations, and a fairly powerful API.Īirtable can be used as an individual tool, but it's most powerful when you have some or all of the following needs: Additionally, a set of add-on "plugins" to Airtable, called Apps, allow you to deploy mini-apps on top of a database. Airtable is a relational database with a spreadsheet UI this means that it has the ease of use and navigation of an Excel or Google spreadsheet, but powerful features of a relational DB (data validation, links and relationships across data tables). ![]()
0 Comments
Leave a Reply. |