Create Onsite Quotation Template using Google Forms

Hi, can help. Will develop nice google form, if you wish it will be also mobile friendly. Best regards, Viktor

Hi there, I will be happy to help you with that. We will bound a Google Script to the form and add onSubmit trigger to it to fire the script every time the form is submitted. The script will calculate the estimated cost based on the entered data and add the correct fees. Then it will make a copy of the template sheet or doc "that is used to produce the pdf quote", then add the data to the new generated sheet or doc and export it as pdf file, then email it as an attachment to the customer with a customized email, like "Hello <<customer name.>". Do you like coding? I am passionate about JS. Have a fluency around google apps - sheets and forms specifically? earning my living dealing with those. Can troubleshoot to get the process right? Yes, I certainly can. I will be haapy to address any of your questions! Sincerely, Mohamed

Hello, I have reviewed your project requirements. As mentioned in the project description, - You want a Google Form linked with Google Sheet for calculations and total costs to be created to be used for onsite quotations. - You want the form to have functionality to calculate estimated costs based on per square meters along with adding project management fee (percentages). - You want the end result of the form to be automatically emailed all information to the customer in a PDF quote. I have much experience in working with Google Forms, Google Sheets and Google Apps Script. Here are answers to your questions: Do you like coding Javascript? - Yes. Have a fluency around google apps - sheets and forms specifically? - Yes. Can troubleshoot to get the process right? - Yes. - Do you have any template or design preferences for PDF to be emailed? - When Google Form is submitted, the calculations can be done on the fly and email with PDF file can be sent using Google Apps Script. - The script can also written to get data from Google Sheet, perform calculations and send email. You may provide further details required to start the project. Thanks.

I can help you with following: 1- Google Forms 2- Google Sheets 3- Customization of Sheets 4- Google Forms and Sheets Integration 5- Custom workflow and processes And Yes I know very well in Javascript