External Fields


Essential
Professional
Enterprise
ReportR

External fields allows you to pull in data from external data sources, such as a spreadsheet.


What can the external fields feature be used for?

  • To read data from an external data source, for example, cell values from a Google sheet
  • Use these values in variable data in the PDF report or in the formulas using all responses. For example, to calculate a score on the outcome screen, if the respondent scored 5/10 in a particular survey category, you can match that score against an external data value of 7 which is the benchmark score set for that category.
  • A more advanced use would be to use the Google sheet as a bi-directional database, whereby the same survey will also send data to the Google sheet. This would allow the benchmark cell value referenced to be adjusted automatically as new responses are received.


Let's see how to use this feature.


Click on the 3 dots at the top right-hand corner of the screen. Select External Fields.


External fields button


Click the left-hand button Add field and you'll see the following sections to complete:


External fields options 

  1. Name - Type the name that you want to call the external field. This is the name that will be given to the variable, so choose a name which will allow you to easily recall what the field refers to.
  2. Type - Here's where you can choose the data source. You have 3 options which we'll discuss below.
  3. Data freshness - choose how often you want to refresh the data. Bear in mind that more frequent updates may slow performance.


Now let's see how to configure the data source. You'll have different options depending on the type of data that you selected as your source.

  1. Plain
  2. Spreadsheet
  3. Custom API


1 Plain

You simply need to enter a hard-coded value.


2 Spreadsheet

If you've chosen a Google spreadsheet as your data source, enter the spreadsheet ID, which is the value between the "/d/" and the "/edit" in the spreadsheet URL. Enter the cell where the value should be extracted from.


External fields spreadsheet ID


You can enable filter sheet values or compare sheet values, although only one of these features can be enabled at once.


For filter sheet value filter will check for similar values in the first column and then will return a comma delimited text for any matches. Make sure to specify the range of cells to filter.


The compare sheet values when enabled will...



NOTE

To get access to the data of your surveys (e.g. for calculations in the Spreadsheet), you will need to export the data to the Spreadsheet first via Zapier or Integromat.


IMPORTANT

You will need to share the spreadsheet with the user sheets@sa-api-prod.iam.gserviceaccount.com

3 Custom API

This uses the JSON output. Add the API endpoint and the JSON path.


External fields custom api


Once you've set up the data configuration settings, you can run a test to check the data connection and see that the results are as expected. Make sure that the latest changes are saved.


Once you're all set, click Create field to save all your external field settings.


External fields - create fields


If you want more than one external field, click Add field and repeat the process outlined above, adding as many external fields as you require.

V
Vincent is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.