Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Our dynamic, self-updating, member lists are a great way of grouping users together to be used in different parts of your site. Users can be grouped based on almost any criteria and myClubhouse will run the search for you!

...

How to Create a New Member List

  1. Sign in to your myClubhouse site with an Administrator-level account.

  2. Navigate to the Member List Manager (admin) page:

    1. by default, this is under the Email menu.

    2. or type “/MemberList” into your browser’s address bar e.g.

      Image Modified

  3. Click “Add new” to create a new member list.

    Image Modified

  4. Details: Basic information about the member list.

    Image Modified
    1. Name: The name for this Member List.

    2. Description: A short description

...

    1. of the purpose of this Member List.

    2. Owner: This will usually be the person who created the Member List.

    3. Categories: Member Lists can be sorted into categories (see the section below). If you want to select a category for this Member List, do so here.

  1. Entitlements: This defines who can use and edit this member list. It is usually best to leave these as the site-wide default.

    Image Modified

  2. Design: The Member List is created by running a search on the database or members. The search will be run each time the Member List is used, so it will always be up-to-date. Enter elements to build up the criteria for the Member List search.

    Image Modified
    1. Add Criteria: Add another criterion to the Member List.

    2. Add Grouped-criteria: Add grouped criteria to the criteria above. Such as a member that is either male OR aged over 18. For readers with an understanding of logic, these clauses would be contained within brackets e.g. Is Current Member AND (Gender is Male OR Age is over 18)

    3. And/Or: Criteria can be used in an “And” or “Or” Capacity. If “And” is chosen, all criteria must be true for a user to be added to the list, if “Or” is chosen, only 1 criterion must be true. Read more about the And/Or operators in the “Advanced Member Lists” section at the bottom of the article.

    4. Delete criterion: Removes this criterion from the Member List.

    5. Family Extension: If this option is selected, results will be extended to include Parents, and/or Family Group Members of the members returned by the search.

  3. Test Run: This can be used to test the Member List before saving and using it. Just click the “Run” button and you will be shown a list of all matching users along with the count.

    Image Modified
  4. Save: Save the Member List.

    Image Modified

Other Functions

In the Member List Manager, there are some extra options next to each Member List.

...

c. Juniors: This is an example of a sub categorysubcategory. This is a category within another category where Member Lists can be added. For example, if you had a category for current members , and former members, you may want a sub category subcategory for junior members in both of these categories. These types of categories also make the organisation of Member Lists very easy.

d. Add Category: Click this button to add a new top-level or sub categorysubcategory.

...

Parent Category: If the new category sits within a an existing category, select the existing category as the Parent; otherwise leave it as “(top-level)”.

...

Common Member List Examples

The possibilities of for Member Lists is are almost endless, but here are some common examples of Member Lists that are very useful for many clubs.

...

A List showing users who were members last season but have not renewed this season. By using the “Is previous season” criterion, there is no need to hard code dates. In the example, the “Renewal status” is set to NOT “Renewal completed”, and all adult membership categories Membership Categories have been selected.

...

Group of Events

...

A List showing all members in the “Pending Member Action” section of Manage Subscriptions.

...

Bookings Today

A List showing all members who have a live booking today. This could be useful if sending an email regarding mass cancellations such as for weather making Assets unusable.

...

A List showing all members who have granted the “Photo Consent” Consent.

...

Advanced Member Lists

This section explains some of the more advanced options that can be used when creating Member Lists.

...

The AND and OR operators can’t be used at the same level to avoid confusion when writing expressions, therefore if you need to use both when creating a Member List, you have to indent the clauses that need to be different. The vertical lines to the left of the criteria represent brackets in the expression that makes up the Member List. In the example below, the expression would be (Member is any of Harry Potter) OR (Member List matches paid up junior members AND Age is between 14). This would return all members who were in the “paid up junior members” Member List and over the age of 14 as well as Harry Potter, even if he wasn’t over the age of 14 and in the “paid up junior members” Member List.

...

  1. The arrow next to the And/Or operator can be used to indent all criteria at that level and place it within a bracket. So if the arrow next to the Or in the example was pressed, this would be the outcome:

    Image Modified

  2. The “(….)” button will add an extra criterion that is indented from the current level. The example would become this when the button is pressed:

    Image Modified

Date Criteria

When using Dates as part of a Member List search criteria, you have several options of how to calculate this. All date inputs are always inclusive.

You can use “is between” where you will define 2 dates to look between, if either are left blank then this will be open-ended. In this example, the Member List will look for anyone who registered on or after 01/01/2020.

...

You can use “is relatively in between” to search a certain number of days from the current date (whenever the Member List is run) as opposed to between fixed dates. Negative numbers can be used to look in at the past, and positive numbers will look at the future from today. In this example, the Member List will look for anyone who registered in the the last 7 days.

...

You can use “not specified” to look for users where the date criteria is blank, this is most likely used to search for missing Dates of Birth within your members, such as the example below.

...

You can use “in week” to look for users where the date fell during the current week, last week, or the following week.

...

You can use “in month” to look for users where the date fell during the current month, last month, or the following month.

...

You can use “in quarter” to look for users where the date fell during the current quarter (3 months), last quarter, or the following quarter.

...

Ages Criteria

When using “Age” as a criterion in Member List searches, there are many options of how to calculate the age of each user. Each option sets a different date to use as the point from which the user’s age is calculated.

...

Tips and Tricks

Member Lists are self-updating meaning they will search the criteria at the time the Member List is run/used. For example, if searching for all members aged under 10, it will search on the day that the “Run” button is clicked. This could mean that the output could be different from one day to the next. To utilise this ability as much as possible, it is best to avoid hard-coding dates into the criteria where possible. Sometimes dates are necessary if you are looking at criteria within a date range, but using other criteria is advised.

The important thing to remember with Member Lists is that there can be many different ways of achieving the same results. This means that it is often worth having a try, and using the test run, and maybe even filtering the member directory Member Directory to try and get the result you are looking for.

...

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@76ab5187
sortmodified
showSpacefalse
reversetrue
typepage
cqllabel in ( "email" , "lists" ) and type = "page" and space = "CLUBSD"
labelsemail lists
Page Properties
hiddentrue

Related issues