From paper to the cloud: The experience of creating digital inventory control

Authors

DOI:

https://doi.org/10.61117/ipsumtec.v8i2.427

Keywords:

inventories, Google, system, automation

Abstract

This paper presents the methodology followed in the development of a digital inventory control system implemented at the Secretariat of Planning, Finance, and Administration (SPFA) of the State of Puebla. The project was developed using Google's no-code AppSheet platform. The methodology applied included documentation, requirements analysis, table design, system development, and results evaluation. The main objective was to replace manual and scattered records with an automated, accessible, and secure application.

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...

Author Biographies

Serbando García López , National Technological Institute of Mexico

Serbando García López has a Master's degree in Information Technology from the Monterrey Institute of Technology and Higher Education. He currently works as a lecturer at the Puebla Institute of Technology, where he teaches specialized subjects in the Logistics Engineering degree program, creating links with the business sector, such as with the company Tesselar, which is an SAP ERP partner in Mexico, to prepare and certify students in their final semester in this system and thus include them in its workforce. He has also collaborated in the private sector, such as the textile industry, where he has been in charge of business systems and responsible for supply and distribution logistics.

Filiberto Gonzalez Guarneros , National Technological Institute of Mexico

Filiberto González Guarneros works at the National Technological Institute of Mexico, Puebla Technological Institute campus. He holds a Master's degree in Information Technology from the Monterrey Institute of Technology and Higher Education. He worked in the IT department of a national transport company, developing systems and as Head of the Business Unit. Management Systems Auditor.

María Teresa López Aburto , National Technological Institute of Mexico

M.A. and G.I.E. María Teresa López Aburto is a professor in the Department of Economics and Administration at the National Technological Institute of Mexico/Technological Institute of Puebla, Puebla, Mexico. She currently holds the position of Head of the Department of Extracurricular Activities at the Technological Institute of Puebla. From 2022 to 2024, she led the coordination of external services within the Outreach Department of the same institution.

Violeta Martínez Ramírez , National Technological Institute of Mexico

Dr. Violeta Martínez Ramírez, who studied Computer Systems Engineering in Programming, holds a Master's Degree in Education Sciences and a Doctorate in Education. She is a professor in the Systems and Computing Department at the Technological Institute of Puebla, teaching mainly Programming in Information Technology and Communications Engineering. She is the leader of the PRODEP Desirable Profile (2020), leader of the Academic Body “Applied Computing” (2021), and head of Outreach Projects (2020).

Brandon Trejo Herrera , National Technological Institute of Mexico

Brandon Trejo Herrera is an engineer currently completing his degree in Information Technology and
Communications. I have participated in web development projects, notably my collaboration with the
Secretariat of Planning, Finance, and Administration of the State of Puebla, where I contributed to the development of an institutional directory and the management and updating of the portal of courses offered to state government employees. My main areas of interest include cybersecurity, web development, and application creation using no-code platforms.

References

Gobierno del Estado de Puebla. Manual de organización de la Secretaría de Administración [Internet]. Puebla: Orden Jurídico Poblano; 2020 [citado 2025 ago 24]. Disponible en: https://ojp.puebla.gob.mx/media/k2/attachments/Manual_de_Organizacion_de_la_Secretaria_de_Administracion_3072020.pdf

Jasmin. Control de inventario: ¿qué es y cuál es su importancia? [Internet]. 2019 abr 10 [citado 2025 ago 24]. Disponible en: https://www.jasminsoftware.es/blog/control-de-inventario/

SAP. ¿Qué es el desarrollo no-code? [Internet]. 2025 [citado 2025 ago 24]. Disponible en: https://www.sap.com/spain/products/technology-platform/build/guide-to-no-code-development.html

https://cloud.google.com/appsheet?hl=es

Google Cloud. AppSheet [Internet]. [s.f.] [citado 2025 ago 24]. Disponible en: https://cloud.google.com/appsheet?hl=es

Alegria Group. ¿Qué es Google AppSheet y cuándo debo utilizarlo? [Internet]. 2023 feb 3 [citado 2025 ago 24]. Disponible en: https://www.alegria.group/es/blog/google-appsheet

Envato Tuts+. ¿Qué son los Intents de Android? [Internet]. 2017 ago 24 [citado 2025 ago 24]. Disponible en: https://code.tutsplus.com/es/what-are-android-intents--cms-29335t

Alcedo Quijano LE. La gestión de inventarios y el desempeño comercial de la empresa Líder Cloud Huánuco 2019 [Internet]. Perú: Universidad de Huánuco; 2020 [citado 2025 ago 24]. Disponible en: https://repositorio.udh.edu.pe/handle/123456789/2398

León León EE. Propuesta de modelo de adopción de Cloud Computing en la implementación de un sistema de control de inventario en las PYMEs del sector ferretero de la ciudad de Machala [Internet]. Ecuador: Universidad de Machala; 2021 [citado 2025 ago 24]. Disponible en: http://204.199.82.243:8080/handle/123456789/1465

Álvarez Martínez M. Desarrollo de un sistema automatizado de gestión de inventario mediante reconocimiento de objetos con OpenCV y redes neuronales convolucionales en entornos cloud [Internet]. Madrid: Universidad Complutense de Madrid; 2024 [citado 2025 ago 24]. Disponible en: https://docta.ucm.es/entities/publication/d7f19d27-d109-4ec9-96d4-d6ba7201342e

Moreno Alfonso FS, Villa Ahmad DA. Diseño de arquitectura de un software para un prototipo de gestión de inventario con tecnologías en la nube [Internet]. Bogotá D.C.: Politécnico Grancolombiano; 2023 [citado 2025 ago 24]. Disponible en: https://repository.poligran.edu.co/handle/10823/

Quixy. Los 15 principales beneficios del desarrollo de aplicaciones sin código [Internet]. 2025 ene 8 [citado 2025 ago 24]. Disponible en: https://quixy.com/blog/top-benefits-of-no-code-app-development/

ONEGOLIVE. ¿Qué es el No-Code? Las 15 razones para usar esta tecnología [Internet]. 2021 may 4 [citado 2025 ago 24]. Disponible en: https://www.onegolive.com/no-code-tecnologia-empresa/

OLLABOT. Ventajas de las plataformas sin código: 5 beneficios clave revelados [Internet]. 2025 jul 16 [citado 2025 ago 24]. Disponible en: https://ollabot.com/es/ventajas-de-las-plataformas-sin-codigo/

Logística Evolutiva. 5 innovaciones tecnológicas que están redefiniendo la gestión de inventarios [Internet]. 2025 [citado 2025 ago 24]. Disponible en: https://logisticaevolutiva.puntanetwork.com/innovacion-en-la-cadena-de-suministro/5-innovaciones-tecnologicas-estan-redefiniendo-gestion-inventarios/

Defontana. El futuro de la gestión de inventarios: 6 tendencias en software [Internet]. 2025 [citado 2025 ago 24]. Disponible en: https://www.defontana.com/blog/pe/el-futuro-de-la-gestion-de-inventarios-6-tendencias-en-software

Downloads

Published

2025-12-19

Crossmark

Crossmark Policy Page

How to Cite

García López , S., Gonzalez Guarneros , F., López Aburto , M. T., Martínez Ramírez , V., & Trejo Herrera , B. (2025). From paper to the cloud: The experience of creating digital inventory control. REVISTA IPSUMTEC, 8(2), 158–164. https://doi.org/10.61117/ipsumtec.v8i2.427

Issue

Vol. 8 No. 2 (2025)

Section

Artículos

License

Copyright (c) 2025 Serbando García López , Filiberto Gonzalez Guarneros , María Teresa López Aburto , Violeta Martínez Ramírez , Brandon Trejo Herrera

Creative Commons License

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

Most read articles by the same author(s)

1 2 3 4 > >>