User Location based on time

AppSheet AppSheet Q&A
,
1

Good day,

I am building a timesheet app for HR. So because we have on-site technicians that can’t ‘Clock In’ at the office, I need to get their current location when they clock in and out.

I created a column for LatLng clock-in and clock-out. I then created a FORMULA of HERE() for both columns. (Note that I created them as virtual columns and went to create them in Sheets too).

Vader_0-1677228890705.png

When I clock-in, it adds the coordinates but it also processes the clock-out FORMULA and causes what’s on the image above.

Vader_1-1677229384729.png
Vader_1-1677229384729.png946×225 9.91 KB

How do I get it to ONLY register clock-in coordinates when a user starts their shift? and vice versa for clock-out.

I’ve even tried using INITIAL VALUE with no success. I know it’s probably easy but it seems i am missing something in my thinking.

Thank you in advance.

2

The answers depends on how your in/out functionality is set up. How is it?

You definitely don’t want them as virtual columns.

1 Like
3

there should be two columns in the table [IN] [OUT]. INITIAL VALUE Here.

and in the virtual column the formula is [IN]&“-IN” and in the second column the formula [Out]&“-Out”

4

Capture GPS location - AppSheet Help

5

They are not virtual columns, they were standard columns when I originally created them.

I have standard columns LatLng Clock In & LatLng Clock Out with an INITIAL VALUE of HERE() and are of type LatLng

I also have virtual columns IN and OUT which have FORMULA of LatLng Clock In and LatLng Clock Out respectively and are of type Text (also tried making it LatLng).

I tried @koma25 's suggestion of having standard columns and then virtual ones. It gave the same answer.

6

Thanks, I have already gone through this and gained an understanding of how it works. However, I am struggling with my specific use case. Still no resolution even now, so I’m guessing my logic is wrong somewhere. I’m a noob in AppSheet so perhaps that’s why.

7

I took the suggestion and applied as advised but still. No change. My setup is explained in Marc’s reply above.

8