Link to home
Create AccountLog in
Avatar of ralph heijmer
ralph heijmer

asked on

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
SOLUTION
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of ralph heijmer
ralph heijmer

ASKER

thanks guys ill look into these options
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.