Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

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

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...
DanDan1's avatar
DanDan1
Qrew Member
7 years ago
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.
  • BobbyNeelon's avatar
    BobbyNeelon
    Qrew Member
    5 years ago
    Hi Dan,

    This may be a silly question. In that demo, how are you adding the "Process Selected Records" button atop the table? Thanks!


    • EverettPatterso's avatar
      EverettPatterso
      Qrew Captain
      5 years ago
      It's custom code that injects script as the page loads.

      $("table[qbdbid=" + dbidTable + "] tr:first").before("<tr><td><a href=# id=QBU_Button class='Vibrant Success'>Process Selected Records</a></td></tr>");

      If you are not familiar with coding to write it yourself, you can hire a Quickbase partner to help you set it up. 

      Here's the original link to Dan's pastie showing the full code
      https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=462&rl=gni

      ------------------------------
      Everett Patterson
      ------------------------------