Can I calculate the number of related items that are equal to two different fields in the related item?

Follow

Daniel Horne

• December 24, 2017 19:34

Hi, I'm wondering how I can calculate the number of related items that are equal to two different fields in the related item. For example, if I want to only count items that have a known cost (driver cost category field) and are marked as a lead (status category field).

0

• 

  Rainer Grabowski

  • January 06, 2018 12:19

  Hi Daniel,

  var cost = @all of driver cost;
  var status = @all of status;
  var c = 100;
  var s = "Lead";
  var  count = 0;
  for(var i = 0; i < cost.length; i++){
  if(cost[i] == c && status == s){
  count += 1;
  }
  };
  count

  Rainer

  1

  Comment actions Permalink
• 

  Victor Gabriel Santos Silva

  • January 22, 2018 07:06
  • Edited

  Hi Rainer, I'm sorry about my ignorance, but where in Podio can I use this kind of programming? I only know how to use the interface.

   

  Thanks in advance!

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • January 23, 2018 10:08
  • Edited

  Hi Victor,

  in a Calculation field in the app template. You must have admin rights in the workspace.
  App template: https://help.podio.com/hc/en-us/articles/201019578-Modifying-app-templates
  Calculations:https://help.podio.com/hc/en-us/articles/201019358-Calculations

  Rainer

  1

  Comment actions Permalink
• 

  Victor Gabriel Santos Silva

  • January 24, 2018 22:02

  Thanks Rainer! I used the Calculation field before, I just didn't know more "complex" programming could be used there, thought only calls for variables. This seems to be one of the most powerful tools then!

  0

  Comment actions Permalink

Please sign in to leave a comment.