Hi there, I was wondering if someone could provide assistance or point me in the right direction.
Our head office makes us do a stocktake of onsite assets once a year. They spit out a spreadsheet from their asset management software, and we're meant to check off the assets off the list (spreadsheet). Once the assets have been sighted and marked off on the spreadsheet, the spreadsheet gets uploaded back up to the asset management software at head office. Assets are barcoded with their "Asset ID" number. I can use the inbuilt Form in excel and go to Criteria and search and bring up an asset by scanning an asset barcode, then click (or tab) to the relevant field and mark it off, but having to move between fields constantly, it becomes quite time consuming. The other issue is assets are mostly mobile and so we have to also record their current location. So, with a barcode on the asset, and a printout of barcodes for locations (a "Facility" code in our case), and printed barcode for the sighted "Status", and printed barcode for TAB (to move to next field), it turns into a lot of beeping/scans to record the sighting of one asset. It's doable but does become tedious.
I was hoping this could be improved, and I was thinking the following would improve things:
- Have a custom form that has a separate search field that looks up the table's "Asset ID" column, and then displays all the asset details, similar to the inbuilt Form. It returns focus to the search field, ready to scan the next asset.
- Upon retrieving the asset details, it automatically changes the "Status" field to "S" (which is the code for the asset having been sighted)
- And what would be huge, would be somehow, set the "Facility" (location) field for subsequent asset searches to be the same as the current search. I hope that makes sense. So, if I walk into a room and start scanning 20 assets in there, I only need to scan a "Facility" location code once.
If there is a better way to do this, I'd be happy to hear it.
I have attached a sample xlsx file which might help make more sense.
Bookmarks