Calculation field not updating

Follow

Andrew Thibault

• June 21, 2019 17:26

I know I must be missing something obvious, but for some reason only the first calc field below ("DaysToStart")  is updating despite the fact that the second field "(InView") is dependent on the first. The value for InView is right in the preview, but the acutal value is not getting updated. @Max of Today is a reference to a field in a Time app that gets updated nightly by GF. Thanks in advance for any ideas.

0

• 

  Rainer Grabowski

  • June 25, 2019 19:54

  Hello Andrew,

  in the field "InView" you've an incomplete code, it's a part of an if clause. But you don't  tell the code what to do if the IF is true or false. 
  What you have written you must read as: 
  If DaysToStart is between 0 and 7 OR if DaysToStart is equal to -999 OR if NTJB is equal to Yes ... 
  now must follow: Than show this ELSE show that. 
  The syntax for that is 
  conditon ? show this : show that
  
  The zero in the preview is shown cause the field is empty, it's not a result. 

  Rainer 

  1

  Comment actions Permalink
• 

  Andrew Thibault

  • June 25, 2019 22:24

  Thanks Rainier. This has been driving me crazy. I knew it was something obvious but I could not for the life of me figure it out. Your contributions to this forum and the GF forum are invaluable.

  0

  Comment actions Permalink

Please sign in to leave a comment.