Forum Discussion

LandonSmallwood's avatar
LandonSmallwood
Qrew Member
24 days ago
Solved

Inspection Sheet Possibilities

I am attempting to build an inspection sheet that will state if the dimension entered is within the specified tolerance.  I have attached a screenshot of how I would like it to function, however afte...
  • MarkShnier__You's avatar
    MarkShnier__You
    15 days ago

    Admittedly they don't make it easy.

    try this

    var text MyNumber = ToText([Measurement]);

    var text NumberWithDecimalInTextFormat = $MyNumber

    & If(not Contains($MyNumber,"."),"."); // deal with an exact integer measurement

    var text IntegerPart = Left($NumberWithDecimalInTextFormat,".");

    var text DecimalPart = PadRight(Right($NumberWithDecimalInTextFormat,"."),3,"0");

    var text FinalResult = List(".", $IntegerPart, $DecimalPart);

     

    If([Ø 0.328]<=0.333 and [Ø 0.328]>=0.323,"<span style='font-size: 15pt; text-align: left; color: green'>" & $FinalResult & "</span>",

    [Ø 0.328]<0.323,"<span style='font-size: 15pt; text-align: left; color: red'>" & & $FinalResult & "</span>",

    [Ø 0.328]>0.333,"<span style='font-size: 15pt; text-align: left; color: red'>" & & $FinalResult & "</span>")