Counting Number of Relationships

Answered

Follow

Matthew Manus

• August 05, 2015 01:02

I 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?

0

• 

  Andreas Garnæs

  • August 06, 2015 14:43

  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

  1

  Comment actions Permalink
• 

  Matthew Manus

  • August 11, 2015 22:51

  Thanks Andreas, that was just what I was trying to accomplish!

  0

  Comment actions Permalink
• 

  Maciej Michalak

  • February 04, 2016 00:18

  Im trying to do the same thing and i have my leads associated with my campaign but when I try the @All of Name I get an error

  "The script returned an unsupported result type"

  0

  Comment actions Permalink
• 

  Andreas Garnæs

  • February 04, 2016 09:19

  Hi Maciej, your script needs to look like this: "@All of Name.length" -- it sounds like the ".length" could be missing?

  1

  Comment actions Permalink

Please sign in to leave a comment.