We help IT Professionals succeed at work.

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

ralph heijmer
on
165 Views
Last Modified: 2014-09-05
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
Comment
Watch Question

Jason C. LevineDon't talk to me.
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Owner (Aidellio)
CERTIFIED EXPERT
Most Valuable Expert 2015
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
thanks guys ill look into these options
Jason C. LevineDon't talk to me.
CERTIFIED EXPERT

Commented:
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.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.