Thanks to ClicAbsence, report an absence in one clic

This application have been set up either for SME, large corporations or business school. From now it's not necessary to call or senf an email to report an absence, just on the button to report it ! Its objective is twofold: It enables to save times and to report easyly absence. Each time an employee or a parent clicks on the button, he or her name will be saved in an excel sheet with the date and the time of absence.

To set up this app it is easy : just link it to an Applet (in this case Google Sheet) to your website and the do the rest. ,

Here are the steps to follow :

Preliminary steps

First of all create a google account and a ClicABsence account. Register here Google or on ClicAbsence and follow instructions.

Then, tap webhooks on the search bar at the right side on the top of the page and click on webhooks.

You can activate this applet by clicking connect. Then, click on settings (on top on the right) . You should find a page as bellow:

You can identify and collect your API's key that should be integrated withind the website's code.

First step: setup "if+this"

CLick on "My Applets" ont top on left and click on "New Applet" on top on right.

Clique now on "If This" and tap Webhooks in the search bar and select Webhooks. Webhooks is then our first interaction platform for our Applet.

Click on “Receive a web request” Then give a name to your "event" (here report_absence). The name of the event must also appear in the website code (after the API key)

Once you have chosen the name of your event you can click on "Create trigger" to proceed to the next step

Step 2 : setup "...then+that"

Now click on "+ that" and select the second interaction platform you want to use (here Google Sheets).

Then click Connect

We choose the "add row to spreadsheet" action in order to add a new line to each new absence and therefore to see all the absentees.

Now you must configure your excel workbook. You must choose the "spreedsheet name" i.e. the name given to your excel page which will group the absences (here it is called ClicAbsence absences_reported) The "formatted row" box allows you to choose the information contained in each line: here you will have first the day, the pattern and the values 1 then 2 then 3. information for coding : it will be necessary to create variables such as "occured at" refers to the day of the click and "value1" refers to the name of the absent person Then, the third box links to Webhooks.

Step 3: closing the applet creation:

Finally, click on "create action" If all the previous steps have been created correctly, you get this:

At this point, the applet is created. Just connect the applet to a button on our website and it works. (see details in the following steps)

Step 4 : The Website

Several options are possible: create a new website specially dedicated to reporting absences or modify a company / school website. In both cases, the principle will be the same: the goal is to create a "report an absence" button linked to the Applet. To do this, you must code a button according to the following instructions: help-bouton. Once the button has been created using these instructions, the API key and the name of the event (see preliminary) must be integrated with JSON. The example below shows how to link ClicAbsence to the website by the button using js :

Now that your website is linked to the Applet, you can list all the absences of your students or employees. Feel free to share this innovation with them!