Error in Formula URL ... Need help

Question

I am getting the following error when I click my Formula URl button,Please, what am I doing wrong:&lt;qdbapi&gt;

&lt;action&gt;API_EditRecord&lt;/action&gt;

&lt;errcode&gt;30&lt;/errcode&gt;

&lt;errtext&gt;No such record&lt;/errtext&gt;

&lt;errdetail&gt;Missing "rid" parameter.&lt;/errdetail&gt;

&lt;/qdbapi&gt;Formula:var text urlone = If([Notify Acquisitions Team]&lt;&gt;"Yes",URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp;"&amp;rid=" &amp; [Record ID#] &amp;"&amp;_fid_15=Yes");var text urltwo = "&amp;rdr=" &amp;URLEncode(URLRoot()&amp;[_DBID_LEADS]&amp;"?a=Showpage&amp;pageID=18");$urlone &amp; $urltwo------------------------------George Bramhall------------------------------

markshnier__you · Answer

I believe that you were trying to click a URL button on a record that has not yet been saved. If the record has not yet been saved, then the Record ID will be equal to null.

So I suggest just showing this button in view mode on the record.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

georgebramhall1 · Answer

Hi Mark,I actually do need to save some other edits before getting redirected. Isn't their a save record before redirecting function?ThanksG------------------------------George Bramhall------------------------------

markshnier__you · Answer

If the user is already in add mode just have them check the checkbox manually. But no, there is not an easy way to save the record, capture the rid and execute the URL.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

georgebramhall1 · Answer

Most importantly I need to redirect the user to a special page after saving. If the savebeforenavigating functionality won't work here is there any way that can just get redirected to this page after saving? Maybe I can use a form rule to accomplish the checkbox change.------------------------------George Bramhall------------------------------

markshnier__you · Answer

If you just have a button to navigate away from the record, and you have the table Advanced Properties set to save before navigating away, then it should save just with thisURLRoot() &amp; "db/" &amp; AppID() &amp; "?a=Showpage&amp;pageID=18"------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Error in Formula URL ... Need help

8 Replies