Hello there,
I have a question regarding the use of Google Sheets in combination with Typeform hidden fields.
The Project Management team wants to evaluate projects, that are all listed in a Google Sheet containing information like: Name of the project, description and goals.
As there a quiet a lot, I would like to use hidden fields to create links that has the information from specific cells in the url.
What I did:
I created hidden fields in Typeform.
- name
- description
- goal
I published the survey form and the result is:
http://company.typeform.com/to/abcde#name=xxxxx&description=xxxxx&goal=xxxxx
So within the “xxxxxx” I want to be placed the info of the following cells:
name: d7
description: e7
goal: f7
I tried it with the hyperlink funktion, but I get errors.
It would be so great if someone can help me with that.
Best regards,
Tobias