Forum Discussion
Hi Mark!
It would be with the new forms. I currently have a button on a report that ideally, when clicked, it would only show that specific section of the form.
I was thinking if I altered the formula of the button to essentially say when clicked, go check this box. Then in the form rules I could say what you mentioned above. I didn't even think that I could put into the form rules to uncheck from there.
Not sure if that logic is sound and would work or if this isn't possible.
------------------------------
Sarah Driscoll
------------------------------
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
------------------------------
- SarahDriscoll12 years agoQrew Trainee
It does look like I can add that to the form rules.
------------------------------
Sarah Driscoll
------------------------------- MarkShnier__You2 years ago
Qrew 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
------------------------------- SarahDriscoll12 years 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
------------------------------