...
To use the Google Connector Edit , edit your form and [[V4_Designing_Forms#Display_Message_formatted_Using_a_Google_Document | use the Form Action Wizard to echo a formatted document back to the page]] and/or [[V4_Designing_Forms#Format_.26_Email_Using_a_Google_Document | and/or use Doc Action Wizard to format an email message]].
'''Google Document Template Syntax'''
This feature is currently in alpha release. The syntax may change.
The Google Document Connector uses a template syntax to insert values from a submitted form into the document. The syntax is ${form.[Name]}. Where [Name] is the name you gave to the particular form field in the frevvo Form Designer. Read more about [[V4_Designing_Forms#Name|naming naming form fields]].
Here is a Google document using the template syntax:
[[Image:googleDoc.png]]
'''Repeats'''
Repeats
Repeat controls have a special syntax. Assume that your form contains a repeating section named Expense. First you must add a Repeat As tag to the document. ${repeat form.[Name] as [alias]}. For example: ${repeat form.Expense as exp}. Then use the alias to reference the controls inside the repeat. The Connector's template processor will add a row to the table for each repeating item in the form submission.
[[Image:googleRepeat.png]]
'''Sections'''
Sections
Form controls nested inside sections must be referenced using a nesting notation. If two text controls named Firstname and LastName are nested inside of a section named PersonalInfo then the templates in your google document must be written as:
${form.PersonalInfo.FirstName}
$ ${form.PersonalInfo.LastName}
...
${form.MedicalHistory.PersonalInfo.FirstName}
$ ${form.MedicalHistory.PersonalInfo.LastName}
'''Limitations'''[[Image:18px-Symbol_OK.svg.png]]
Tip |
---|
The connector currently supports only form controls from palette. It does not yet support form controls from XSD data sources. |
...
Templates are case sensitive. If your form field is named '''Hours''' then your template must be written as ${form.Hours}. Using lower case as in ${form.hours} will result in no field data in the document. |
...
Warning |
---|
|
...
...
...
...
|
Google Connector Known Issues
The frevvo Google Google Connector is an alpha release. These are the known issues we are working to solve. Please report any issues or feedback to us [http://www.frevvo.com/frevvo/web/static/bug here].
<table border="1" bgcolor="lightblue">
<tr>
<th>Ticket</th>
<th>Description </th>
<th>Work-around</th>
</tr>
...
Ticket | Description | Work-around |
---|---|---|
3931 | Google Connector fails to replace templates with form field |
...
values | Text formatting of the templates can possibly corrupt the underlying html document structure. If your document fails to produce results for certain templates, delete the template and re-add it to your document. Copy and pasting template tags can have the same effect. Both problems are due to the fact that the Google Docs is inserting html font tags into the middle of your templates. You can also fix this by cleaning up the document in the html view. But better to avoid the problem initially. |
...
7710 |
...
Google Connector fails to add row to google |
...
spreadsheet | The Connector will fail to add a submission to your google spreadsheet if the spreadsheet has no empty rows at the bottom. Make sure your spreadsheet has plenty of empty rows at the bottom for all expected form submissions. |
...