Use cases

• Illustrate your data by using a bar chart diagram

Configuration

 Reload

Click on the reload icon to scan the Google Form for modified, added or removed fields.

 Create form

After adding the script to your flow, click on the keyboard icon in the input parameter section.

After adding the form you can enter the values to be displayed in your chart into the text boxes.

Please make sure to use the syntax that is described in the placeholder in the text boxes. For example the values to be used in the chart have to be delimited by a comma.

You can either enter fixed values or you can use variables to generate your charts from data coming from a Google Sheet, your contacts or any other data source.

If you for example have a list variable called items[].quantity that holds a number of values that you want to visualize in your chart, you can use the loop with separators like this:

${foreach items item ,}${item.quantity}${end}

If you want to create a list separated by the pipe symbol |, you can use a statement like this:

${foreach items item |}${item.name}${end}

Render the chart

The ${bar} variable contains the URL of the generated chart. To display the chart in your documents or emails, please use the image renderer.

When generating HTML you may want to specify the size of the resulting chart in pixels:

${bar;image(width=200px;height=200px)}

When generating PDF documents you may want to specify the size of the resulting chart in cm instead:

${bar;image(width=4cm;height=4cm)}

Questions and Feedback

If you have any comments on this page, feel free to add suggestions right to the Google document that we are using to create this site.

If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.

Last Updated: 11/28/17