Discussions

Expand all | Collapse all

Missing "rid" parameter.

  • 1.  Missing "rid" parameter.

    Posted 04-06-2020 06:12
    i have created one formula (button) which updated the checkbox to checked and  redirect to the new custom page.
    URLRoot() & "db/" & Dbid() &"?a=API_EditRecord&rid="& URLEncode ([Record ID#])& "&_fid_24=" & URLEncode("true") & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid()&"?a=dbpage&pageID=4") 

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



    ------------------------------
    preeti verma
    ------------------------------


  • 2.  RE: Missing "rid" parameter.

    Posted 04-06-2020 07:25
    The formula looks correct.

    But, are you trying to push the button when in ADD mode before the Record ID# exists?

    What does the URL say when you push the button?  Is it trying to edit rid=0


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



  • 3.  RE: Missing "rid" parameter.

    Posted 04-06-2020 12:51
    Thanks for your reply.

    I am trying to add new record using  below form.


    Here I have 2 cases : 
    1. When Record (First Name , Last Name and Email ID) already exists/saved in table :- In this case my formula is working fine.
    2. When Record does not exist :- Here formula is not working.

    My question is :-

    How can we add the Record with  "ticked" checkbox and redirect it to new custom page.  

    I tried to use API_AddRecord to save the data in table and then redirect it to another page but in this case it is  adding 4 separate records in table.
    Can we use this ADD API to get the desired output. 

    URLRoot() & "db/" & dbid() & "?a=API_AddRecord&_fid_24=1" [Record ID#] &
    "&_fid_34=&[First Name]& " &
    "&_fid_35=&[Last Name]& " &
    "&_fid_36=&[Email Address]& " 

    Thanks

    ------------------------------
    preeti verma
    ------------------------------



  • 4.  RE: Missing "rid" parameter.

    Posted 04-06-2020 12:57
    Your partial formula to add a record does look correct. 
    Can you post the whole formula with the redirect to the page?   It should not be creating 4 records.

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



  • 5.  RE: Missing "rid" parameter.

    Posted 04-06-2020 13:22
    I am using below formula :

    URLRoot() & "db/" & dbid() & "?a=API_AddRecord&_fid_24=1" & URLEncode ([Record ID#]) &
    "&_fid_34=&[First Name]& " &
    "&_fid_35=&[Last Name]& " &
    "&_fid_36=&[Email Address]& " & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid()&"?a=dbpage&pageID=2")
    It is creating two record 
    first is for checkbox (record id 44)
    second  is for first name ,second name and email address (record id=43)

    image.png






  • 6.  RE: Missing "rid" parameter.

    Posted 04-06-2020 13:27
    Try with these corrections

    URLRoot() & "db/" & dbid() & "?a=API_AddRecord
    & "&_fid_24=1"
    "&_fid_34=" & URLEncode([First Name])
    & "
    &_fid_35=" & URLEncode([Last Name])
    &
    "&_fid_36=" & URLEncode([Email Address])
    & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid()&"?a=dbpage&pageID=2")


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



  • 7.  RE: Missing "rid" parameter.

    Posted 04-07-2020 02:07
    no still having same issue 
    image.png
    it is creating record it 49 for checkbox and create another record id 48 for first ,last name and email address 





  • 8.  RE: Missing "rid" parameter.

    Posted 04-07-2020 05:15
    Hi 
    i tried  to troubleshoot from the beginning of  my workflow whichi  found the issue with my  below  API 
    API_URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" &[Record ID#]&  "&_fid_18=1"& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) 

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





  • 9.  RE: Missing "rid" parameter.

    Posted 04-07-2020 07:37
    The string should not have the API at the beginning.

    URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" &[Record ID#]&  "&_fid_18=1"& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) 

    But are you trying to edit a record that has not yet been initially saved?


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



  • 10.  RE: Missing "rid" parameter.

    Posted 04-07-2020 07:50
    Try changing the ending to this

    &"?a=ShowPage&pageID=2")

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



  • 11.  RE: Missing "rid" parameter.

    Posted 04-07-2020 10:54
    yes i was trying to edit the record that has not been saved in the table. so i changed my approach via Quickbase  Action so now its working fine.  

    but i have one issue how can i send the email notification to a specific column value (stored the email address)





  • 12.  RE: Missing "rid" parameter.

    Posted 04-07-2020 11:20
    When  you make a Notification of type Open, while it does not seem to be documented, in fact you can just paste in a list of fields (I do them vertically) containing the fields of type email that have the email addresses.  Each field must only have one email address, not a list of email addresses.

    so for example in the email who box, type

    [email field 1]
    [email field 2]
    [email field 3]


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



  • 13.  RE: Missing "rid" parameter.

    Posted 04-08-2020 04:15
    Hi mark,

    how can i disable or hide the  submit the request column i want only button  to display.
    image.png





  • 14.  RE: Missing "rid" parameter.

    Posted 04-08-2020 08:39
    If you edit the FORM properties for where that field is on the form, you can override the field heading words by a checkbox, but then leave the words blank.

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



  • 15.  RE: Missing "rid" parameter.

    Posted 04-08-2020 09:22
    Do i need to create one checkbox and add the rule on checkbox ?
    Could you please  elaborate more.





  • 16.  RE: Missing "rid" parameter.

    Posted 04-08-2020 09:28
    Just view any record or get into Add mode to add a record.
    click at the top right in Customize this Form

    locate the field on the form

    observe the checkbox to use Alternate Label Text

     Check the box but leave the words blank to override the heading to blank.

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



  • 17.  RE: Missing "rid" parameter.

    Posted 07-01-2021 10:29
    Good morning!

    I'm having a similar issue.  When creating a new record I want to be able to add a Label PO and change the Status field to "Labels Ordered".  The status field is a drop-down box.  I'm guessing it's due to the record being new is why my formula does not work.

    URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Order ID#]

    & "&_fid_28="&URLEncode("Labels Ordered") &"&RDR="&URLEncode(

    URLRoot() & "db/" & [_DBID_LABEL_PURCHASE_ORDERS] & "?a=API_GenAddRecordForm&_fid_25=" & URLEncode ([Order ID#]) & "&z=" & Rurl())

    ------------------------------
    Bryan Fichtner
    ------------------------------



  • 18.  RE: Missing "rid" parameter.

    Posted 07-01-2021 13:17
    I suggest that you use a Dynamic Form Rule

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



  • 19.  RE: Missing "rid" parameter.

    Posted 27 days ago
    That's the biggest give-up answer ever. How would a dynamic form rule add a new record and change certain fields?

    Here is what I'm trying to.

    I add an Order PO, to that purchase order I add a Label PO, and when I add the new Label PO to the Order I need it to change the Status field (drop-down field) to Labels Ordered.

    ------------------------------
    Bryan Fichtner
    ------------------------------



  • 20.  RE: Missing "rid" parameter.

    Posted 27 days ago
    Re: That's the biggest give-up answer ever. How would a dynamic form rule add a new record and change certain fields?

    The question was that the user was already in Add Mode for manually entering an (unsaved) record and wanted a button to check a box to checked.  That did not make sense to me as an "ask" as the user could just check the box manually instead of pushing a button or else use a dynamic form rule to auto check the box if some conditions were true.

    As for your question, I suggest using an Automation or Pipeline.

    The Trigger would be that a label PO Record is added, and the Parent Order PO status field (looked up own to the Label PO record) is not "Labels Ordered".

    The Action would be modify the Order PO where the filter is that the  [Record ID#] matches the [Related Order of the  "trigger record" and set the status to Labels Ordered.

     


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