Application Tracking System App

Introduction

This application will need you to connect to your instance of Postgres, but once done, you will be able to manage the entire lifecycle of applicants in your hiring pipeline. We've also added Google Calendar API calls so you can schedule interviews directly from this application.

Steps to fork the App

  • Firstly, you should have an Appsmith account; if not, sign-up here (it's free)!
  • Now, open the Meeting Scheduler application template by clicking here. You'll find a fork button on the top-right of the application.
  • Click the fork button and fork it to you're organisation. Now you should see the application under your organisation.
Forking ATS App
  • The current application is connected to a mock database, you can extend this by connecting with your own Postgres instance.
  • Lastly, you can make the app public and deploy it by clicking on the deploy button on the top-right.

Setup your own DB

You can setup the ATS app with your own Postgres DB, follow the below steps:

  • Click on the `+` icon next to the DB Queries and choose Postgres database. You can learn about connecting databases to Appsmith here.
  • Enter the details of the Postgres database you want to connect with. 
  • Test the data source to see if the connection is successful or not by clicking on the `Test` button.
  • After the connection is established change the data source by clicking on the top-right dropdown and choosing your own.
  • After your DB is connected, open the create_job_applications_table DB Query and click run. This will create a new table on your Postgres database with the fields that are configured with the existing DB queries. 
  • Similar to the previous set, run the create_candidate_feedback DB query, this will create a table that will store feedback of the applicants.
  • Awesome, you now have the tables that are required to run all the existing DB queries, now we’ll have to change the datasource from Mock database to the newly created data source. For this, we’ll have to go through all the existing queries and change the data source.
  • You should see a dropdown on top right of each query, this is where you'll have to change the data source. Below is the GIF showing the same.

Awesome, with this you should be able to run the ATS application on your own organisation with your own database. You can also extend the app by creating new fields in the database and updating the existing DB Queries with them.