Counting Number of Relationships
AnsweredI have three apps:
(1) Leads
(2) Marketing Campaigns
(3) Stats
For each Lead I get (1), I have a relationship field to assign where the lead came from (2).
In order to understand the marketing campaigns (2) for where our leads (1) our coming from, I am trying to link this data to the stats (3) app.
For instance, John Smith and Jim Smith were leads created from Marketing Campaign #1. So in one of my relationship fields in my lead app, I select Marketing Campaign #1 as the source of the lead. In the Stats app, for Marketing Campaign #1, I would like it to show a count of 2 (John Smith and Jim Smith).
How do I link this data?
-
Hi Matthew,
If you link leads to marketing campaigns, then you can simply add a calculation field to the marketing campaigns app to get a count of the related leads. Assuming there's a "Name" field on leads, the calculation needs to be something like this "@All of Name.length".
Does that help?
Best,
Andreas
Please sign in to leave a comment.
Comments
4 comments