• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 131
  • Last Modified:

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).
0
lapucca
Asked:
lapucca
  • 3
  • 2
1 Solution
 
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.
1
 
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.
0
 
lapuccaAuthor Commented:
OH, I searched but didn't find a Mobile App section to post this question.  How do I find it?
0
 
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.
0
 
lapuccaAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now