Skip to main content

I am doing work for a non-profit organization.


I have the following tables:

Members (company name, address, etc)

SocialMedia (FB, IG, YT, etc) <-- links to Members

Type (Potential, Regular, Associate etc) <-- links to Members


The SocialMedia table has a count field that totals how many Members have each SM platform. It looks something like this giving me the total of all Member types:

FB - 111

IG - 50

TY - 75


I would like a script that allows me to see the SocialMedia COUNT by Type. It can be either a group or filter option as long as I can see something like below.

Example:

Regular

FB - 10

IG - 5

YT - 3

Associate

FB - 15

IG - 6

YT - 5

Potential

FB - 7

IG - 3

YT - 0


Thank you for any direction you can offer.

Hi @Lenette_Egan - you can do this with a script, but you don’t need to - it can be done with regular fields using the new conditional rollups. If your members table is like this:



then, on your types table you can have this:



The FB field is a conditional rollup:




JB

Hi @Lenette_Egan - you can do this with a script, but you don’t need to - it can be done with regular fields using the new conditional rollups. If your members table is like this:



then, on your types table you can have this:



The FB field is a conditional rollup:




JB


OMG!!! That is perfect. Thank you so much 🙂


LJE

Reply


Terms & Conditions