Need Help Scripting

[Lenette_Egan]

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.

[JonathanBowen]

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

[Lenette_Egan]

OMG!!! That is perfect. Thank you so much :slightly_smiling_face:

LJE