Published December 31, 2019

Bolt Leave Tracker and Limiter

Build an automated system to maintain the present to absent employee ratio per day in your company!

BeginnerFull instructions provided4 hours490

Things used in this project

Hardware components

Arduino UNO

Adafruit Standard LCD - 16x2 White on Blue

DFRobot I2C 16x2 Arduino LCD Display Module

Buzzer

Resistor 100 ohm

Jumper wires (generic)

Breadware Inc Mega-B Development Kit

Software apps and online services

Bolt IoT Bolt Cloud

Arduino IDE

Story

Hardware Connections

1. Connect the negative end of the buzzer to GND of Arduino in series with 100 ohm resistor. Connect the other end of buzzer to pin 4 of Arduino.

2. Connect Rx and Tx of Bolt with the Tx and Rx of Arduino respectively, also connect the 5V pin of Bolt to 5V pin of Arduino and GND of Bolt to GND of Arduino.

3. Connect GND, VCC, SCL and SDA pins of I2C module with GND, 5V, A5 and A4 pins of Arduino respectively.

4. Connect I2C module with the 16x2 LCD module as shown in schematics.

5. Check all the connections properly before proceeding.

Note: Please refertothe schematics foranyfurtherreference.

1 / 7

Building up the Logic on Integromat

1. Create an account on Integromat using the link.

2. After setting up the account, create a new scenario using the 'Create a new scenario' button located on the top right corner in dashboard. For any help follow this link.

3. In the services choose Slack, Router, Google Sheets, Bolt, Tools (sleep).

4. Now using these services, build the required logic flow as shown in figure. For any help follow this link.

Note: There are two separate scenarios(Leavelimiterlogicandresetlogic).

1 / 2

5. After building the logic, enter the credentials for the services being used, i.e., Bolt device ID and the API key for the Bolt IoT service, Workspace login for Slack and Email login for Google sheets (from their respective websites).

For Leave Limiter Scenario:

6. Enter the settings for Slack service as shown below:

7. Configure the Google sheet as shown below:

For leave:

1 / 2

For work from home:

1 / 2

8. Apply the filter to the router's branch as shown below:

For leave:

For work from home:

9. Credentials for Bolt service:

Obtain the Bolt device ID and API key from https://cloud.boltiot.com/, as shown below:

1 / 2

Create a new connection using the above credentials and enter the details in other fields of the Bolt service as show in fig:

For Leave/WFH limiter logic:

10. Delay (sleep) settings:

11. Finally, schedule the whole scenario as shown below:

For Reset Scenario:

12. Configure the Tools to obtain the current time:

13. Configure the Bolt service as shown below:

14. Apply the filter for reset:

15. Schedule the scenario similar to that in step 11.

Workflow

1. When a message pops up on the 'Leave Channel' of Slack, a logic is designed on Integromat to read such messages.

2. Then the messages are filtered on the basis of whether the employee has applied for 'leave' or 'work from home'.

3. The details of the message (Date and Time, Name, Message) are stored in separate google sheets for leave and work from home for future records.

4. The Bolt is then activated to send the name of the employee who applied for leave/wfh.

5. The Arduino then receives the name of employees and displays it on LCD to notify others in the office.

6. A buzzer is used to notify in case more than 50% of the employees have applied for leave/wfh. Thereafter no more leaves are granted.

7. To prevent overlapping of the messages received by Arduino some delay is used.

8. For proper functioning of the system a reset mechanism is used which resets the whole system every evening after 6 pm.

And so, this is it! Hope you liked our project.

Code

Leave limiter Arduino

#include <Wire.h> 
#include <LiquidCrystal_I2C.h>
#include <SoftwareSerial.h>

SoftwareSerial bolt(10, 11);
LiquidCrystal_I2C lcd(0x3F,16,2);

int count = 0;
int buzzer = 4;

void setup()
{
  pinMode(buzzer,OUTPUT);
  digitalWrite(buzzer,LOW);
  Serial.begin(9600);
  bolt.begin(9600);
  lcd.init();
  lcd.backlight();
  lcd.setCursor(1,0);
  lcd.print("Leave Buddy");
}

void loop() {
  String Name = "";
  while (bolt.available() > 0) {
    char c =char(bolt.read());
    Name = Name + c;
  }
  Name.trim();
  if (Name != "") {
    alert(Name);
  }
}

void alert(String person_name) {
  if (person_name == "RESET") {
    count = 0;
    return;
  }
  count++;
  Serial.println(count);
  if (count > 4) {
  digitalWrite(buzzer,HIGH);
  lcd.setCursor(1,0);
  lcd.print(person_name);
  delay(4000);
  digitalWrite(buzzer,LOW);
  delay(10000);
  lcd.clear();
  }
  else {
  lcd.setCursor(1,0);
  lcd.print(person_name);
  delay(10000);
  lcd.clear();
  }
}

Credits

Tejaswi Babu

1 project • 0 followers

Bolt Leave Tracker and Limiter

Things used in this project

Hardware components

Software apps and online services

Story

Hardware Connections

Building up the Logic on Integromat

For Leave Limiter Scenario:

For Reset Scenario:

Workflow

Schematics

LCD_I2C library

Code

Leave limiter Arduino

Credits

Tejaswi Babu

Comments

Embed the widget on your own site

Bolt Leave Tracker and Limiter

Bolt Leave Tracker and Limiter

Things used in this project

Hardware components

Software apps and online services

Story

Hardware Connections

Building up the Logic on Integromat

For Leave Limiter Scenario:

For Reset Scenario:

Workflow

Schematics

LCD_I2C library

Code

Leave limiter Arduino

Credits

Tejaswi Babu

Comments

Related channels and tags