Here would be the proper syntax it seems of what you're trying to do:
var text urlOne = URLRoot() & "db/btan5p92a?a=API_EditRecordForm&_fid_261=" & [Project ID];
var text urlTwo = URLEncode(URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Project ID] & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()));
$urlOne & $urlTwo
But it also seems like you still have a little work to do if you're trying to redirect. The actual button above is actually trying to do an API Edit Record call in both apps - but neither is actually doing that properly. If thats the case, you'll need to provide more _fid_ parameters for what info you're actually attempting to change.
If your goal is just a redirect to a different app with the same record id # - then the syntax you should use is:
URLRoot() & "db/" & "btan5p92a?a=er&rid=" & [Project ID]
When I use that last formula, I get an error that the record can't be found but I know it is there.
The records id #'s are different from table to table but the Project ID #'s are the same and are the key's in both apps. is there anything additional that would need to be written into it?
Yep - if Project ID is the key then you can use the same formula but instead do:
URLRoot() & "db/" & "btan5p92a?a=er&key=" & [Project ID]
In this case you're swapping out rid with key
Wow...way easier of a formula than I was trying!
Thank you so much! It is working perfectly :)
