Hello
I want to create a form with different logic jumps and questions which would then give the user an approximate quotation of a price. Is there any way I can pick these values from a google sheet and display it to the user?
Answered
Get values from a google sheet
Best answer by john.desborough
It is entirely possible to collect information from the user in a typeform and Connect it to a Google Sheet and then create a customized quotation, invoice, etc that is turned into a pdf document that is sent to the user automatically
I use Google Sheets, an add-on called Document Studio and templates based in Google Docs and Slides to create customized reports. You create the ‘merge template’ document with the layout you need for your ‘report’ and then, using Document Studio to identify the merge document, the data is is merged into a document and converted to PDF. Documen Studio also allows you to create a customized email that you can send out, complete with attached pdf file.
I use this to create custom reports for assessment surveys and for a tshirt printing sideline that i have.
more details can be found in this community if you search on ‘document studio’ in the forum.
cheers
des
+5Hi
Hello
Basically, i want to create a form where customers can pick and choose from the services that we provide (its layered with different combinations) and then calculate their total bill/cost. I am open to tools other than google sheets or airtable but i’d much rather prefer having an external tool where we can seamlessly update the prices as we go along.
I understand it may not be possible and since i am new to typeform i’d appreciate any links or resources within typeform to achieve this too.
1 person likes this
+6- Certified Partner & Champion
- 5264 replies
- Answer
It is entirely possible to collect information from the user in a typeform and Connect it to a Google Sheet and then create a customized quotation, invoice, etc that is turned into a pdf document that is sent to the user automatically
I use Google Sheets, an add-on called Document Studio and templates based in Google Docs and Slides to create customized reports. You create the ‘merge template’ document with the layout you need for your ‘report’ and then, using Document Studio to identify the merge document, the data is is merged into a document and converted to PDF. Documen Studio also allows you to create a customized email that you can send out, complete with attached pdf file.
I use this to create custom reports for assessment surveys and for a tshirt printing sideline that i have.
more details can be found in this community if you search on ‘document studio’ in the forum.
cheers
des
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.