I have a request from my users of Zoho CRM.

We have created Canvas views for our modules to make navigation easier. One of the canvas views is for a custom Groups module. We have clients (Contact records) that belong to groups. Those groups are managed by an employee facilitator. When a group member leaves a group we change the member's status to indicate they are no longer participating. We don't remove them from the group because we want to have a history of group participation, therefore the status field indicates this.

When our facilitators view their group details the list of members (related Contact records) they see all members regardless of their status. The facilitators want the list filtered so they only see the active members in the Canvas view. To add to the complication, our admin staff wants to see both active and former members but would like a way to filter the view dynamically so they can choose to see members based on status, or all members.

The modules involved are, Groups, Contacts, and a linking module, Groups/Contacts. The Groups module has a field called "members" that links to a field in the Contacts module called "memberships" (Contacts can belong to more than one group. this allows the contact detail record to show all the groups they may belong to).

The Canvas view for Groups displays the group's members in the group detail view (i.e. we click on a group in the list view then see the group members in the group detail view). The members field was just dropped onto the Canvas view and formatted. The Canvas view does everything necessary to display the contacts assigned to the group but we can't see a way to filter what is visible.

I've looked at the Canvas options for the members field and can't figure out a way to filter what it displays. It appears it can't be done without writing a client script - which is not a problem. I've written dozens of Deluge scripts though I've never written client scripts. So, the question is, is it possible to write a client script that can filter the display of group member field?

If so, please direct me to a resource that might show how to do something like this.