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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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? 
Photo of TRNC

TRNC

  • 314 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
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.
Photo of Dan

Dan

  • 140 Points 100 badge 2x thumb
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.