Forum Discussion
JaimeFonseca
5 years agoQrew Trainee
The second appreciation!!
------------------------------
Jaime Fonseca
------------------------------
------------------------------
Jaime Fonseca
------------------------------
MarkShnier__You
Qrew Legend
5 years agoTry this syntax. It is intended to update the record and refers the user back to that same record. if there are any syntax error please post you code back here as an update.
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=XXXXtokenXXX"
& "&rid=" & [Record ID#]
& "&_fid_30=" // this will blank out field ID 30.
& "&_fid_111=" & URLEncode (Application Approved")// put words into field ID 111
& "&_fid_123=1"; // Set a checkbox to true
var text URLTWO =
URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];
$URLONE
& "&rdr=" & URLEncode($URLTWO)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=XXXXtokenXXX"
& "&rid=" & [Record ID#]
& "&_fid_30=" // this will blank out field ID 30.
& "&_fid_111=" & URLEncode (Application Approved")// put words into field ID 111
& "&_fid_123=1"; // Set a checkbox to true
var text URLTWO =
URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];
$URLONE
& "&rdr=" & URLEncode($URLTWO)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JaimeFonseca5 years agoQrew TraineeHi Mark, thanks in advance for the help.
The syntax of that code gives me an error, it comes out (Formula Syntax Error - The argument list of the function Application must begin with a left parenthesis.)
I have tried in other ways but it does not stop getting an error
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=XXXXtokenXXX"
& "&rid=" & [Record ID#]
& "&_fid_30=" // this will blank out field ID 30.
& "&_fid_111=" & URLEncode (Application Approved")// put words into field ID 111
//"&_fid_123=1"; // Set a checkbox to true
var text URLTWO = "https://headstronglabs.quickbase.com/1db/bq8h9zbbg?a=pageedit&pageID=1"
URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];
$URLONE
& "&rdr=" & URLEncode($URLTWO)
------------------------------
Jaime Fonseca
------------------------------- MarkShnier__You5 years ago
Qrew Legend
Jaime,
In your response to me earlier, you said that you were just trying to update a native Quickbase record and not enter data into some kind of custom html form.
What is is it that you are trying to do?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- JaimeFonseca5 years agoQrew TraineeHi, sorry if I did not make myself understood, I have a button that redirects me to an html page that I created, this page has a form with several fields to enter, currently I have two fields in the form but only one is saved only in the text field, the other text fields are not saving anything.
var text urlToExecute = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=cnbri4sbttfxsfys53ftbiz34vv"
& "&rid=" & [Record ID#]
& "&_fid_30=" // This register works fine and is saved in my text field
& "&_fid_111=" // If I try to add another record like this for example nothing is saved in my text1 field
;
URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=11" // Here is the page where I open my form
& "&url=" & URLEncode($urlToExecute) // Pass in the URL to execute
------------------------------
Jaime Fonseca
------------------------------