Airtable - Preparing for the Zombie Apocalypse
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.
Zombie Apocalypse Survival Kit
Ditching the office supplies
The problem with most tutorials is that they want you to build an "Office Inventory" or a "Content Calendar." Boring! I learn best when I'm hands-on and creating something fun.
I asked Gemini to give me 10 easy-peasy Airtable experiments I could do in less than 20 minutes each, and the first one was to build an inventory of essentials for when the undead rise.
The setup
Starting from a blank base (which is far less intimidating than a pre-filled template), I decided on four columns, each with a unique field type:
- Survival Item (Single Line Text): Chainsaw, crossbow, crowbar, baked beans, and first-aid kit.
- In Stock? (Checkbox): Crucial for knowing if I need to make a supply run.
- Category (Single Select): Color-coded tags. Weapons get a nice dangerous red tag.
- Photo (Attachment): I dragged and dropped images of crossbows and baked beans directly into the cells.
The aha! moment
Up until this point, Airtable had looked like a regular spreadsheet, no different from Excel. It was functional, but still looked like... work.
Then I noticed you can switch from Grid view to Gallery. Instantly, my rows of text transformed into a visual card catalog. It didn't look like a database anymore; it looked like a finished app. I could see my gear, check my stock status, and admire my (theoretical) chainsaw collection.
The verdict
It took me about 10 minutes. It was silly, wild, and completely unprofessional - but I now understand how to manipulate field types and views, and it was more memorable than managing a fake "Customer List."
My next challenge will be the "Why I'm Late" Excuse Database, in which I'll learn about rating fields. Can you think of a 5-star excuse?