GPS Tracking in Gen2

  • 1
  • Question
  • Updated 4 years ago
How to track GPS Co-ordinates when using Gen2 Mobile App?

(Originally posted by MichelleBohannan)
Photo of Archived Post

Archived Post, Official Rep

  • 2132 Posts
  • 6 Reply Likes

Posted 4 years ago

  • 1
Photo of Archived Post

Archived Post, Official Rep

  • 2132 Posts
  • 6 Reply Likes
Hi Michelle,

Yes, it is possible to track the GPS Coordinates. 

Please follow the below steps to have this setup. 

PS: This feature will work only for Locked-In Out timesheet. 

1. Create two "Timesheet Hour level" User Defined Field's with the following names (**Create them as 2nd and 3rd User Defined Field's). Make sure you set the status of those User Defined Field's to HIDDEN.    GPSCoordinatesForPunchIn GPSCoordinatesForPunchOut   2. Enable the permission "Allow mobile Locked In/Out timesheet" for the user.    3. On the user's Iphone make sure GPS feature is enabled.    4. When the user logs-in into Replicon he/she should see a message whether they would want GPS tracking to be enabled and they need to click OK for that.    5. Once the punches are done, you can see the GPS co-ordinates in reports using custom columns.  - You need to create separate custom columns for Punch-In Latitude and Punch-In Longitude, Punch-Out Latitude and Punch-Out Longitude    PS: Create 4 custom columns (in the TimeSheet hours details) report as follows:    1. PunchInLatitude   If (mid(GPSCoordinatesForPunchIn, 0, 1) = "-", mid(GPSCoordinatesForPunchIn, 1, 2), mid(GPSCoordinatesForPunchIn, 0, 2)) +" "+ Left(NumberToText(Floor (TextToNumber (mid(GPSCoordinatesForPunchIn, Find (GPSCoordinatesForPunchIn, "."), Find (GPSCoordinatesForPunchIn, ";")-1-Find (GPSCoordinatesForPunchIn, "."))) * 60)), 2) + "' " + NumberToText(((TextToNumber(mid(GPSCoordinatesForPunchIn, Find (GPSCoordinatesForPunchIn, "."), Find (GPSCoordinatesForPunchIn, ";")-1-Find (GPSCoordinatesForPunchIn, "."))) * 60) - RoundTowardsZero(TextToNumber(mid(GPSCoordinatesForPunchIn, Find (GPSCoordinatesForPunchIn, "."), Find (GPSCoordinatesForPunchIn, ";")-1-Find (GPSCoordinatesForPunchIn, "."))) * 60))*60) + "\""+If (mid(GPSCoordinatesForPunchIn, 0, 1) = "-", " S", " N")    2. PunchInLongitude   mid (NumberToText (Abs (RoundTowardsZero (TextToNumber ((mid(GPSCoordinatesForPunchIn, rfind (GPSCoordinatesForPunchIn, ";") + 1, len(GPSCoordinatesForPunchIn) - rfind (GPSCoordinatesForPunchIn, ";") - 1)))))), 0, If (Abs (RoundTowardsZero (TextToNumber ((mid(GPSCoordinatesForPunchIn, rfind (GPSCoordinatesForPunchIn, ";") + 1, len(GPSCoordinatesForPunchIn) - rfind (GPSCoordinatesForPunchIn, ";") - 1))))) < 100, 2, 3)) + " "+ Left (NumberToText (Abs ((TextToNumber(mid(GPSCoordinatesForPunchIn, rfind (GPSCoordinatesForPunchIn, ";") + 1, len(GPSCoordinatesForPunchIn) - rfind (GPSCoordinatesForPunchIn, ";") - 1))) - RoundTowardsZero (TextToNumber(mid(GPSCoordinatesForPunchIn, rfind (GPSCoordinatesForPunchIn, ";") + 1, len(GPSCoordinatesForPunchIn) - rfind (GPSCoordinatesForPunchIn, ";") - 1)))) * 60), 2) + "' " + NumberToText ((((Abs ((TextToNumber(mid(GPSCoordinatesForPunchIn, rfind (GPSCoordinatesForPunchIn, ";") + 1, len(GPSCoordinatesForPunchIn) - rfind (GPSCoordinatesForPunchIn, ";") - 1))) - RoundTowardsZero (TextToNumber(mid(GPSCoordinatesForPunchIn, rfind (GPSCoordinatesForPunchIn, ";") + 1, len(GPSCoordinatesForPunchIn) - rfind (GPSCoordinatesForPunchIn, ";") - 1)))) * 60) - Floor (Abs ((TextToNumber(mid(GPSCoordinatesForPunchIn, rfind (GPSCoordinatesForPunchIn, ";") + 1, len(GPSCoordinatesForPunchIn) - rfind (GPSCoordinatesForPunchIn, ";") - 1))) - RoundTowardsZero (TextToNumber(mid(GPSCoordinatesForPunchIn, rfind (GPSCoordinatesForPunchIn, ";") + 1, len(GPSCoordinatesForPunchIn) - rfind (GPSCoordinatesForPunchIn, ";") - 1)))) * 60)) * 60)) + "\"" + If (RoundTowardsZero (TextToNumber ((mid(GPSCoordinatesForPunchIn, rfind (GPSCoordinatesForPunchIn, ";") + 1, len(GPSCoordinatesForPunchIn) - rfind (GPSCoordinatesForPunchIn, ";") - 1)))) < 0, " W", " E")    3. PunchOutLongitude   mid (NumberToText (Abs (RoundTowardsZero (TextToNumber ((mid(GPSCoordinatesForPunchOut, rfind (GPSCoordinatesForPunchOut, ";") + 1, len(GPSCoordinatesForPunchOut) - rfind (GPSCoordinatesForPunchOut, ";") - 1)))))), 0, If (Abs (RoundTowardsZero (TextToNumber ((mid(GPSCoordinatesForPunchOut, rfind (GPSCoordinatesForPunchOut, ";") + 1, len(GPSCoordinatesForPunchOut) - rfind (GPSCoordinatesForPunchOut, ";") - 1))))) < 100, 2, 3)) + " "+ Left (NumberToText (Abs ((TextToNumber(mid(GPSCoordinatesForPunchOut, rfind (GPSCoordinatesForPunchOut, ";") + 1, len(GPSCoordinatesForPunchOut) - rfind (GPSCoordinatesForPunchOut, ";") - 1))) - RoundTowardsZero (TextToNumber(mid(GPSCoordinatesForPunchOut, rfind (GPSCoordinatesForPunchOut, ";") + 1, len(GPSCoordinatesForPunchOut) - rfind (GPSCoordinatesForPunchOut, ";") - 1)))) * 60), 2) + "' " + NumberToText ((((Abs ((TextToNumber(mid(GPSCoordinatesForPunchOut, rfind (GPSCoordinatesForPunchOut, ";") + 1, len(GPSCoordinatesForPunchOut) - rfind (GPSCoordinatesForPunchOut, ";") - 1))) - RoundTowardsZero (TextToNumber(mid(GPSCoordinatesForPunchOut, rfind (GPSCoordinatesForPunchOut, ";") + 1, len(GPSCoordinatesForPunchOut) - rfind (GPSCoordinatesForPunchOut, ";") - 1)))) * 60) - Floor (Abs ((TextToNumber(mid(GPSCoordinatesForPunchOut, rfind (GPSCoordinatesForPunchOut, ";") + 1, len(GPSCoordinatesForPunchOut) - rfind (GPSCoordinatesForPunchOut, ";") - 1))) - RoundTowardsZero (TextToNumber(mid(GPSCoordinatesForPunchOut, rfind (GPSCoordinatesForPunchOut, ";") + 1, len(GPSCoordinatesForPunchOut) - rfind (GPSCoordinatesForPunchOut, ";") - 1)))) * 60)) * 60)) + "\"" + If (RoundTowardsZero (TextToNumber ((mid(GPSCoordinatesForPunchOut, rfind (GPSCoordinatesForPunchOut, ";") + 1, len(GPSCoordinatesForPunchOut) - rfind (GPSCoordinatesForPunchOut, ";") - 1)))) < 0, " W", " E")    4. PunchOutLatitude   If (mid(GPSCoordinatesForPunchOut, 0, 1) = "-", mid(GPSCoordinatesForPunchOut, 1, 2), mid(GPSCoordinatesForPunchOut, 0, 2)) +" "+ Left(NumberToText(Floor (TextToNumber (mid(GPSCoordinatesForPunchOut, Find (GPSCoordinatesForPunchOut, "."), Find (GPSCoordinatesForPunchOut, ";")-1-Find (GPSCoordinatesForPunchOut, "."))) * 60)), 2) + "' " + NumberToText(((TextToNumber(mid(GPSCoordinatesForPunchOut, Find (GPSCoordinatesForPunchOut, "."), Find (GPSCoordinatesForPunchOut, ";")-1-Find (GPSCoordinatesForPunchOut, "."))) * 60) - RoundTowardsZero(TextToNumber(mid(GPSCoordinatesForPunchOut, Find (GPSCoordinatesForPunchOut, "."), Find (GPSCoordinatesForPunchOut, ";")-1-Find (GPSCoordinatesForPunchOut, "."))) * 60))*60) + "\""+If (mid(GPSCoordinatesForPunchOut, 0, 1) = "-", " S", " N")  

Let us know if this helps.

Thanks,

Lingaraj

Forum Moderator

Kindly do rate if you find this solution helpful. 

 

(Originally posted by Lingaraj Dharwad)