Button help on formula text

Last year we made and finished an app for our company. And while we knew our information might change or be added to we knew it would never be truly finished. So it wasn't until yesterday when I was a...

APIs and custom code

Formulas and functions

javascript

MarkShnier__You

Qrew Legend

Please post your actual code by copy paste. We cannot edit images.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

MarkShnier__You

Qrew Legend

4 years ago

Try these

var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();
var text EDIT = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=bg9b37dz5u7d4b8qz6gqcqq9wkr&_fid_11=In Compliance&rid=" & [Record ID#];

If(
[# of Open FCE File Actions]<>0,
$EDIT
& "&rdr=" & URLEncode ($RefreshPage))

and this is the formula text for Followup needed:

If([Compliance]="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]))
)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Forum Discussion

Button help on formula text