Gallery views display data in individual cards (which can be customised): I particularly like this feature as it encourages team members to collaborate around your data. The expanded view also shows a history of changes to the record and allows social interaction in respect of the record - using the typical mentioning to send comments about the data to other users. Within views you can determine which fields are displayed - and records can be 'Expanded' into a popup form for editing (you can also edit within the table for Grid views). You can create as many views as you like from each table and they are shared between all users. In addition to the Grid view above (in this case shown Grouped) there are other types of views available: Suffice it to say that there are fields types to meet most requirements and comprehensive summary and formula features to extrapolate from your raw data. There are also URL fields, checkboxes, single select and multi select fields, etc.
#Airtable for mac plus#
There are a wide range of field types available including all the basics plus some which are concerned with the Relationships in your data such as Links to other Tables, Lookups from linked tables and Rollups which calculate values based upon linked records in other tables. In many case, I find this field is best configured as a Formula field - in this case showing the First Name, Last name and Employee Number fields:Ĭlicking Customize takes you to the field editor Each table in Airtable has Primary field - this is the leftmost field in the table and represents the value that would be displayed in Links to other tables (more later) - although it actually contains a unique key for the record it is typically set up to display more useful information (either as an input field or a formula combining values from others). Note how similar to a spreadsheet this presentation of data is. In the example shown above, I have a 'View' called Main View which is displaying all my employees grouped by department and job. HR applications present a range of challenges which are common to a wide range of business scenarios and offer potential to explore how Airtable handles the relationships between information such as Employees, Jobs and Departments etc. These are an excellent way to familiarise yourself with Airtable even if there isn't one which will meet your needs precisely.įor this review, we are going to use a base I have ben working with called KasPer Lite. New 'bases' can be created empty, created by loading data from a spreadsheet - or from a number of templates of which there are quite a few covering a range of needs. When you open Airtable you will see a screen like the one above, where your databases (bases in Airtable parlance) are displayed, and from where you can create new ones. I am going to use the example of a simple HR app…
In this review we will be measuring the product against that objective and getting an understanding of who the service is for and how well it meets their needs, both now and into the future as their experience grows.
#Airtable for mac software#
In this article I am going to look at the core Airtable app - and in a subsequent articles I am going to look into how the basic app's capabilities can be extended with Zapier and more advanced formulae.Īirtable is a cloud database aimed at business users (rather than database specialists) - the company's stated mission is to "democratise software creation by enabling anyone to build the tools that meet their needs". Airtable offers a revolutionary new approach to relational databases - designed to appeal to business users accustomed to working with spreadsheets.
0 kommentar(er)
