Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
6 years ago

Need Help With First Button Attempt

As stated before, I just started working in Quick Base and I'm having trouble with my first attempt at a button.  The label is showing, but not as a button.  I am trying to check an checkbox and updat...
APIs and custom code
Button
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You should not be editing the same record twice or you will not be able to refresh to the page as easily,

So calculate the URL like

var text URLAPPROVECOMPLETE = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&_fid_18=Completed"
"&_fid_274=1";

var text URLAPPROVECOMPLETEISSUES = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&_fid_18=Completed With Issues"
"&_fid_274=1";

var text URL =If(
[Has Service] and [Is Verified] and [NoIssues],$URLAPPROVECOMPLETE,
[Has Service] and [Is Verified] and not [NoIssues], $URLAPPROVECOMPLETEISSUES)

"javascript:" & "$.get('" & $url & "', function(){" & "location.reload();" &
"});" & "void(0);"





------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
also if it is not appearing as a button , then check the checkbox to show as button.

Display as a button on forms and reports

and select a colour

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------