Jen,
Try this
//WHEN PASS DO THIS:
var text CheckBox =
URLRoot() & "db/" & [_DBID_STATEMENT_JOB_HISTORY]
& "?act=API_EditRecord&rid="
& [Record ID#] & "&_fid_93=true";
var text EditRecord =
URLRoot() & "db/" & [_DBID_STATEMENT_JOB_HISTORY]
& "?act=API_EditRecord&rid="
& [Record ID#] & "&_fid_94=" & ToText(User())
& "&_fid_95=" & ToText(Now())
& "&_fid_90=In QC - 2nd Check"
& "&_fid_166=In QC - 2nd Check"
& "&_fid_167=In QC - 2nd Check"
& "&_fid_168=In QC - 2nd Check";
var text DisplayParent =
URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];
var text PASS = $CheckBox
& "&rdr=" & URLEncode($EditRecord)
& URLEncode("&rdr=" & URLEncode ($DisplayParent));
//WHEN FAIL DO THIS:
var text EditRecord =
URLRoot() & "db/" & [_DBID_STATEMENT_JOB_HISTORY]
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_166=FAILED 1st Check"
& "&_fid_179="
& "&_fid_183="
& "&_fid_93="
& "&_fid_28="
& "&_fid_29="
& "&_fid_30="
& "&_fid_31="
& "&_fid_32="
& "&_fid_33="
& "&_fid_34="
& "&_fid_35="
& "&_fid_36="
& "&_fid_37="
& "&_fid_38="
& "&_fid_39="
& "&_fid_40="
& "&_fid_41="
& "&_fid_42="
& "&_fid_43="
& "&_fid_44="
& "&_fid_45="
& "&_fid_46="
& "&_fid_47="
& "&_fid_48="
& "&_fid_49="
& "&_fid_50="
& "&_fid_51="
& "&_fid_52="
& "&_fid_53="
& "&_fid_54="
& "&_fid_55="
& "&_fid_56="
& "&_fid_57="
& "&_fid_58="
& "&_fid_59="
& "&_fid_60="
& "&_fid_61="
& "&_fid_62="
& "&_fid_63="
& "&_fid_64="
& "&_fid_65="
& "&_fid_66="
& "&_fid_67="
& "&_fid_68="
& "&_fid_69="
& "&_fid_70="
& "&_fid_71=";
var text DisplayParent =
URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];
var text EDIT = $EditRecord
& "&rdr=" & URLEncode($DisplayParent)
IF([my pass / fail field] = "Pass", $PASS, $FAIL)
Note that you will need to disable Application Tokens or else add a line of code to each edit.
& " &apptoken=xxxxxxxxx' where xxxxx is the application token.
