Skip to main content
Question

URL Button to check a checkbox

  • December 22, 2017
  • 0 replies
  • 317 views
I am trying to have a URL Button to check a checkbox if that checkbox is empty and do nothing if it is already checked. I would also like this button to be pressed from an embedded report.
Essentially, I have an Items table that is embedded into an estimate table. The items have the name, description, price and whether it is approved or not. The approved checkbox is unchecked until the customer decides they want to move forward with that line item so I need a button that can be pushed from the embedded report that will check the approved box and update the item
    This topic has been closed for replies.

    • JustinPauga
    • Author
    • Registered
    • December 22, 2017
    I was able to figure out how to do it using quickbases URL Formula Buttons for Dummies sample app but right now it redirects back to that line item and I need it to either not redirect or to redirect back to the related estimate
    Justin, I see that you found my app in the Exchange

    Here is what you need


    var text URL =
    URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
    & "&_fid_55=1";

    "javascript:" &
    "$.get('" &
    $URL &
    "',function(){" &
    "location.reload(true);" &
    "});" & "void(0);"

    Change 55 to your checkbox fid.

    this syntax refreshes the whole page, even when clicked off a child record on an embedded report on form,  or on a report.
    Terms & ConditionsAccessibility statement