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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER