Follow

Building a Work list with Bar codes from a Query

Have you ever used the Ad Hoc Query Tool to get a list of requests then thought, "I wish this had barcodes so I could use this as a worklist?" Here are a few quick steps that will allow you to use that list in the Request Batch Update screen by adding a simple formula to an Excel spreadsheet.

Create Your Query and Export to Excel

?name=media_1427215313926.png

Use the Search > Ad Hoc Query menu option to build the list of requests you need.

Include the Req_ID column.

Export the the output to Excel.

Add the Bar code Formula

?name=media_1427215529000.png

1) In the Excel spreadsheet, include a column where the formula is =CONCATENATE("*",C3,"*",CHAR(13)) The C3 gets replaced with the cell value that contains the REQ_ID. The CHAR(13) is a return or enter expected by the bar code scanner.

2) Format the cell to use the 3 of 9 Bar code font. You may want to increase the font size so it scans easily.

Test your list by scanning the bar codes into Notepad.

Use in Request Batch Update

?name=media_1427215631273.png

You can now use the printed output from your query to batch update the requests by scanning the bar codes.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk