lapucca
asked on
Need to create a mobile app that users can enter data then submit to a sql database
Hi,
This would be a small form that users can enter data on their phone and submit it. The phones could be iPhone or Android. What would you recommend to use for developing this?
This will only be available to a couple dozen people in our organization. What's the best way to implement this? Restriction to download the app or ask user to authenticate using Windows credential each time they submit the data(which I'm sure probably will drive the users nuts).
This would be a small form that users can enter data on their phone and submit it. The phones could be iPhone or Android. What would you recommend to use for developing this?
This will only be available to a couple dozen people in our organization. What's the best way to implement this? Restriction to download the app or ask user to authenticate using Windows credential each time they submit the data(which I'm sure probably will drive the users nuts).
ASKER
Sorry for delay in replying, got pull off to work on something else.
I apologize for the confusion. My requirement is to provide solution for users to submit a form data, from anywhere on or off our domain, with a couple of drop down, a datepicker and 3 text boxes. User also only wants to enter their login credential once and it will be their Windows credential. I guess my web application, not the mobile web, will authenticate them. Most users only wants to submit this in mobile devices, mostly smart phones.
Also, a place where users can display, filter and run reports on these entries.
So, I thought maybe developing a mobile app for the form submission. Users can enter their credential on the app's setting so they don't have to renter that. The I would have a RWD web application where users to go to access these data and even submit the same type of form data through their desktop. Most of the user of the site will already be log into their pc at work, about 150 users. The mobile users are about 20, for now.
It's great information you shared about not publishing through APP store because it's really not needed for this mobile app. I read about jQuery Mobile, can I use that to create a mobile app or is that just the front end platform? I will also check out those tools you recommended.
Thank you.
I apologize for the confusion. My requirement is to provide solution for users to submit a form data, from anywhere on or off our domain, with a couple of drop down, a datepicker and 3 text boxes. User also only wants to enter their login credential once and it will be their Windows credential. I guess my web application, not the mobile web, will authenticate them. Most users only wants to submit this in mobile devices, mostly smart phones.
Also, a place where users can display, filter and run reports on these entries.
So, I thought maybe developing a mobile app for the form submission. Users can enter their credential on the app's setting so they don't have to renter that. The I would have a RWD web application where users to go to access these data and even submit the same type of form data through their desktop. Most of the user of the site will already be log into their pc at work, about 150 users. The mobile users are about 20, for now.
It's great information you shared about not publishing through APP store because it's really not needed for this mobile app. I read about jQuery Mobile, can I use that to create a mobile app or is that just the front end platform? I will also check out those tools you recommended.
Thank you.
ASKER
OH, I searched but didn't find a Mobile App section to post this question. How do I find it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
When it comes to deploying the app you don't have to go through app stores. App store distribution can make things more difficult because you'll have to follow strict rules to get them reviewed and approved. Android .apk files can be distributed directly via email or whatever and iOS apps can be distributed using tools such as Diawi.
If you're considering login credentials you can store them on the phone so the users only need to login once. I don't know if it's possible to use Windows credentials, I haven't looked into that. Since it's only a few people in the company you could probably just whitelist their devices IDs.