You can populate a table or a list with dataset values by binding the table or the list to the necessary dataset.
To open a quick Datasets cheat sheet, click the button below.
By watching this video, you'll find out how to get dataset values inserted into your email messages automatically and interactively.
Note. Make sure that all the cells in the row are empty because the add-in won't overwrite the data that the cells already contain.
Note. The names of the selected columns will populate the row in the order that they are present in the Select columns box. If a different order is needed, clear all the checkboxes under Select columns, and then select columns in the order required for your table.
Note. When binding a table to a dataset that contains the Regex field and Regex columns, you can select the Auto-insert matched rows checkbox. With this checkbox selected, data from matched dataset rows will populate the inserted table automatically, without a dialog showing up. If matches are not found, no rows will be added to the table.
When you insert such a template into an email message, you'll see a dialog containing a list of key values (values from the key column of the dataset). To specify the rows that you want to add to the table in your email message, select the corresponding key values. Then click OK.
Tip. To select all the key values at once, click the very first checkbox—the one that is next to the search box.
In the email message, values from the specified rows will populate the table.
Note. If you want to get key values from some rows selected automatically, set those rows as default ones.
To unbind a table from the dataset it's bound to, start editing your template, right-click the bound row, and select Unbind from Dataset.
Note. When binding a list to a dataset that contains the Regex field and Regex columns, you can select the Auto-insert matched rows checkbox. With this checkbox selected, data from matched dataset rows will populate the list automatically, without a dialog showing up. If matches are not found, the list won't be inserted.
When inserting such a template into an email message, you'll see a dialog containing a list of key values (values from the key column of the dataset). To specify the rows that will form a list, select the corresponding key values. Then click OK.
Tip. To select all the key values at once, click the very first checkbox—the one that is next to the search box.
Note. If you want to get key values from some rows selected automatically, set those rows as default ones.
In the email message, a list containing values from the specified rows will appear.
To unbind a list from the dataset it's bound to, start editing your template, right-click the list item, and then select Unbind from Dataset.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!