Forum Discussion
If new forms support a form rule that says when the record is saved, change a checkbox field to unchecked, then i could help you write a button which would edit the record, uncheck the box and then display the record in edit mode.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
It does look like I can add that to the form rules.
------------------------------
Sarah Driscoll
------------------------------
- MarkShnier__You10 months agoQrew Legend
Ok, 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
------------------------------- SarahDriscoll110 months agoQrew Trainee
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__You10 months agoQrew Legend
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
------------------------------