Skip to main content
Question

Button to Redirect to an Editable Form in Another App

  • August 2, 2023
  • 0 replies
  • 259 views

Hello,

I am trying to create a button that will redirect users to users to the same record in another app where they can edit information.

I've used several different formulas with partial success. Below is all relevant information:

Table ID I am trying to redirect to: btan5p92a?a?a

Matching Field ID in other app: 261

Examples formulas I have written utilizing the Formula-URL field type:

1) URLRoot() & "/db/btan5p92a?a?a" & "?act=API_EditRecordForm&_fid_261=" & [Project ID] & "&z=" & Rurl()

2)URLRoot() & "/db/btan5p92a?a?a" & Dbid() & "?a=API_EditRecord&rid=" & [Project ID] & "&rdr="&URLEncode(URLRoot() & "/db/btan5p92a?a?a" & Dbid() & "?a=doredirect&z=" & Rurl())

Both formulas redirect to the apps homepage, but not to the specific table or form. Is this possible to create? 



------------------------------
Sarah Driscoll
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • August 2, 2023

    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]



    ------------------------------
    Chayce Duncan
    ------------------------------
    Terms & ConditionsAccessibility statement