HI There,
Thank to Mark, I got mine working...you are welcome to try it.
var text URLONE = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] &
"&apptoken=65zusbcixqngsbqnkhn39juqdk" &
"&_fid_222=" & [Current Date and Time] ;
var text URLTWO = URLRoot() & "db/" & Dbid() & "?act=API_AddRecord" &
"&apptoken=65zusbcixqngsbqnkhn39juqdk"
& "&_fid_9=" & [Related Link Order]
& "&_fid_8=" & [Why do you want to reschedule Forecast Date?]
& "&_fid_28=" & [Related Link Build - Contractors]
& "&_fid_6=" & [Proposed Reschedule Forecast Date]
& "&_fid_53=" & [Which Link is scheduled?] &
"&rdr=" &
URLEncode(URLRoot() & "db/" & "bmjz2qva6" &
"?a=q&qid=21" &
"&z=" & Rurl());
$URLONE
& "&rdr=" & URLEncode($URLTWO)
URLONE - updates existing record, and URLTWO creates new record and redirect to report.