Forum Discussion

jrossausiscom's avatar
jrossausiscom
Qrew Assistant Captain
8 years ago

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

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.
  • 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
  • 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.
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      Hey I changed one line of code in my demo and after it throws up the two dialog boxes displaying (1) the list of [Record ID#]s selected and (2) the ad hoc query parameter for the list of selected records it then initiates the native print function.

      One line of code was changed!

      Test it yourself:

      https://haversineconsulting.quickbase.com/db/bkfwuwx2p?a=td
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      Dan, I assume though, that the OP wants to have one page per work order to hand out to the shop floor.