We need a service field sheet for Android with backend databases stored on the web in SQL.
Service call information would relate to serviceman user name. This information would be uploaded to back end as needed.
The service person would have their login set on a preference screen on the Android. So they don't have to login for each call.
They would enter the work order number for the call (from a document in there possession) which would look up the user name and address info. This way they verify they are at the correct location for service. They then (these three items are most important) need to take a picture of their location using the mobile device and capture the GPS location information as well as time stamp expressed in military time. Please see screenshot 2. They would then need to enter other text field such as notes on page 2 and continue with entries on page 3 (screenshot) or page 4 (screenshot). They would then hit submit to send info completed back to server or store info to next time server is available. Such as at next stop when they would submit this record as well as next call. Once records are completed they would have no further access to the records. I would also like to have certain required entry fields. They can only exit record on screenshot 1.
So the fields listed on the screen shots would need corresponding fields to collect data in SQL database.
Please let me know your questions.