For the final project in this series, I tackled Formula Fields. Up until now, everything I've entered into Airtable has been static — I type it in, and it stays there. I wanted to see how the database could do the maths for me.
The Petty Grievance List lesson had me use a Single select field type for a status with only two options - Active and Forgotten. Sometimes, a simple checkbox would be enough. That's what I used to build a "Job Hunt Tracker" in today's lesson.
In the last experiment, I learned how to sort records of my trips through time into chronological order. Sorting in order or grouping by type is useful for addressing clutter, but sometimes you just need to hide data without actually deleting it. To do this, I built a "Petty Grievance List."
As I work through the list of 10 Easy-Peasy Airtable Experiments, I realise that they really are easy. It takes longer to write about each experiment than it does to do it. Nevertheless, I will persist! In this lesson, I made a "Time Travel Log."
For the 6th of 10 Easy-Peasy Airtable Experiments I shifted from workflow management to basic financial tracking. I wanted to see how Airtable handles numbers and calculations compared to Excel. To test this, I set up a "Secret Expenses" base to track the costs of a double life.
Project 4, the Sandwich Architect was about moving away from static lists. While grouping is useful for sorting data, I wanted to see how Airtable handles workflows. To test this, I set up a "Henchman Roster" to track the status of evil-minded team members.
After cataloguing excuses and mapping the stars, I started to get a bit peckish. For my fourth project, I headed to the kitchen to make a sandwich.
In my last blog post, I catalogued some of Gemini's best excuses. Now, for my third project, I'm heading into space! It's time to leave Earth and build the Galactic Guide.
Last time in Airtable, I learned about field types and views while stocking a zombie bunker. This next project will introduce me to long text, ratings and data buckets. Let's dive into the Excuse Tracker!
I mentioned in my last post that to really learn Airtable, I needed to step away from the safe, "English School" data the AI suggested and try something a little more exciting. So, I deleted the "Learning Playground" and decided to build the Zombie Apocalypse Survival Kit.
Today marks my first expedition into Airtable, "a cloud-based platform that blends the familiar, user-friendly interface of a spreadsheet with the powerful, structured functionality of a relational database". As with most websites like this, it was keen to give me a tutorial and a customized project to start with.
