GPS coordinates in google sheet

We have many people working in remote locations. We pay them for the travel undertaken by them. We need a method by which we can capture their "Start" location and "End" location on their mobile. It will be useful as an attendance register also.

The fields required

email ID - Their logged in gmail id of the user (hidden)

Date (system date) (hidden)

Time (system time) (hidden)

GPS (current location) (hidden)

In/Out/Start/End (any one) mandatory

Distance traveled (optional)

Purpose - mandatory

Mode of travel - mandatory

Amount claimed - mandatory

Bill photo - optional

The user has to "Start" his journey and "End" his journey by two entries.

He has to punch "In" and punch "Out" in the morning and evening after reaching/leaving office

Each entry will go into a row in a google sheet.

I've seen some app on similar lines. (App to append data to google sheet with image and GPS coordinates ). But, need help to develop it. I'm new in this platform. Am expert in google app script.

Good to has a google apps script expert on board ! :wink:

Suggest you start programming your blocks then come back when you get stuck.

You may want to follow some tutorials:

Here are some resources to help you learn to use the AI2 tools A very good way to learn App Inventor is to read the free Inventor’s Manual here in the AI2 free online eBook … the links are at the bottom of the Web page. The book ‘teaches’ users how to program with AI2 blocks.

There is a free programming course here and the aia files for the projects in the book are here:

How to do a lot of basic things with App Inventor are described here: .



Learn about using lists:

General Tutorials