Dynamic Value: read values from external database

Follow

To insert dynamic value in your powerpoint, you need the extended version of the powerpoint plugin

After you have created a Dynamic Value database on the d!nk Portfolio Manager (details in this article), you can use these data in an interactive d!nk publication by using the Dynamic Value elements)

The Read Session magjet allows you to fetch data out of a spreadsheet.

 

1. Connect your database to a publication

Picture1.png

When you click the component you need to fill in a label (can be any name you want) and the Enterprise Key. This enteprise key can be found when you open your enterprise on admin.dink.eu like in the screenshot below.

When you’ve filled in the enterprise key, clicking the “Fetch sheets” button will retrieve all sheets from the selected enterprise.

In the Input Sheet dropdown, select the correct spreadsheet which you want to connect to the presentation.

 

 

When you’ve selected the correct sheet you can select the column which you would like to show. This means that the dropdown where you can select your row, contains that value of each row.

Use the filter column to filter the displayed values based on the value of a column. you can add multiple filters. The filter column is mandatory. 

- Example: the prices are different for each country. A 'country' column specifies for which country the price is valid. The publication in which the dynamic value with price list is inserted, is created for Germany. So you would select filter column "Country" and choose "other" for filter value, and write "Germany" to filter out only the prices for Germany. If the prices are also different for each user, then you could add a second filter and select "user email" as filter value.

- NoteIf you want to use the "user login" to filer on, choose display column 'email', filter column 'email' and filter value 'other' {{subscriber.email}}

- Note: when you want to display all values of the column you need to set a filter of a column with all the same values:

- create an additional column and make all lines have the same value
(for instance column "Dummy" with values "0")

- select that additional column as filter, select filter on 'other' and the value 
(in our case the filter "Dummy" with 'other' value on "0")

 

2. Connect a survey element with a column in your database

Once you've selected the google spreadsheets and the filter, you're now able to show the values from the Dynamic Value database by connecting every survey element with a column of that spreadsheet in PowerPoint.

You do this by creating (or editing) a survey component and clicking the “Connect with Dynamic Value” checkbox.

You will be able to select the dynamic value you created earlier (with its label name). When you’ve selected the dynamic value you can choose the column you want to connect with this field.

 

In case the Dynamic Value already contains data in the specified column, the data will be shown in your publication. When you’ve selected the “Save changed data in the publication” checkbox it will save the data you enter in this input field.  

When the value was initially empty (column in spreadsheet did not contain data), it will save the value you entered in the input field. Remark that if there already was a value, it will change this value if you edit the input field in the publication.

Have more questions? Submit a request

Comments

Powered by Zendesk