Show_If, failing my formula

[trevorlipsey]

Hello,

I am working on an application for the company I work for,
It is a data collection app that takes the user input, evaluates the tolerances and measurements and then sends out an email if the measured point fails the tolerance check.

The issue I am running into is that when I measure certain checks with a certain frequency,
(First shot, Last Shot, 1x Shift), The application is skipping my formula and showing the points as if they didn't meet the criteria and failing resulting in a lot of failure emails.
I am trying to resolve this but I'm not really sure how.

I have reached out to appsheet and they said my formula was correct but it wasn't being evaluated due to it being too long, but the same formula was working perfectly fine until I added a show_if that is only supposed to evaluate only certain checks if the frequency conditional had been met.

//This is the code for the reaction plan to fire, the reaction plan
//is a thing our company uses when a failure is pressent 
OR(
  OR(
    [Data Field Var 1] >= [Tool].[Tolerance Var POS 1], 
    [Data Field Var 1] <= [Tool].[Tolerance Var NEG 1]),
  OR(
    [Data Field Var 2] >= [Tool].[Tolerance Var POS 2], 
    [Data Field Var 2] <= [Tool].[Tolerance Var NEG 2]),
  OR(
    [Data Field Var 3] >= [Tool].[Tolerance Var POS 3], 
    [Data Field Var 3] <= [Tool].[Tolerance Var NEG 3]),
  OR(
    [Data Field Var 4] >= [Tool].[Tolerance Var POS 4], 
    [Data Field Var 4] <= [Tool].[Tolerance Var NEG 4]),
  OR(
    [Data Field Var 5] >= [Tool].[Tolerance Var POS 5], 
    [Data Field Var 5] <= [Tool].[Tolerance Var NEG 5]),
  OR(
    [Data Field Var 6] >= [Tool].[Tolerance Var POS 6], 
    [Data Field Var 6] <= [Tool].[Tolerance Var NEG 6]),
  OR(
    [Data Field Var 7] >= [Tool].[Tolerance Var POS 7], 
    [Data Field Var 7] <= [Tool].[Tolerance Var NEG 7]),
  OR(
    [Data Field Var 8] >= [Tool].[Tolerance Var POS 8], 
    [Data Field Var 8] <= [Tool].[Tolerance Var NEG 8]),
  OR(
    [Data Field Var 9] >= [Tool].[Tolerance Var POS 9], 
    [Data Field Var 9] <= [Tool].[Tolerance Var NEG 9]),
  OR(
    [Data Field Var 10] >= [Tool].[Tolerance Var POS 10], 
    [Data Field Var 10] <= [Tool].[Tolerance Var NEG 10]),
  OR(
    [Data Field Var 11] >= [Tool].[Tolerance Var POS 11], 
    [Data Field Var 11] <= [Tool].[Tolerance Var NEG 11]),
  OR(
    [Data Field Var 12] >= [Tool].[Tolerance Var POS 12], 
    [Data Field Var 12] <= [Tool].[Tolerance Var NEG 12]),
  OR(
    [Data Field Var 13] >= [Tool].[Tolerance Var POS 13], 
    [Data Field Var 13] <= [Tool].[Tolerance Var NEG 13]),
  OR(
    [Data Field Var 14] >= [Tool].[Tolerance Var POS 14], 
    [Data Field Var 14] <= [Tool].[Tolerance Var NEG 14]),
  OR(
    [Data Field Var 15] >= [Tool].[Tolerance Var POS 15], 
    [Data Field Var 15] <= [Tool].[Tolerance Var NEG 15]),
  OR(
    [Data Field Var 16] >= [Tool].[Tolerance Var POS 16], 
    [Data Field Var 16] <= [Tool].[Tolerance Var NEG 16]),
  OR(
    [Data Field Var 17] >= [Tool].[Tolerance Var POS 17], 
    [Data Field Var 17] <= [Tool].[Tolerance Var NEG 17]),
  OR(
    [Data Field Var 18] >= [Tool].[Tolerance Var POS 18], 
    [Data Field Var 18] <= [Tool].[Tolerance Var NEG 18]),
  OR(
    [Data Field Var 19] >= [Tool].[Tolerance Var POS 19], 
    [Data Field Var 19] <= [Tool].[Tolerance Var NEG 19]),
  OR(
    [Data Field Var 20] >= [Tool].[Tolerance Var POS 20], 
    [Data Field Var 20] <= [Tool].[Tolerance Var NEG 20]),
  OR(
      [Data Field Attr 1]="Nogo",
      [Data Field Attr 2]="Nogo",
      [Data Field Attr 3]="Nogo",
      [Data Field Attr 4]="Nogo",
      [Data Field Attr 5]="Nogo",
      [Data Field Attr 6]="Nogo",
      [Data Field Attr 7]="Nogo",
      [Data Field Attr 8]="Nogo",
      [Data Field Attr 9]="Nogo",
      [Data Field Attr 10]="Nogo",
      [Data Field Attr 11]="Nogo",
      [Data Field Attr 12]="Nogo",
      [Data Field Attr 13]= "Nogo",
      [Data Field Attr 14]= "Nogo",
      [Data Field Attr 15]="Nogo",
      [Data Field Attr 16]="Nogo",
      [Data Field Attr 17]="Nogo",
      [Data Field Attr 18]="Nogo",
      [Data Field Attr 19]="Nogo",
      [Data Field Attr 20]="Nogo"
      ),
  [Part Out With Deviation?]="Yes"
)

And here is the show_if for the measurement points:

//This is the code to Show_if the point

AND([Tool].[Type 1] = "Var",

  IN(
   [Frequency],
   [Tool].[Frequency 1]
  )
)

//Here is the Required? 
ISNOTBLANK([Data Field Var 1])

//Here is the display name code
IF(
  ISNOTBLANK([Tool].[Hand 1]),
  [Tool].[Hand 1] & ":" & " " & "Upper Tolerance: " & " " & [Tool].[Tolerance Var POS 1] & " " & "Lower Tolerance: " & [Tool].[Tolerance Var NEG 1],
  "Upper Tolerance: " & " " & [Tool].[Tolerance Var POS 1] & " " & "Lower Tolerance: " & [Tool].[Tolerance Var NEG 1]
)

 If you have any question please let me know! 

https://www.appsheet.com/Template/AppDef?appName=G0700EDAC-4034895&utm_source=share_app_link