JungleMail 4 | Using a repeated section

Note: this tutorial applies to JungleMail 4 and earlier only. If you are working with JungleMail 5 or later, this tutorial does not apply to your version of JungleMail.

One of the JungleMail 4 features is a repeated section or a Repeater. It can be found in E-Mail content configuration tab and allows you to dynamically populate email content with data from your SharePoint lists.

In this video, you will see an example, of how you can use JungleMail to generate newsletter content automatically:

1. To access the Repeater, run JungleMail and navigate to E-mail Content. Select a table or put the cursor where you need the repeater to be and click the button:

2. By clicking it, you will access the configuration window:

3. After you save the settings, the R epeater will be present in your email body.

Settings are as follows:

Content list – a list which contains data than you need to include in your email body.
Filter content by view – a specific view in that list.
Number of items to display – you can set a limit to returned items.
Additional conditions – rules that determine what data is retrieved. You can add conditions after you select the source list.

Configuring the additional conditions

After you select a list for your data, you can click Add condition to start configuring them. The process is simple:

1. Select a column from the dropdown;

2. Select an operator, operator options depend on the column type that is selected;

3. Select a value type, it can be:

Value – a simple string of text that you enter,
Column – a column in your contacts list,
Formula – a combination of SharePoint columns and text.
* Formulas are given as text or columns. Column names are given directly, text must be given inside quotation marks. You can join text and columns to receive a longer string. Use & for that. For example, if you want to join the title “Mr” and name column, it would look like this: “Mr “ & First Name
Note the space before quotations.
You can also add (+) or subtract (-) to columns that hold numbers, for example: Today + 30.

4. Enter the value.

In the following example , we set up conditions for our licenses list.

First condition checks if licenses are active.

Second condition checks if company name is matching, with the one that is given in the recipient list.

Third one checks if their expiration date is in the future.

This setup will list all corresponding licenses for the company of the recipient, that are active and not expired

After we insert a repeater, we must insert columns from the source list. It can be done by clicking Columns.

Note: if no Repeater is present, JungleMail will only allow you to use columns from the recipients list. In order to access columns from the data source list, we must add a repeater and put the text cursor in it. Now you will be able to use columns from that list.

Add the columns and test your Repeater:

Once you go to the Preview step, you will be able to check what items were returned:

Using “In Range of” Operator

Added in JungleMail 4.1:

In range of allows you to compare multiple values to multiple values. Other operators like equals or contains only works with one. contains can compare multiple values in the recipient list, to a single value in a content list. If you need to compare multiple values in a column in the Recipient list, to multiple values in a Content list, you need to use in range of.