Relationship calculation between 2 apps

Follow

Richard Hedger

• November 29, 2016 13:43

Dear All,

Podio is driving me nuts today.

 

I have two apps ESTIMATES and ACCOUNTS.

The ACCOUNT app sorts estimated sums on money contained within the ESTIMATES.

I have used javascript elsewhere in my apps that do the same thing without any problems but here it is simply not working.

Here is the screenshot of the calculation field in ACCOUNTS

Here is one of my estimates in the ESTIMATES app. 

 

Here is the result in the ACCOUNT item. The "Estimated Amount - VAT Incl." should read CHF 124'200 and not 0.0. Does then anyone know what is not working? I should mention that these apps have been added then deleted etc, so I'm wondering if there aren't some parasitic elements preventing the calculation from working.

0

• 

  Rainer Grabowski

  • November 30, 2016 07:55

  Hi Richard,

  you calculation is wrong. The var estimate must be @all of...  not @sum of ...

  Rainer 

  0

  Comment actions Permalink
• 

  Siddharth Srinivasan

  • December 14, 2016 05:46

  Hi Guys,

  var GRI = @All of Greeting and addressing the respondent a ; // Text items in another app and that app contains just one row and no more rows will be added
  var GRA = @All of Greeting and Addressing the Respondent; // Text items in another app and that app contains just one row and no more rows will be added
  var Item = @Line Item; //Text field in this app
  var Defect = 0;

  for(i=0;i<=3;i++)
  {
  if(Item == GRI)
  {
  Defect == GRA

  }
  }
  GRI

  Here im trying to compare 'GRI' and ' Item ' which are both text fields and display GRI, ideally i would want to display 'Defect' however if 'GRI' doesent populate then the calculation in the if will fail.

  My problem is GRI is a text field in another app and is not being displayed for some reason (i have tried putting GRI[i] and also tried converting the @ all of to string , on converting to string it takes the code but no output and without conversion it wont take the code and say undefined result type ...please help

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • December 18, 2016 13:56

  Hi Siddharth,

  I'm not sure if I understand waht you want to achieve. Some questions:

  1. Are GRI and GRA different apps?
  2. Is there more than one GRI or more then one GRA item related to the app A (where the calculation field is in) or always only 1?
  3. Why do you use <=3 in the for-loop?
  4. What should be the result if item == GRI and what if item != GRI?

  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.