If then calculations across apps

Follow

Paul Lyet

• October 02, 2015 00:24

I'm trying to calculate hours in a work order based off of 2 calculation fields that will pull data from an associated app called time slips. Time slips has a duration field and a category field that will determine the "type" of billable hours. So in the work order we have a calc for "Programmer Hours" and "Technician Hours", when an employee is filling out a time slip the category field will determine where these hours calculate to. I'm thinking I would have to create a similar calculation in both fields in the WO. I'm on mobile right now so I won't even attempt what I would try but I'm curious if this can be done across apps.

0

• 

  Rainer Grabowski

  • October 02, 2015 10:20

  Hi Paul,

  for the 2 calculation fields in WO you can use:
  Field 1 for Programmers:

  var type = @all of category field;
  var dur = @all of duration field;
  
  var proghrs = 0
  for(var i = 0; i < type.length; i++){
  if(type[i] == "Programmer Hours"){
  proghrs += dur[i]
  }
  };
  

  Field 2 for Technicians:

  var type = @all of category field;
  var dur = @all of duration field;
  
  var techhrs = 0
  for(var i = 0; i < type.length; i++){
  if(type[i] == "Technician Hours"){
  techhrs += dur[i]
  }
  };
  

  Rainer
  rg@delos-consulting.com

  0

  Comment actions Permalink
• 

  Paul Lyet

  • October 02, 2015 14:12

  Rainer, Thank you for the quick response. I added it to my calculations and it works but I seem to be calculating "1" if not time is entered. Once a value has been added it works great.

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • October 02, 2015 16:23

  Can that happen that a duration field is empty? When a time slip is created both fields (type and duration) should have a value (even if the value is 0).
  If it can happen, that duration is empty, it can rise problems for the whole calculation. You can a avoid these issues by
  a) making the duration field a required field or
  b) creating a calcution field (e.g. called "Duration Mirror") in the Time slip app, which checks if the duration field is empty and then shows 0:

   @duration field == null ? 0 : @duration field
  

  And then use this field "Duration mirror" in the calcluation fields in WO: instead "@all of duration field" use "@all of duration mirror"

  Rainer
  rg@delos-consulting.com

  0

  Comment actions Permalink
• 

  Paul Lyet

  • October 02, 2015 22:54

  Thanks again Rainer.. The duration field is a required field as is the category field. I'm not sure what's up but for both Prog and Tech fields if there has not yet been a value associated it is showing 1.00.. Any ideas?

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • October 03, 2015 12:48

  You mean, if there's no time slip related then 1 is showed? Simply said it's a kind of error notification that the for-loop doesn't find any item.

  You can avoid it by adding this line (as last line in your calculation):

  type.length == 0 ? 0 : proghrs   
  

  respectively : techhrs

  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.