Missing "rid" parameter.

Question

i have created one formula (button) which updated the checkbox to checked and&nbsp; redirect to the new custom page.URLRoot() &amp; "db/" &amp; Dbid() &amp;"?a=API_EditRecord&amp;rid="&amp; URLEncode ([Record ID#])&amp; "&amp;_fid_24=" &amp; URLEncode("true") &amp; "&amp;rdr=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid()&amp;"?a=dbpage&amp;pageID=4")&nbsp;but i got rid parameter error.
&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;
------------------------------preeti verma------------------------------

laurathacker · Answer

Normally you can encode true/false values as 1 or 0.
You also might need an apptoken if your application has apptokens turned on.

Try this instead:

URLRoot() & "db/" & Dbid() &"?act=API_EditRecord&rid="& URLEncode ([Record ID#])
& "&_fid_24=1"
& "&rdr=" & URLEncode(
URLRoot() & "db/" & Dbid( )& "?a=dbpage&pageID=4")

with an AppToken (where xxxx is the application token value):

URLRoot() & "db/" & Dbid() &"?act=API_EditRecord&apptoken=xxxxxxxx&rid="& URLEncode ([Record ID#])
& "&_fid_24=1"
& "&rdr=" & URLEncode(
URLRoot() & "db/" & Dbid( )& "?a=dbpage&pageID=4")

------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------

preetiverma1 · Answer

i did not turn on the application&nbsp;token&nbsp;URLRoot() &amp; "db/" &amp; Dbid() &amp;"?act=API_EditRecord&amp;rid="&amp; URLEncode ([Record ID#])&amp; "&amp;_fid_24=1"&amp; "&amp;rdr=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid( )&amp; "?a=dbpage&amp;pageID=4")&nbsp; &nbsp;this code also gave me same error.------Original Message------Normally you can encode true/false values as 1 or 0.You also might need an apptoken if your application has apptokens turned on.Try this instead:URLRoot() &amp; "db/" &amp; Dbid() &amp;"?act=API_EditRecord&amp;rid="&amp; URLEncode ([Record ID#])&amp; "&amp;_fid_24=1" &amp; "&amp;rdr=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid( )&amp; "?a=dbpage&amp;pageID=4")with an AppToken (where xxxx is the application token value):URLRoot() &amp; "db/" &amp; Dbid() &amp;"?act=API_EditRecord&amp;apptoken=xxxxxxxx&amp;rid="&amp; URLEncode ([Record ID#])&amp; "&amp;_fid_24=1" &amp; "&amp;rdr=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid( )&amp; "?a=dbpage&amp;pageID=4")------------------------------Laura Thacker (IDS)laura@intelligentdbs.com(626) 771 0454------------------------------

laurathacker · Answer

Is this button you are using displayed on the same table where the data-change is occurring?

------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------

preetiverma1 · Answer

&nbsp; Thanks for your reply.I am trying to add new record using&nbsp; below form. Here I have 2 cases :&nbsp;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&nbsp; "ticked" checkbox and redirect it to new custom page.&nbsp;&nbsp;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&nbsp; adding 4 separate records in table.Can we use this ADD API to get the desired output.&nbsp;URLRoot() &amp; "db/" &amp; dbid() &amp; "?a=API_AddRecord&amp;_fid_24=1" [Record ID#] &amp;"&amp;_fid_34=&amp;[First Name]&amp; " &amp;"&amp;_fid_35=&amp;[Last Name]&amp; " &amp;"&amp;_fid_36=&amp;[Email Address]&amp; "&nbsp;Thanks&nbsp; &nbsp;------Original Message------Is this button you are using displayed on the same table where the data-change is occurring?------------------------------Laura Thacker (IDS)laura@intelligentdbs.com(626) 771 0454------------------------------

laurathacker · Answer

I have some workflow questions for you because it sounds like you are sometimes editing a record and want the user to be redirected when they "save" the record to the custom page id 4; and at other times you are adding a new record and want the redirect to go to Page ID 4 as well.Perhaps you can reach out to me offline (my contact info is in my signature below); so I can try better to understand the right solution for you.------------------------------Laura Thacker (IDS)laura@intelligentdbs.com(626) 771 0454------------------------------

Forum Discussion

Missing "rid" parameter.

5 Replies

Related Content

Missing an option in Kanban Card Groups

Missing "rid" parameter.

Replacing Hard-Coded Parameters

View icon missing from reports

App Token parameters?

Recent Discussions

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin

Justifications for Table Report Columns

Quickbase JMP connection