Issue with getting calculations and categories to work together

Follow

Matt Werner

• June 28, 2015 18:38

Hello everyone,

I am working on getting two apps to work together, one is an app for inputting requests, and the other is for the manager of those requests to view and work with.

I have both apps set up and working...except when I try and get them to fully communicate with each other. I want there to be a display in the manager's app that shows the open requests from the request app. Should be simple right? Well they are related to each other so I figure the calculation field will work best. Here is what I have so far:

if (@All of Completed Packet == 'No')
{'@All of Training Request for'}

else (@All of Completed Packet == 'Yes')
{'No Active Packets'}

The 'Complete Packet' field is a category with two options, either No or Yes. My formula works in returning the negative for the statement but not the positive side, basically my else works great, my if not so much. Did I make an error here that I can't see? Is there some magic way to get the category fields into calculations?

Thanks!!

Matt Werner

0

• 

  Matt Werner

  • June 28, 2015 22:36

  Nevemind this, Globiflow has solved all my issues.

  0

  Comment actions Permalink
• 

  Rainer Grabowski (FVM)

  • June 29, 2015 16:07

  Hi Matt,

  the solution for the Podio calculation field is:

  var packet = @All of Completed Packet;
  
  var packetYes = [];
  for(var i = 0; i < packet.length;i++){
  if(packet(i) == "Yes"){
  packetYes.push(packet[i](;
  }
  };
  
  var packetNo = [];
  for(var i = 0; i < packet.length;i++){
  if(packet(i) == "No"){
  packetNo.push(packet[i](;
  }
  };
  
  "**Yes-Packets:** \n" + 
   packetYes.join("\n") + "\n\n" +
  "**No-Packets:** \n" + 
  packetNo.join("\n") 
  

  The result is list like:
  Yes-Packets:
  A
  B
  C

  No-Packets:
  D
  E
  F

  If you wrap a string in double asterisks the sring will become bold (one asterisk before and after string = italic; thats markdown syntax whiich is supported by Podio in calculation fields, but also in chat, comments and app description, more here: http://daringfireball.net/projects/markdown/syntax#html

  \n indicates a line break.

  Rainer
  rg@delos-consulting.com

  0

  Comment actions Permalink

Please sign in to leave a comment.