Perancangan Arsitektur Aplikasi Web Menggunakan Data Real Time Dari Google Form Berbasis File CSV

Authors

  • Joko Triyono Rekasaya Sistem Komputer, Fakultas Sains Terapan, IST AKPRIND Yogyakarta
  • Erfanti Fatkhiyah Informatika, Fakultas Teknologi Industri, IST AKPRIND Yogyakarta
  • Haidar Ikram Ramadhan Informatika, Fakultas Teknologi Industri, IST AKPRIND Yogyakarta
  • Nizar Izzuddin Yatim Fadlan Informatika, Fakultas Teknologi Industri, IST AKPRIND Yogyakarta

DOI:

https://doi.org/10.34151/jurtek.v15i1.3182

Keywords:

APIs, CSV, Form, Real-Time, Sheet

Abstract

The use of information technology is now so massive, that even reports on community activities have also used information technology. Online forms for reporting are widely used and very easy to create, with complete features. One of the products from Google is Google Forms. Starting from reservation, registration, data collection, reporting, and many activities of sending information and data can be done using this form online. The results of the data have also been presented in full, either in the form of sheets or graphic information, so that the manager or admin does not need to process it again. In the development of information needs, it turns out that the information needs from the google form are not only needed by managers or admins, but some parties need that information in real-time and do not have to log in as managers or admins, so technology is needed to distribute the data and information and processed or presented in a real-time reporting information system. In the google form, several tools have been provided such as Google APIs, Share to Sheet, CSV, etc. to share information with other parties. This study performs modeling in the design of web application architecture using real-time data from google forms based on CSV files and has been tested and produced an application model that can be pasted into other applications so that information from the google form can be conveyed without having to log in to the manager or admin of the google form.

Downloads

Download data is not yet available.

References

CCPS Google. (2022, Juni 1). Bagaimana cara memublikasikan Spreadsheet ke web (dan apa artinya)? Retrieved from CCPS Going Google: https://sites.google.com/a/ccpsnet.net/googletraining/faq/FAQ-Drive/how-do-i-publish-a-sheet-to-the-web-and-what-does-that-mean

Evaluasi Kualitas Layanan E-Government Pemerintah Kota Yogyakarta Dengan Metode E-GovQual Modifikasi. (2016). Surakarta: Simposium Nasional Ke-15 RAPI 2016.

Google. (2022, Juni 1). Google Formulir. Retrieved from Wikipedia: https://id.wikipedia.org/wiki/Google_Formulir

PHP Manual. (2022, Juni 1). PHP: File Get Contents Manual. Retrieved from PHP Documentation: https://www.php.net/manual/en/function.file-get-contents.php

PHP: str-getcsv. (n.d.). Retrieved 06 10, 2022, from PHP: https://www.php.net/manual/en/function.str-getcsv.php

Support Google. (2022, Juni 1). File CSV. Retrieved from Support Google: https://support.google.com/google-ads/answer/9004364?hl=id

T, M. (2017). JSON at Work. Sebastopol: O'Reilly Media inc.

Triyono, J. (2015). Sistem Informasi Agroteknologi berbasis Web dan Jejaring Sosial Twitter. Surakarta: Seminar Nasional IENACO.

Triyono, J., & Haryani, P. (2017). Membangun Aplikasi Front End Web Dosen Berbasis Web APPML (Application Modeling Language). Surakarta: Simposium Nasional RAPI XVI – 2017 FT UMS.

Triyono, J., Fatkhiyah, E., & Wicaksana, M. E. (2021). Perancangan Arsitektur Aplikasi Tersebar Berbasis File Text. Seminar Multimedia & Artificial Intellegence (SMAI) (pp. 132-140). Yogyakarta: Fakultas Teknologi Industri Universitas Mecu Buana Yogyakarta.

Triyono, J., Haryani, P., & Farid AS, M. (2018). Membangun Aplikasi Web Front End dengan Teknik JSON (Java Script Object Notation). Yogyakarta: Seminar Nasional Aplikasi Sains dan Teknologi (SNAST 2018).

Published

2021-06-20

How to Cite

Triyono, J., Fatkhiyah, E. ., Ikram Ramadhan, H. ., & Izzuddin Yatim Fadlan, N. . (2021). Perancangan Arsitektur Aplikasi Web Menggunakan Data Real Time Dari Google Form Berbasis File CSV . Jurnal Teknologi, 15(1), 47–54. https://doi.org/10.34151/jurtek.v15i1.3182