Sequential Operations in Formula fields.

This is the generic syntax for sequential URL API calls.  Just slice off as much of the salami as you need.  

$URLONE
& "&rdr=" & URLEncode($URLTwo)
& URLEncode("&rdr=" & URLEncode($URLThree))
& URLEncode(URLEncode("&rdr=" & URLEncode($URLFour)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFive))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSix)))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSeven))))))
& URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLEight)))))))
& URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLNine))))))))
& URLENcode(URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLTen)))))))))

For example this is one with three steps

var text URLONE = URLRoot() & "db/" & [_DBID_FOCUS_INVOICE]
& "?act=API_EditRecord&rid=1"
& "&_fid_6=" & ToText([Record ID#])
& "&_fid_9=" & ToText([Related Client]);

var text URLTWO = URLRoot() & "db/" & [_DBID_TIME_RECORDS]
& "?act=API_RunImport&ID=11";

var text URLTHREE = var text RefreshPage =  URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

If([# of Time Records]=0,
$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
)


Note that the last step is syntax to refresh the page.  The last step of these type for formula needs to land the user on a record or a report or a Page.  It's useful to have this code so that the same button can be used on a report or a record.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------