Missing "rid" parameter.
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_...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe 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
------------------------------
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
------------------------------
- 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__YouYour 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
------------------------------- 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 recordfirst 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
