I'm trying to create a login and logout sheet...

(Allen Elks) #1

I’m trying to create a login and logout sheet for packages received.

I’m having trouble figuring out how to get this to work from google sheets.

I’m pretty sure it can’t be from one sheet as there cannot be duplicate mailbox numbers or dates.

The columns headers I have are:

Mailbox Number Date Received Carrier Date Picked Up Signature

Do I have to have a separate spreadsheet for the mail box numbers, the received date, and the date my mailbox customer picked up the package.

Also if so, how do I insert those columns into my app if they are on separate sheets?

Thanks!

(Aleksi Alkio) #2

What is the main reason you can’t use the same record for all of these values?

#3

Hi @Allen_Elks Have a look at this sample App for tracking packages. appsheet.com - Shipment Tracking - An app to track package pickup and drop-off times, distances and status. Shipment Tracking - An app to track package pickup and drop-off times, distances and status. appsheet.com