THE DEVELOPMENT OF APP SHEETS FOR DATABASE DESIGN TO APPLY TRANSPORT PLANNING APPLICATION

Tanawat  Wisedsin; Tanasarn  Panichayakorn; Piyamas  Klakhaeng; Phitphisut  Thitart; Pornkiat  Phakdeewongthep

Tanawat Wisedsin Suan Sunandha Rajabhat University
Tanasarn Panichayakorn Suan Sunandha Rajabhat University
Piyamas Klakhaeng Suan Sunandha Rajabhat University
Phitphisut Thitart Suan Sunandha Rajabhat University
Pornkiat Phakdeewongthep Suan Sunandha Rajabhat University

Keywords: Transportation, Operation Planning, Web Application, Database, App Sheets

Abstract

Abstract—This study aims to reduce the time of operation planning of transport businesses. Main activity 1) Coordinating Employers 2) Assign Truck Drivers 3) Readiness Tucks and 4) Operation Planning. They are working update changing, canceling, and Increasing before in a few hours or 1 – 2 Days to confirm. The maintenance department inspects the engine and light systems of the truck and reports. Planners are reading the report matching 3 - 4 destinations and truck drivers. All of the operations using time about 4 – 6 hours per day. The researchers and planning department staff set a time interval to confirm the employer's transportation work by 2:00 p.m. and create a web application for operation planning by database design using App Sheets is a web application for creating with low code and no code applications. Create 4 categories: 1) Recording of Companies and Partner Vehicles 2) Recording of Transport Employment 3) Operation planning 4) Cost Calculation. that refers to the coordinates of Google Maps and the company can add different expenses as needed.
Result overall of the operation reduces time by about 1 – 2 hours per day (33.33 %) and the remaining 2 – 4 hours per day.