What is it ?

I created this database because I will soon have to apply for internships and in order to do it best I should be well organized. For my previous internship applications I wasn't very organized so it was a bit messy. I sent the same email and the same cover letter to almost every company, just changing the name of the person because I didn't had much time. Thus, it was not very personnalised. Moreover Including in the database the email adress, the name of the person to which it is directed and some of the companies value could then be used to automatically personalize the email and cover letter.

How does it work ?

The database is based on Google's FireBase Realtime DataBase technology. It will alow me to enter different variables such as: the name of the company, the name of the person who I am sending the mail to, his or hers email adress, the title of the position, and values of the company or skills that are needed for the position. It could also be efficient to write the date of the contact to remember which internships I have applied to and when. The database will be updated each time I submit a company with the form.

Documentation

Let's get to work!

  • First we need to go to Firebase create an account if you do not have one yet and then create a new project
  • Once the database is created, you need to connect the form to the database in order to create and store the applications. The next step will thus be to configure and initialize the project. It is really simple, you just have to follow the steps given by the website. First you need to copy the given code in the html document. It will look as follow:
  • Next Step is to add a few lines of code to get the reference of the data base
  • Finally, you just have to open the html file in the internet browser and you will see the database and what it holds. Since it is a realtime database it will upadate each time you change anything. It should look like that but with different names.

    • The Form

    To create the form, you can use html and css.Below, you can see the code used to create a very basic form.
    First the HTML code: first you need to use a "form-box" class type. With label, you can create the legend of the box and with input you allow the user to write in the box. It is important to mention the type of input that the user can add.

    Then we have the CSS code.

    Finally it should look like this:

    via GIPHY

  • To go further, as I said before, we could connect the database to a word processing software and a mailing system that could automatically fill the cover letter and the email and send it with just one button click.