How to build a job board with Airtable

How to build a job board with Airtable

Tags
How to
Airtable
Published
Thanks to the no-code revolution, creating a job board with hundreds or even thousands of listings has become dead simple. So simple in fact, job boards have been coined the the "hello world" of no-code.
 
In this tutorial, I'm going to show you step by step on how to create your own seamless job board with search, filters and automations. By the end of this tutorial, you'll be able to:
  • Create and manage listings
  • Receive job applications
  • Receive notification when someone applies
 
Here's a demo of the final product 👀
 

How much does it cost?

Airtable has a free tier for up to 1,200 records per base and Pory is free or $18/mo when you're ready to embed or connect your own domain.
 

Step 1: Using Airtable

For our job board, we'll be using a tool called Airtable for managing our listings. Airtable is a visual database with the familiarity of a spreadsheet, which makes it perfect for building apps!
 
New to Airtable? No worries, create a free account first.
 
In this guide, we'll be using the Airtable base below. You can follow along with your own Airtable base, or copy this example to get started.
 
 

Step 2: Creating the job board

Now that we have our jobs ready to go, we'll be creating our listing on a platform called Pory. Pory is a platform for creating applications on top of Airtable using drag and drop blocks. It also provides your users with accounts and the ability to edit information.
 
New to Pory? Sign up for a 14 day free trial.
 
In your apps page, select Create App and choose a layout. We went with the job board layout for the demo (you can always change it in the editor later).
notion image
 
You'll be then taken to the editor where you can do things like adding new sections, pages and integrations.
notion image
 
Let’s connect the listing to Airtable by hovering over the section. You should see an edit listing button pop up.
notion image
 
If you're new to Pory, you'll be asked to enter your API key. This is used to authorize Pory to access your Airtable base. Once this is complete, you can then select which Airtable base to use.
We recommend copying our example base if you're unfamiliar with Airtable.
 

Connect your Airtable data

  1. Select Connect Airtable tab
  1. Select your Airtable base
  1. Select your table
notion image
 

Selecting an Airtable view

  1. Switch to View Settings tab
  1. Select Airtable view
notion image
 

Creating filters

  1. Switch to Filter settings tab
  1. Select fields that use either a single select or multiple select field types to automatically create filters
notion image
 

Displaying data

  1. Select Save to switch to Card View
  1. Select which fields to display. I've gone ahead and set the option Title to our Position field, Subtitle to Company, Call to Action URL to Listing URL and Image to Logo.
notion image
 
You can also change the type of detail view to display when a record is selected by switching to the Detailed View tab. E,g,. to a link, modal or page. I've kept the view as Side by side which opens a right pane when the record is selected.
notion image
 

Step 3: Receiving job applications

The Airtable base includes an Applicants table with a form view used for collecting submissions. This is the same form that is opened when you click on the Apply button on a job listing. See how the shared form link is stored in the Jobs table and pre-filled with the position.
 
https://airtable.com/shrQhH3jYgKS6YdvG?prefill_Position=Full-stack+Engineer
 
The key is creating a relationship between the Jobs and applicants table to avoid duplicating data between the tables. To achieve this, the field type Link to another record is used. Now when an applicant applies for a position, the record from the Jobs table is stored as a reference.
 
See it in action by applying for a position :)
 
 

Step 4: Publishing your site!

Congrats -  you should now have a working job board! But before we hit the publish button, don't forget to edit the placeholders and upload your site assets (logo, favicon, colors). Also have a play around with the different blocks.
 
3, 2, 1 publish! 🚀
 
Give your job board a free .pory.app domain or upgrade your account to either embed your job board into an existing site, create a subdomain i.e. https://careers.company.com or to a domain i.e. https://company.com.
 

Step 6 (optional): Automating tasks

Once you're happy with everything, it's time to set up some automations! Let's create an Airtable automation to receive a notification when someone applies for a job so we don't have to keep checking for updates.
 
You can do this by clicking on the Automations buttons inside the Applicants table in Airtable.
notion image
Luckily for us, there is already a Send a Slack Message recipe we can use. Fill out the form, connect it to your Slack and start getting notifications when someone applies for a job!
 
notion image
 
Now when you apply for a job, you should see a message in Slack. Want to see it in action? Join our slack community and see for yourself by joining the #slack-automations channel.
 
notion image
 
Another automation idea could be sending out updates to applicants based on the application's status. For example, an email can be sent when the status of the job changes from pending to in review or even a thank you message when the application is closed.
 
That's it! Let us know how you go and reach out if you have any questions. Hope you enjoyed the tutorial! ✨