Button to only show specific part of form
Hello,
I have been trying to mess around with this but have not fully figured it out.
Is there a way that if someone clicked a button, I could then have is check a box that a checklist is s...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOk, so the button would be like
var text CheckTheBox = URLRoot() & "db/" & dbid()
& "?act=API_EditRecord&rid=" & [Record ID#];
& "&_fid_99=1"
var text DisplayInEditMode = URLRoot() & "db/" & dbid() & "?a=er&rid=' & [Record ID#];
$CheckTheBox
& "&rdr=" & URLEncode($DisplayInEditMode)
That code is not tested so if there are some syntax errors please post the code and whatever error message there is.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I'm getting an error at the second ampersand. It says that it is sepxceting text. I tried changing the field type to rich text and URL with no luck.
------------------------------
Sarah Driscoll
------------------------------
- MarkShnier__You
var text CheckTheBox = URLRoot() & "db/" & dbid()
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_1630=1";
var text DisplayInEditMode = URLRoot() & "db/" & dbid() & "?a=er&rid=' & [Record ID#];
$CheckTheBox
& "&rdr=" & URLEncode($DisplayInEditMode)
The first; needs to be moved down a line.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------So the error is no occurring around the re-direct part of the formula and is showing the same error as before
------------------------------
Sarah Driscoll
------------------------------- MarkShnier__You
Please copy and paste your formula so I can see it.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Here is my current formula.
------------------------------
Sarah Driscoll
------------------------------- MarkShnier__You
try this version
var text CheckTheBox = URLRoot() & "db/" & dbid()
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_1630=1";
var text DisplayInEditMode = URLRoot() & "db/" & dbid() & "?a=er&rid=" & [Record ID#];
$CheckTheBox
& "&rdr=" & URLEncode($DisplayInEditMode)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
That did the trick!! Thank you!
------------------------------
Sarah Driscoll
------------------------------
