Discussions

Expand all | Collapse all

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

  • 1.  Possible to select/deselect multiple orders to print at once?

    Posted 02-08-2018 19:32
    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.


  • 2.  RE: Possible to select/deselect multiple orders to print at once?

    Posted 02-08-2018 19:45
    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


  • 3.  RE: Possible to select/deselect multiple orders to print at once?

    Posted 02-09-2018 09:50
    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.


  • 4.  RE: Possible to select/deselect multiple orders to print at once?

    Posted 02-09-2018 10:26
    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


  • 5.  RE: Possible to select/deselect multiple orders to print at once?

    Posted 02-09-2018 10:28
    Dan, I assume though, that the OP wants to have one page per work order to hand out to the shop floor.


  • 6.  RE: Possible to select/deselect multiple orders to print at once?

    Posted 02-09-2018 10:52
    No problem - a couple more lines of code.


  • 7.  RE: Possible to select/deselect multiple orders to print at once?

    Posted 02-09-2018 11:16
    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.


  • 8.  RE: Possible to select/deselect multiple orders to print at once?

    Posted 02-09-2018 14:37
    Would this work with full pages of data?  Our workorders generally take up a full page with the address, customer info, and configuration data.


  • 9.  RE: Possible to select/deselect multiple orders to print at once?

    Posted 02-09-2018 15:03
    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">https://getsatisfaction.com/people/dandiebolt/edit">https://getsatisfaction.com/people/dandiebolt/edit