Employee Attendance Information System Using Whatsapp Bot Based on Spreadsheet Database


Sistem Informasi Absensi Karyawan Menggunakan Whatsapp Bot Berbasis Database Spreadsheet


  • (1)  Daffa Maha Putra Muharom            Program Studi Teknik Informatika, Universitas Muhammadiyah Sidoarjo  
            Indonesia

  • (2) * Mochamad Alfan Rosid            Program Studi Teknik Informatika, Universitas Muhammadiyah Sidoarjo  
            Indonesia
    (*) Corresponding Author

DOI: https://doi.org/10.21070/jicte.v7i2.1652

Abstract

Chatbots are computer programs outlined to connected with individuals through content discussions. The most objective of a chatbot is to supply mechanized reactions that can illuminate issues and give data. This investigate points to create a chatbot-based time and participation data framework that utilizes area information and data to progress the precision and proficiency of time and participation administration. This framework combines WhatsApp and Chatbot and is coordinates with Spreadsheat as a database to track worker participation precisely, give programmed reactions, and store outline participation information safely. Spreadsheets are program applications utilized to oversee, organize and analyze information in unthinkable frame. In a spreadsheet, information is orchestrated in columns and columns, and each cell in a table can contain content, numbers, or equations. It is trusted that this WhatsApp chatbot data framework can offer assistance overcome the shortcomings of physically recording time and participation, make strides worker execution, teach and efficiency, and give time and participation information consequently.

Highlights:

  • Integration: The system integrates WhatsApp and Chatbot with Google Spreadsheet as a secure, manageable database.
  • Functionality: It uses live location sharing to verify employee attendance, ensuring accuracy and preventing manipulation.
  • Efficiency: Automates attendance recording, improving productivity and minimizing errors in manual data management.

Keywords: Information Systems, Chatbot, Whatsapp, Spreadsheet, Live Location

References

Abbas, Y., & Winarno, E. (2018). Perancangan Game Edukasi Pengenalan Angka dalam Bahasa Inggris Menggunakan Metode Collision Detection.

Febiola, S., & Evianti, D. (2021). Analisis Penggunaan Software Akuntansi Spreadsheet Terhadap Ketepatan Pencatatan Penjualan dan Penyajian Laporan Keuangan pada PT. Indomaret Cabang Bogor 2. Jurnal Informatika Kesatuan, 1(2), 187–196. https://doi.org/10.37641/jikes.v1i2.1367

Febriandirza, A. (2020). Perancangan Aplikasi Absensi Online dengan Menggunakan Bahasa Pemrograman Kotlin. Pseudocode, 7(2), 123–133. https://doi.org/10.33369/pseudocode.7.2.123-133

Fathoni Hamas, N., Walisongo, U., Hamka, J., & Semarang, K. (2024). WhatsApp Bot-Based Prayer Time Schedule Information System. Business of Apps. Retrieved from https://www.businessofapps.com/data/whatsapp-statistics/

Handayani, I., Kusumahati, H., & Badriah, A. N. (2017). Pemanfaatan Google Spreadsheet Sebagai Media Pembuatan Dashboard pada Official Site iFacility di Perguruan Tinggi.

Langi, B., Saerang, D. P. E., Gerungai, N. Y. T., & Kampus Bahu, J. (2019). Analisis Sistem Informasi Akuntansi Penggajian dan Pengupahan dalam Upaya Pengendalian Internal pada PT. Gemilang Emas Indonesia.

Mardian, A., Budiman, T., Haroen, R., & Yasin, V. (2021). Perancangan Aplikasi Pemantauan Kinerja Karyawan Berbasis Android di PT. Salestrade Corp. Indonesia. Jurnal Manajemen Informatika Jayakarta, 1(3), 169. https://doi.org/10.52362/jmijayakarta.v1i3.481

Muhammad, A., Kartika, R., Diyah, R., Bahri, S., & Nurhalifah, S. (2021). Pemanfaatan Google Spreadsheet Sebagai Media Penyimpanan Data Masyarakat RW.04 Kp. Cilayung. Proceedings UIN SGD Bandung. Retrieved from https://proceedings.uinsgd.ac.id/index.php/Proceedings

Purnadi, H. (2021). Pemanfaatan Google Spreadsheet dan Google Data Studio Sebagai Dashboard Suhu dan Kelembaban di Laboratorium. Insan Metrologi PPSDK, 1(1), 28–33. https://doi.org/10.55101/ppsdk.v1i1.639

Pustikayasa, I. M. (2019). Grup WhatsApp Sebagai Media Pembelajaran. Widya Genitri: Jurnal Ilmiah Pendidikan, Agama dan Kebudayaan Hindu, 10(2), 53–62. https://doi.org/10.36417/widyagenitri.v10i2.281

Ramadhan, D. F., Noertjahjono, S., & Irawan, J. D. (2020). Penerapan Chatbot Auto Reply pada WhatsApp Sebagai Pusat Informasi Praktikum Menggunakan Artificial Intelligence Markup Language.

Rio, N., Hariyanto, D., & Sunita, E. (2019). Rancang Bangun Sistem Informasi Absensi Karyawan Pada PT. San Andreas Mandiri Bekasi. IJSE - Indonesian Journal on Software Engineering, 5(2), 34–41.

Roosdianto, R., Sari, A. O., & Satriansyah, A. (2021). Rancang Bangun Aplikasi Sistem Informasi Absensi Karyawan Online. INTI Nusa Mandiri, 15(2), 135–142. https://doi.org/10.33480/inti.v15i2.1932

Setiawan. (2020). Pengertian Absensi – Jenis, Tujuan, Efektivitas, Sidik Jari, Catatan Tangan, Almano, Teknologi. Guru Pendidikan. Retrieved from https://www.gurupendidikan.co.id/pengertian-absensi/

Sugeng, S., & Mulyana, A. (2022). Sistem Absensi Menggunakan Pengenalan Wajah (Face Recognition) Berbasis Web LAN. Jurnal Sisfokom (Sistem Informasi dan Komputer, 11(1), 127–135. https://doi.org/10.32736/sisfokom.v11i1.1371

Picture in here are illustration from public domain image (License) or provided by the author, as part of their works
Published
2023-10-06
 
Issue
Vol 7 No 2 (2023): October
Section
Articles

Copyright (c) 2023 Daffa Maha Putra Muharom, Mochamad Alfan Rosid

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.