Button to Redirect to an Editable Form in Another App

Question

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() &amp; "/db/btan5p92a?a?a" &amp; "?act=API_EditRecordForm&amp;_fid_261=" &amp; [Project ID] &amp; "&amp;z=" &amp; Rurl()
2)URLRoot() &amp; "/db/btan5p92a?a?a" &amp; Dbid() &amp; "?a=API_EditRecord&amp;rid=" &amp; [Project ID] &amp; "&amp;rdr="&amp;URLEncode(URLRoot() &amp; "/db/btan5p92a?a?a" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; Rurl())

Both formulas redirect to the apps homepage, but not to the specific table or form. Is this possible to create?&nbsp;------------------------------Sarah Driscoll------------------------------

chayceduncan · Answer

Here would be the proper syntax it seems of what you're trying to do:&nbsp;&nbsp;
var text urlOne = URLRoot() &amp; "db/btan5p92a?a=API_EditRecordForm&amp;_fid_261=" &amp; [Project ID];
var text urlTwo = URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord&amp;rid=" &amp; [Project ID] &amp; "&amp;rdr="&amp;URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; Rurl()));

$urlOne &amp; $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.&nbsp;

If your goal is just a redirect to a different app with the same record id # - then the syntax you should use is:

URLRoot() &amp; "db/" &amp; "btan5p92a?a=er&amp;rid=" &amp; [Project ID]------------------------------Chayce Duncan------------------------------

sarahdriscoll1 · Answer

When I use that last formula, I get an error that the record can't be found but I know it is there.&nbsp;
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?------------------------------Sarah Driscoll------------------------------

chayceduncan · Answer

Yep - if Project ID is the key then you can use the same formula but instead do:&nbsp;
URLRoot() &amp; "db/" &amp; "btan5p92a?a=er&amp;key=" &amp; [Project ID]

In this case you're swapping out&nbsp;rid&nbsp;with&nbsp;key------------------------------Chayce Duncan------------------------------

sarahdriscoll1 · Answer

Wow...way easier of a formula than I was trying!

Thank you so much! It is working perfectly :)------------------------------Sarah Driscoll------------------------------

chayceduncan · Answer

No problem!

For context and to expand on my first response, your original formula was attempting to do API_EditRecord calls which would mean you would actually be changing something in both records. Form navigation as of now is er (edit record) and dr (display record) and so your syntax is db/dbid?a= and then er or dr.

You would pivot over to the API_EditRecord if you wanted someone to click a button and actually change something like checking a box or providing a date with a button click.&nbsp;------------------------------Chayce Duncan------------------------------

Forum Discussion

Button to Redirect to an Editable Form in Another App