Skip to main content
Question

Add button on report to check the check box on all record

  • January 2, 2018
  • 0 replies
  • 70 views
I have a report that shows all line items that need to be billed out based on certain filters. Is there a way to add a button to the report that would check the "draft created" check box I have on all of the records shown? 
    This topic has been closed for replies.

    It is not a a simple task, since the system does not really know your report filers to be able to run an API to do that mass update.

    If you want one on one assistance to set this up as a click, please contact me via the information on my website.  QuickBaseCoach.com

    The alternative is simple to use Grid Edit. 
    Click 1 is Grid Edit
    Click 2 is Manually check the first checkbox
    Click 3 is highlight the whole column for the checkbox field.
    Click 4 is "right click" the column heading and fill down.
    Click 5 is save.

    So 5 clicks.
    • DanDan1
    • Quickbase Alumni
    • January 6, 2018
    Hes it is possible and it is simple to do with script.

    Look at this demo that place a single button (not an identical button on each record) atop of a report:

    Process Selected Records
    https://haversineconsulting.quickbase.com/db/bkfwuwx2p?a=td

    In your case pressing the button would cause a script to run that confirmed the desired action and set the checkbox of all the currently displayed records. Note that this is just an demo I quickly located that had a custom button atop of a report. This demo was created to allow you to process randomly selected records. It was not created to solve your particular problem. I am just in a hurry to answer as many accumulated questions as I can today.
    Terms & ConditionsAccessibility statement