Need to create a mobile app that users can enter data then submit to a sql database


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).
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brandon LyonSenior Frontend DeveloperCommented:
I'm a bit unclear on the requirements. It sounds like you want an app but you asked the question in the websites topic area. Assuming you want to make an app it will be easiest if you use a cross-platform toolkit. Here are a few options:

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.
lapuccaAuthor Commented:
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.
lapuccaAuthor Commented:
OH, I searched but didn't find a Mobile App section to post this question.  How do I find it?
Brandon LyonSenior Frontend DeveloperCommented:
jQuery mobile is just a website building tool which probably won't help you build an app. Apps and websites are usually different document types (ie not HTML) and different languages than a website. While you can build JS based apps it still requires wrappers such as Iconic, React, Titanium, or Cordova.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lapuccaAuthor Commented:
Thank you.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Responsive Web

From novice to tech pro — start learning today.