Arrival & Depature

[Simon_Blackburn]

I am looking for a solution to a small problem I am having.

I am a self employed trucker and quite often I have multiple deliveries to make from one trailer full of a customers goods.

In wanting to move away from paper based records, I would like to make something to record my days arrival and departure times. The app would go like this and record the info on a google sheet:

Open the app at start of shift.
Press a button to record Start of Shift.
Select Vehicle Registration/License Plate from a list.
Select Trailer number from a list or manual input.
Manual input of the name or address of 1st delivery.
Press a button to record arrival date/time at 1st address.
Press a button to record departure date/time of 1st address.

Manual input of the name or address of 2nd delivery.
Press a button to record arrival date/time at 2nd address.
Press a button to record departure date/time of 2nd address.

Manual input of the name or address of 3rd delivery.
Press a button to record arrival date/time at 3rd address.
Press a button to record departure date/time of 3rd address.

Press a button to record end of shift.

Is this something possible on AppSheet or am I asking too much?

[daniel_sanchez]

off course, the "appsheet" It is optimized for this type of application. create your form in the chrome sheet and link it to appsheet, you will be surprised

[Steve]

AppSheet is just about perfect for what you want! 🙂

[SkrOYC]

Yep, it's very easy for AppSheet to handle what you want.

At least, you would need to learn about:

• App design 101 - AppSheet Help
• Data: The Essentials - AppSheet Help
• Actions: The Essentials - AppSheet Help

You need to have your data organized, you will need around 4 tables IMO. Learn about the concepts of database normalization. It's more or less explained in the second link.

"Buttons" can be made of Actions, these actions vary on their purpose. I would say you need the "Add a new row to another table with..." and the "set the value of a column of this row" ones.

Also, there are always different ways to do something on AppSheet, so... have fun! And consider that I'm just suggesting you some ideas, you can do whatever you want and however you want it, as long as you understand the platform