Want a link / button to download a file after creating log using API_AddRecord

Thanks very much for this but I am still having problems 

Problem 1
When I put you code into the field I get a Formula syntax error

The argument list of the function rdr must begin with a left parenthesis.


var text URLONE = URLRoot() & "db/" & [_DBID_ACCESS_LOGS] & "?act=API_AddRecord" & "&_fid_6=" & ToText([Record ID#]);

var text URLTWO = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#]& "/e7/v0\"; 

$URLONE 
& "&rdr  =" & URLEncode($URLTWO) 

Problem 2
When I deconstruct your code and put it into a URL I still get delivered the xml response and it does not go on to download the actual file.

This is the key thing I am trying to achieve i.e. first create the log (which the first URL does successfully) and THEN download the file.