want an android application for mobile agents allows users to fill pre-specified forms out and send to a central database where data is gathered including gps coordinates. Key functionality is that
1) ability to create different forms on central website
2) aggregate data can be exported in excel, csv, pdf etc formats
3) all data must be accessible in the cloud
4) ability to sort aggregate data according to different fields
5) real-time upload of data
Firstly not sure what phone we are going to use so we need it to be compatible across several phones.
There will be different types of users hence the need to have different forms for different departments.
It is key that the app sends the gps co-ordinate at the time the information is filled and not when there is a signal. If there is no signal / connection then the data must be saved offline until the signal is stronger. If the gps information is not stored then the application / data will be useless.
For the majority of users we need to record time when form filling starts and when it is submitted as well as another field for type of activity e.g. sale, customer suggestion, customer update, address verification or follow up visit.
In most cases we'll need to store a picture (to be taken with the phone) that will be stored with the relevant data.
Where signal is an issue, it is important that all information can be stored offline and uploaded in bulk to a web server/cloud database - with easy identification of the user/senders id and activity.
Flexibility to create different forms is critical.