URL Redirect

Question

When doing an API_EditRecord in a Rich Text format, we would like to know how to end it, with a outside website and not an internal website. We would be happy to use a url field if it will work also.?

Right now here is our working code that redirects to our Quickbase

var text URL=URLRoot() & "db/"& Dbid()& "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&usertoken=XXXXXXXXXXXXXXXXXXXXXXXXXXX" &
"&_fid_27=Approve";
"&rdr="&
URLEncode(URLRoot());

"<a href=" & $URL & "\" " & $stylebtn & " >Click to Approve</a>"

------------------------------
Michael Knecht
------------------------------

markshnier__you · Answer

var text URL=URLRoot() &amp; "db/nn77nnnnn?a=API_AddRecord&amp;_fid_36=" &amp; URLEncode([Record ID#])
&amp; "&amp;_fid_6="&amp;Now()
&amp; "&amp;_fid_7="&amp;Now()
&amp; "&amp;_fid_15=11"
&amp; "&amp;_fid_72="&amp; [Project - Customer]
&amp; "&amp;_fid_53=51";
"&amp;rdr="&amp;URLEncode(URLRoot())​​
but kill the last line where starts with "&amp;rdr= ....and replace with thisvar text RefreshPage = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; Rurl();$URL&amp; "&amp;rdr=" &amp; URLEncode($RefreshPage)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

markshnier__you · Answer

Try changing the redirect part at the end.&amp;rdr="&amp;URLEncode("www.google.com")------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

michaelknecht · Answer

https://firstclassvending.quickbase.com/db/www.google.com

This is the url it sent to the browser.

This is the end result 404 error

------------------------------
Michael Knecht
------------------------------

markshnier__you · Answer

try this&amp;rdr="&amp;URLEncode("http://www.google.com")If that does not work i will test myself.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

michaelknecht · Answer

XML Error pagehttps://firstclassvending.quickbase.com//db/brytzcww6?a=API_EditRecord&amp;rid=75&amp;usertoken=xxxxxxxxxxxxxxxx&amp;_fid_27=Submitted&amp;rdr=http%3A%2F%2Fwww.google.comthe above ends up being the urlthe below is the code on the page&nbsp;&lt;action&gt;API_EditRecord&lt;/action&gt;

&lt;errcode&gt;0&lt;/errcode&gt;

&lt;errtext&gt;No error&lt;/errtext&gt;

&lt;rid&gt;75&lt;/rid&gt;

&lt;num_fields_changed&gt;1&lt;/num_fields_changed&gt;

&lt;update_id&gt;1648220214425&lt;/update_id&gt;

&lt;/qdbapi&gt;It always succeeds in changing the field to the Approved, but the end page is tricky.&nbsp; Two or three threads have ended in agreeing that its a quickbase setting that doesnt allow a change and then an outside page to load.------------------------------Michael Knecht------------------------------

Forum Discussion

URL Redirect

8 Replies