membership directory listing

[vantuykom]

Hi,

I am working for a charity organisation, and they want to have a directory listing based on the number of contacts a certain individual brings on.

I use a contact reference field to get the info of the referenced contact in a profileform on user registration like:

name:
firstname:
email:
referenced by:

now I want to have a directory listing where the individuals that have the most referenced contacts are on top

how can I do this?

kind regards
Natascha

[petednz]

hi natascha
i would probably try pulling this together in views first where you should be able to 'aggregate' and get the 'count' of those - IF contact reference field has been woven in to the Views code.

The other option on civi side would be to see if Relationships can do what you want instead of the contact reference field - and then aggregate those in Views.

If you don't know Views it can be a bit of a struggle even knowing whether to start with a View based on 'civi contacts' or 'civi relationships' - and then adding in the Views Relationships to join all the bits together

But if you do know views, you might get what you need without actually coding anything ;-)

otherwise some brighter spark will come along with a suggestion on how to do a Custom civi Report I expect

[vantuykom]

Hi,

I was experimenting with views already, but I am not able to get out what I want...
is there a way to use https://www.drupal.org/project/entityreference_count for this? because this is exactly the functionality I need...

[petednz]

never used that - have you looked at whether it can work for you alongside https://www.drupal.org/project/civicrm_entity

[petednz]

i doubt it.

want to flesh out which Views route you took? And can Relationships be used for you instead of contact reference?

[vantuykom]

I started in the relationships area, but had other issues there...
when a contact fills in the registration form, I want them to create a drupal user on the fly... with civicrm-webform, I can make a relationship, but I can not create a drupal user...

I'm not a coder, so, unless someone gives me step by step instructions on how to set php in rules to create that user when they fill in the form, I am nowhere...

regards