Hello All !
I’m looking to use Typeform to generate dynamic documents ( contracts ) . The idea is :
User select answers on the form, these data will synchronize with Google sheet then from google sheet a pdf will be generated using fields probably with Zapier.
However, I need to have more than just the answers that are on the form. I want that the answers selected on the form to generate bigger text in the backend.
Do you have an idea of how to proceed ?
All the best
Best answer by john.desborough
there are a couple of other ‘tricks’ in the use of Document Studio that you can use but these are for another day..
cheers
des
Hi
I guess
I remember he wrote about this in a thread quite a while back, but i cannot find it atm.
+6there are a couple of other ‘tricks’ in the use of Document Studio that you can use but these are for another day..
cheers
des
I really like your solution.
Would you mind providing us with a small template google doc, to to be able to see the setup?
It would probably help a lot of users comprehend the workflow.
Dan
Thanks for the comprehensive explanation, I will look into Lookup in details as i think its the main point of complexity here
I Guess the best way to learn will be to experiment
+6note the {{ fieldname }} structure for placing data from a field on a form
and from a google doc for a maturity assessment - one pic of a long document
note the last line of the table shown: the content is variable length and comes from a vlookup made in the google sheet based on the score the user achieved in this section.
note the static text, the {{field}} contents and the variable length possibility ..
cheers
des
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
