Possible to select/deselect multiple orders to print at once?

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
We have a table that is full of what we refer to as Requests, we then have a button on each one to print a "work order" based on data in the Request.  Is it possible from a table report to be able to select and print multiple work orders at one time vs doing each one manually?  Printing 5 manually is fine, but 100+ would be a nightmare.
Photo of John Ross

John Ross

  • 518 Points 500 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 Points 20k badge 2x thumb
Normally this selection process is done on an individual record bases or to all records in a report on a bulk basis. It looks like you want to select records interactively or based on some sub-criteria from a displayed report.

I have a technique I developed called "Process Selected" that allows you to check individual records in preparation for doing something (update, delete, copy, notify .. pick a verb) with them via script:

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

This is a common requirement.  I should mention that you can configure your Windows Explorer to do precisely this checkbox selection process. Here is a screenshot of me selecting individual files from my Python installation:




If you want help implementing something like this feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
John,
In terms of native solutions, and an alternative would be to have the users checkbox the ones that they want to print, using Grid Edit.

Then make a report of checkboxed Work Orders and Print that Report.  When you print the report it will ask you if you want to print as a report or print each record on a new page. 

So then that would solve the actual printing issue, so the focus of the discussion would be on what the easiest way would be to reset the checkboxes once they have been printed.  The low tech solution for that is simply to grid edit the report of checkboxed Work Orders, but there are also ways to make a button to clear that columns for all records.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Dan, I assume though, that the OP wants to have one page per work order to hand out to the shop floor.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 Points 20k badge 2x thumb
No problem - a couple more lines of code.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 Points 20k badge 2x thumb
Okay I added eight more lines of code and throw up both of the print pages.

A rush job and sloppy but I had a few minutes before I start my other work.
Photo of John Ross

John Ross

  • 518 Points 500 badge 2x thumb
Would this work with full pages of data?  Our workorders generally take up a full page with the address, customer info, and configuration data.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 Points 20k badge 2x thumb
It should work as well as printing without the fancy selection process.

Bear in mind that this is just a proof of concept. You are free to run with the what I have posted but if you need help feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt/edit