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
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.
Numberof 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,
textmust 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
First condition checks if licenses are active.
Second condition checks if
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
Add the columns and test your Repeater:
Once you go to the Preview step, you will be able to check what items were returned:
Read more about using repeater then configuring JungleMail to automatically generate newsletters using SharePoint list items.
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