How Can I create a mobile form on smart and connect it to online spreadsheet?

Hi!

I want to achieve this, and looking for advise as I am unsure where to start...

I work for a car dealership where we currently have a minefield of paper  work which I would like to cut down.  To start with we have a customer enquiry pad, which we have to fill out by hand, and then pass it to management who in turn have to then copy the data in to a spreadsheet.

The solution I am looking for is to create an online form which you can use and complete on a smart phone or tablet - perhaps in an app, but not essential.  
On completion it would populate a PDF which can be emailed automatically to my inbox for printing. (See attached for example).   Equally it is important for each record to be saved (cloud based), and given a uniqe ref number and also for certain parts of the form to automatically be added to a online spreadsheet that can be seen and edited by the sales team and the line manager.

Just to make it complicated I don't know any programming, but am a dab hand with todays wyswig style programs.

Hope that makes sense and I am not asking too much. Looking forward to your advice...

thanks
Car-Appraisal.jpg
ralph heijmerAsked:
Who is Participating?
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.

Jason C. LevineNo oneCommented:
Hi heijmer01,

Look into something like WuFoo:

http://www.wufoo.com/

It's a hosted form builder that should support all of your requirements.  No programming experience necessary.
0
RobOwner (Aidellio)Commented:
heijmer01,

There's a lot to do here and really unless you can break it down further you'd want to be hiring someone to do this.  I can outline basically what you'll need but actually doing the work could take weeks.

You'll want on-going support for this so either you would maintain it but it sounds like you may be out of your depth so you would want someone you could contact - just something to keep in mind.

Ok that said...

I would start looking at bootstrap or jquery mobile for the visual layout of your site.  Bootstrap works great because you can use the same html code on a mobile as you can on a laptop or desktop and it will adjust according to the size of the screen.  I personally use bootstrap but have nothing really against jquery mobile.

I'd forget about a spreadsheet, you would put all this into a database.  You could pull the information into a spreadsheet later (or similar looking webpage) for those that need it in one.  

You could also generate a PDF on the fly and have it emailed, using the database as a source for all these tasks.

I'd have another internal page that only staff could access to amend information as needed.

Happy to answer any more questions about the scope and what you'll need.  

As for the code, I'd be VERY surprised if you'll get anyone posting anything here as it's what we usually get paid for.

Rob
0

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
ralph heijmerAuthor Commented:
thanks guys ill look into these options
0
Jason C. LevineNo oneCommented:
heijmer01,

I forgot to add that you will probably want to combine Wufoo forms with a trigger-based automation service like IFTTT or Zapier to get the full benefit out of it. Those services would detect new form submissions and can write data to a Google Spreadsheet or send it to other services as you need.
0
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
Miscellaneous

From novice to tech pro — start learning today.

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.