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------------------------------

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

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------------------------------

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

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)------Original Message------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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Missing "rid" parameter. | Qrew Discussions

MarkShnier__You
Qrew Legend
5 years ago
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
------------------------------
- preetiverma1
  Qrew Member
  5 years ago
  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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    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
    ------------------------------

Forum Discussion

Missing "rid" parameter.