We did go through several iterations and split it up to do more. The formula executes still but ends at the error so we are leaning toward the redirect and java being the issue since it is a zero error. Here is what we have at this point(minus the button style)
var text URLOne = URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#] &
"&_fid_882=1";
var text URLTwo = URLRoot() & "db/"& [_DBID_Billing] & "?a=API_AddRecord" &
"&_fid_6=" & [Location ID] &
"&_fid_7=" & [Install Bill Amount] &
"&_fid_8=" & [Project ID] &
"&_fid_15=" & [Install Date] &
"&_fid_17=" & URLEncode([Installation Description]) &
"&_fid_19=" & [Type of Cancellation] &
"&_fid_20=" & [Install Bill Amount] &
"&_fid_22=" & [Address] &
"&_fid_23=" & [City] &
"&_fid_24=" & [State] &
"&_fid_25=" & [Postal Code] &
"&_fid_26=" & [County] &
"&_fid_27=" & [Country] &
"&_fid_28=" & [Related Project];
var text URLThree = URLRoot() & "db/"& [_DBID_Billing] & "?a=API_AddRecord" &
"&_fid_6=" & [Location ID]&
"&_fid_8=" & [Project ID]&
"&_fid_15=" & [Install Date]&
"&_fid_22=" & [Address]&
"&_fid_23=" & [City]&
"&_fid_24=" & [State]&
"&_fid_25=" & [Postal Code]&
"&_fid_28=" & [Related Project];
"<a " & $style & " href='"
& $URLOne
& "&rdr=" & URLEncode($URLTwo)
& URLEncode("&rdr=" & URLEncode($URLThree))
& "javascript:"
& ",function(){"
& ".location.reload(true);"
& "});"
& "void(0);"
&"'>The Button Issue</a>
