change timestamp

[bnmers]

Hello all

I have an app that keeps track of loads and times I am trying to add two columns to spreadsheet, depart and return, that will monitor the load column for a change. I have been successful with it working but it updates the time when I add to the load column and erases the previous time. Is there a way to record each load time and keep it in the spreadsheet to track both times depart and return.

[Aurelien · Accepted solution]

Hi @bnmers 

Yes. You  may want to create two columns, one for depart and the other one for return.
Set these with type ChangeTimeStamp.

Then specify which column change you want to track for each one. Here is an example:

[Aurelien · Accepted solution]

Hi @bnmers 

Yes. You  may want to create two columns, one for depart and the other one for return.
Set these with type ChangeTimeStamp.

Then specify which column change you want to track for each one. Here is an example:

[bnmers]

Thank you so much it works perfectly but one thing I would like to add is when i add the the watched column i would like the time stamp to be recorded on the spreadsheet and when i add again for another load it adds another timestamp in the same column but in a different row or even on another spreadsheet so it looks like this

loads       Depart      Return 

1                  7:15               8:20

2                8:30               9:10

3                 9:25               10:30

and so on…. Not really concerned so much with return time but depart time is important

[Aurelien · Accepted solution]

I don't really get your point, but maybe you want to use this type of action:

For reference: Actions: The Essentials - AppSheet Help

[bnmers]

Ok i will see if i can get that to work 

it is for keeping track of truckloads and time required from departing to returning but each individual load must have a timestamp and cannot be overwritten each time a load is added