Conditionally check a checkbox
I've put in too many hours this week and am making stupid mistakes. I need a button that will check a checkbox if a corresponding checkbox is checked. There are several services and not all are ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe issue that after a URL executes you need to direct where the user will land or rlse it will spit out that success message n he screen..
If you just want to refresh the page, then this Syntax will work.
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=ghhrwtcy2ca93dvtmnvidb9gm5a&rid=" & [Record ID#] & "&_fid_3008=1";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
The only issue with this syntax is that even if the the use of javascript as "harmless" as it is used here to refresh the page is a loophole in the security level which Quick Base is aiming for. Eventually they will want to close that loophole once they have alternatives to recommend.
This syntax will do the URL and then redisplay the record and does not use javascript.
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=ghhrwtcy2ca93dvtmnvidb9gm5a&rid=" & [Record ID#] & "&_fid_3008=1";
var text Display = URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];
$URL
& "&rdr=" & URLEncode($Display)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If you just want to refresh the page, then this Syntax will work.
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=ghhrwtcy2ca93dvtmnvidb9gm5a&rid=" & [Record ID#] & "&_fid_3008=1";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
The only issue with this syntax is that even if the the use of javascript as "harmless" as it is used here to refresh the page is a loophole in the security level which Quick Base is aiming for. Eventually they will want to close that loophole once they have alternatives to recommend.
This syntax will do the URL and then redisplay the record and does not use javascript.
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=ghhrwtcy2ca93dvtmnvidb9gm5a&rid=" & [Record ID#] & "&_fid_3008=1";
var text Display = URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];
$URL
& "&rdr=" & URLEncode($Display)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thank You!
That worked great!!
------------------------------
Paul Peterson
------------------------------
That worked great!!
------------------------------
Paul Peterson
------------------------------
I spoke too soon.
I used the second option and it works great for a single checkbox. But there are 18 services in total. Where does the Display URL go for multiple conditions?
When I added the second condition:
If(
[Remote Services] and [Remote Services] != [Remote Services - Submit], $URLRemoteServices,
[End Point Firewall/Anti Virus Suite] and [End Point Firewall/Anti Virus Suite] != [Endpoint - Submit], $URLEndpoint
)
If I include the with the URL variable, it works for one checkbox then returns, the other combinations I have tried get the same errors.
------------------------------
Paul Peterson
------------------------------