Help

Need Help Scripting

Topic Labels: Scripting extentions
1580 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lenette_Egan
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

2 Replies 2

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:

Screenshot 2020-05-11 at 20.05.32

then, on your types table you can have this:

Screenshot 2020-05-11 at 20.08.02

The FB field is a conditional rollup:

Screenshot 2020-05-11 at 20.09.03

Screenshot 2020-05-11 at 20.09.12

JB

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

LJE