Perancangan Arsitektur Aplikasi Web Menggunakan Data Real Time Dari Google Form Berbasis File CSV
Keywords:APIs, CSV, Form, Real-Time, Sheet
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.
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).
How to Cite
Copyright (c) 2022 Joko Triyono, Erfanti Fatkhiyah, Haidar Ikram Ramadhan, Nizar Izzuddin Yatim Fadlan
This work is licensed under a Creative Commons Attribution 4.0 International License.