Really, it's just a button that is created by a formula - rich text field. The formula is built so that it uses the API to edit the record twice in succession. First, it selects the checkbox and then it goes back to un-select it. The formula that I use for this is:
var text chk = "&_FID_34=";
var text tk = "token";
"<a class='Vibrant Alert' & href=" &
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=" & $tk & "&rid=" & [Record ID#] &
$chk & "1" &
"&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=" & $tk & "&rid=" & [Record ID#] &
$chk & "0" &
"&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]))
& ">My Button Name</a>"
With this formula, you will need to replace the "34" in the first line with the FID of your checkbox. Then, you will need to insert your Application Token in the "token" in the 2nd line. Go all the way to the bottom and just update the name of your button where I have "My Button Name" and you'll be good to go.
Just place it on the form where you want to see it and set it to show only in View (not Edit or Add). Once you click it, it will check and immediately un-check your checkbox.
------------------------------
Blake Harrison
bharrison@datablender.ioDataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 /
http://datablender.io/------------------------------
Original Message:
Sent: 12-15-2020 14:57
From: Bruce Kasen
Subject: CHECHBOX VS BUTTON
I a previous email, I asked for support for using the checkbox feature for triggering email notifications. I wanted the checkbox to automatically uncheck itself after the email was issued. I was informed that the Automation feature could accomplish that feature. I had unsuccessfully tried to program the Automation feature to do what I wanted it to do.
It was then suggested to me to try a button field (vs a checkbox) to auto issue an email notification. Is there such a feature in QB as a trigger button? If so, please give me specific instructions on how to trigger the auto emails, either via the button or checkbox.
I thank you in advance.
Bruce
------------------------------
Bruce Kasen
------------------------------