Description
In this course, you will :
- Create an interactive and public database that allows them to run their own small business.
- Use sorting, filters, grouping, and formulas to analyse their data.
- Feel at ease using Airtable from both a desktop and a mobile device.
Syllabus :
1. Getting Started in Airtable
- Creating your Airtable account
- How to add data to your new base
- Importing spreadsheets and linking records
- Going deeper into linking records
- Basic data types: single select and date fields
- Creating a table to run a business: Transaction Tracking
2. Data types and formulas
- The Count function: counting linked records
- Look up records in other tables
- Date and time functions
- Calculating Revenue using Airtable Formulas
- The almighty IF statement
- Stringing your data together with functions
3. Sorting, Filtering, and Grouping your data: Making sense of it all
- Sorting through your data
- Filters, Filters, Filters
- Grouping your data
- Putting it all together - sort, filter, group
- Quickly summarize your data
4. Mastery in Views
- Publish a public form view - interacting with your customers
- Managing your time with Calendar View
- Visualizing with the Gallery View
- Share your data through Public Views
- Going Mobile with iPhone app