Forum Discussion

GeorgeBramhall1's avatar
GeorgeBramhall1
Qrew Member
3 years ago

Error in Formula URL ... Need help

I am getting the following error when I click my Formula URl button,Please, what am I doing wrong:

<qdbapi>
<action>API_EditRecord</action>
<errcode>30</errcode>
<errtext>No such record</errtext>
<errdetail>Missing "rid" parameter.</errdetail>
</qdbapi>

Formula:
var text urlone = If([Notify Acquisitions Team]<>"Yes",URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&_fid_15=Yes");
var text urltwo = "&rdr=" &
URLEncode(URLRoot()&[_DBID_LEADS]&"?a=Showpage&pageID=18")
;

$urlone & $urltwo


------------------------------
George Bramhall
------------------------------

8 Replies

  • 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's avatar
      GeorgeBramhall1
      Qrew Member
      Hi Mark,
      I actually do need to save some other edits before getting redirected. Isn't their a save record before redirecting function?
      Thanks
      G

      ------------------------------
      George Bramhall
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------