Sorry about that. Okay here is the code for Incomplaince and N/a they are the same.
If(
[# of Open FCE File Actions]<>0, "javascript:alert('There is an open action for this question. Please close out the question before marking question In Compliance')",
"javascript:" &
"$.get('" &
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=bg9b37dz5u7d4b8qz6gqcqq9wkr&_fid_11=In Compliance&rid=" & [Record ID#]&
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
)
and this is the formula text for Followup needed:
If(
[Compliance]="Follow-Up Needed", "javascript:alert('This question is already marked as Follow-Up Needed')",
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=bg9b37dz5u7d4b8qz6gqcqq9wkr&rid=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_ACTIONS] & "?a=nwr&_fid_63=" &[Record ID#]& "&_fid_38=" &[Related Children Assignment]& " &nextURL=" & URLEncode(URLRoot() & "db/" & [_DBID_REPORTS] & "?a=dr&rid=" & [Related Childrens Report]))
)
------------------------------
Maritza Acosta Gonzalez
------------------------------