Need Help Scripting

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.
FB - 10
IG - 5
YT - 3
FB - 15
IG - 6
YT - 5
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:



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


1 Like