How I use Airtable to search for an internship

This post was originally published on Medium.

I am a french Computer Science student at Polytech Nanteshttp://web.polytech.univ-nantes.fr/, the graduate school of engineering of the University of Nantes, in France. Currently in my 4th year of studies, I have a strong passion for web development, data and AI. This summer I have the opportunity to do a 3-month internship abroad. Therefore I am currently researching companies which might be looking for innovative interns so as to apply. This entails filling applications forms, writing emails and cover letters.

But how to stay organized? This last few weeks I have been using Trello but I was considering using a spreadsheet instead to keep track of applications I have been sending and companies I am in touch with.

And some days ago, wandering on Product Hunt, I discovered the truly amazing Airtable. I decided to give it a try and build my “Internships research” database with it.

Airtable

So what is Airtable? No-one can explain the service better than a team of young film makers 📹. Additional features are presented on the Airtable website too.

Airtable presentation video

To keep it short, Airtable is a mix between a spreadsheet and a database, with a very clean UI.


Ok, so now, let’s imagine you are a very talented Computer Science student looking for a fabulous internship with Google, Spotify, OpenAI or of course Airtable. You want to keep track of your research progress.

Companies

We will start by creating a table to store companies, organizations and institutes we want to reach. What do we need to know? Let’s create these columns:

  • Name (Primary field)
  • Logo (Attachment field)
  • Type (Single select field : Company / University)
  • Website (URL field)
  • Notes (Long text field)
Table to list companies in Airtable
Example dataset of companies

People

It could also be convenient to keep track of people we speak to, whether they are contacts from the above mentioned companies or others. We will just add another table called “People”.

  • Name (Primary field)
  • Company (Link to another record field : the Companies table)
  • Email (Single line text field)
  • Twitter (Single line text field)
  • Notes (Long text field)
Table to people in Airtable
People we might reach. Don’t do this at home kids 😄

You may have noticed that, when adding the Company column, a People column appeared in the Company table because of the bidirectional relation between the two.

Applications

It’s time to list some applications. Taking into account that there could be multiple internship offers from one company, it is better to create a new table “Applications”. Actually we are applying relational database relationship here (Many to One), but with a nice UX.

  • Name (Primary field)
  • Company (Link to another record field : the Companies table)
  • Interest (Single select field : ⭐, ⭐⭐ or ⭐⭐⭐)
  • Documents needed (Multiple select field)
  • URL of the offer if any (URL field)
  • Deadline if any (Date field)
  • Contacts (Link to another record field : the People table)
Table to applications in Airtable
A few applications.
Of course all are ⭐⭐⭐!

Not bad ! We can easily add applications and link them to the companies and the people that could help us.

Wouldn’t it be better if we could split the table between already-submitted applications and the rest? It can’t be easier than this: just add a Single select field or a checkbox Status and use it to group your data.

Single select config in Airtable Table to applications (grouped) in Airtable
Use a Single select to group applications by status.

Given this classification, let’s look for a new way to view our data. Here, the Kaban view could really help us see where we are in the process.

Kanban view in Airtable
A Kaban view. A Trello lover is not disoriented 👌

When you click on a card/row, you always open a popup with all the data of the concerning application and history of changes.

You can even leave a comment, let’s say, for a friend helping you.

Card view in Airtable
The item view

Speaking of views, let’s try to add a form. It could save us some time adding a new application. Instead of adding new rows, simply keep the form open in a tab of your browser. There is also other useful views like Calendar and Gallery.

Form view in Airtable
The form view
Calendar view in Airtable
The calendar view

Airtable has also very powerful field types like Lookup, Count, Formula or Rollup. Let’s go back to the Companies table to play with some of them.

First, add a Count column, counting the number of applications by company. Then, add a Rollup field on the People’s Twitter column with the aggregation function ARRAYUNIQUE . We have just listed all the Twitter accounts we have from a company 💪

Rollup config in Airtable Table to companies (with rollup column) in Airtable
The new rollup field in the companies table

Nice! Pretty neat isn’t it? Here’s the full base. Just copy it on your Airtable account to start managing your internship search too!

The new rollup field in the companies table

There is still a lot of features to explore. Their iOS and macOS apps are great. All is web based and should be working well just about everywhere (I have read somewhere they use React under the hood ❤).

Whether you are on your desktop or mobile, you can always add and edit your documents. But if you want a full spreadsheet view, you’d better use the desktop version. There is also a full REST API which is a very interesting feature. You can actually use Airtable as a full relational database in the cloud. They even have a NodeJS client. I am definitely going to build something with it.

I am really happy to have discovered this service. It really fills a need and I am sure there are many times when we’d better use Airtable than a classic spreadsheet for our data. Just give it a try 😃