GPS coordinates in google sheet

MIT App Inventor Help
1

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.

2

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 http://www.appinventor.org/book2 … 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 http://www.appinventor.org/content/CourseInABox/Intro and the aia files for the projects in the book are here: http://www.appinventor.org/bookFiles

How to do a lot of basic things with App Inventor are described here: http://www.appinventor.org/content/howDoYou/eventHandling .

Regards,
Steve

Resources

Learn about using lists:

General Tutorials