I wrote a post a few weeks back covering the datetime fields in Airtable but wanted to go a step further and show you how you can use the fields along with formulas to really bring your table to life and view dates and time in a more meaningful way. Unit Specifier Before diving into…
I had been searching for a long time for the perfect personal budget app. I had used Mint but it wasn’t as flexible as I needed it to be, and Excel and Google Sheets lacked user friendliness and advanced features. Luckily, Airtable is a perfect tool to do everything I need. Clone my personal budget…
The rollup field in Airtable is an excellent way to summarize data from a linked table in the same base. As the name implies, any time you want to roll data up to a larger “bucket”, the rollup field will be useful. The Budget Example I created this Budget template base that you can use…
Dates are a funny thing in programming because they can have so many different formats and then timezones add an extra degree of complexity. Dates in Airtable are no different. If a record displays a date and time of 4:39 on 11/2/23, some people will think that is 4 o’clock in the morning on February…
There are a lot of bookmarking and web clipping extensions but I found Airtable’s to be the best. It offers great flexibility and allows me to control which information I save from a webpage. Set Up Your Base for Web Clipper First you need to create the fields you want to map to or fill…
The first Base I ever created for Airtable was to help me manage and plan content and is still something I use almost daily. I even planned this article in my Content base. I use this for my blog posts, LinkedIn updates, podcast episodes, videos, newsletter, and static web pages. Below is the configuration that…
The kanban view in Airtable provides a visual way to update records in a table. The view is similar to Trello and allows you to drag cards to order them and move them between stacks. This view is commonly used to keep track of a status of a project or task but there are other…
Airtable has many uses and one of the most valuable ones I have used it for was to aid in my job search. Job searches take a lot of work and there is a plethora of data to manage including information about job postings, past jobs, people involved etc. Airtable is an ideal way to…