I would like the ability to have a barcode scanner embedded in the mobile app, which would allow for automated data entry (for my use case, computer and electronic equipment serial numbers) This would be useful for other applications as well, including shopping lists, inventory, and coupon management.
In addition to the above request, the ability to generate QR codes from record data would add simplicity to data entry. Thanks!
Hi @Evan_Smith, thanks again for your feedback. We’ve implemented a couple of your suggestions in the latest app update (3.1.0) which went live yesterday. It’s now possible to toggle a device’s flash on and off when scanning a barcode. Also, the green scanning guide is now closer to the center, to help line up a barcode in the middle of the scanning area.
Wonderful functionality. One question… is the camera button missing from the search bar in the iPad app? Or am I missing something obvious? I don’t have an iPhone (waiting on that Android beta :winking_face: ) but we do have an iPad in our house. I’d love to be able to search on barcode values in a base, using the barcode scan functionality.
Reading barcodes for data entry is no problem with the iPad.
Hi @Mike_Eovino, it’s possible to search a table by scanning a barcode. The camera icon will be displayed only for tables that contain a barcode field, and it looks like this:
If that’s not working for you, please let us know.
If you’re interested in getting a sneak peak of the Android app, please fill out this form (if you haven’t already) https://airtable.com/shrLK2dGvhx46S6bU and we’ll include you in the next round of beta invites!
Thanks, @Douglas_Forster, that makes sense. My barcode column isn’t in my main table, it’s in a linked table. I added my barcode column into the my main table with a lookup column, and now I can use the barcode search against my main table. That’s pretty sweet.
I did notice that if I hide the barcode column, I get the camera icon, but the search yields no results.
And thanks for the link; I just signed up for the beta.
Hi @Mike_Eovino! When searching for a record, the search term (or barcode search) will match only on visible fields. We’ll probably keep the barcode icon around in that scenario, but I can understand how it might be unexpected that scanning a barcode did not match any records.
I am trying to build a base to to fulfill several needs, including maintenance records. Is it possible for you to share some of your base or lessons learned when creating your base?
I do maintenance on 2 buildings, and production equipment. My hope is to have a database that can log maintenance records on equipment. As well as be a singular source for much of my scatted information, like repair part numbers, vendors, repair part lists, manufacturer info, supplier info, and more. Essentially the database will replace a rolodex, stack of business cards, filing cabinet of equipment manuals (which are available as pdfs) and a notebook of maintenance notes, as well as multiple excel files.
Eventually I want to be able to hand off a database to the next guy when I leave this job. Instead of when I walked into the job and was given 1 paper typed in all caps on front and back. I was working on an Access database but the learning curve for the forms and reports etc just seemed painful for someone that never used Access. Stumbling upon Airtable via a twitter ad has rejuvenated my hopes and efforts for creating my database.
Any help you can give would be very much appreciated Evan!!
Can you post some more info on the kind of info you’d like to track?
You may be able to start out with the Asset Tracker database in the gallery and expand out from that. The Asset Tracker looks pretty good, although I’d create another table to define the kinds of items I have in the inventory. I wouldn’t want to type in Macbook Pro 17" Retina more than once, and I might want to store some information that’s common to all of my Macbook Pro 17" Retinas in a single location (like part number, etc.).
I’m pretty sure Airtable can do what you’re looking to do.
We may want to ask Airtable for another category where people can ask for DB design help. This is a phenomenal tool; I’ve been able to create several bases that I use on a regular basis (pun unintentional) in a matter of hours. But I’ve been developing for the last 20+ years, and an understanding of relational databases definitely helps with this.
Thanks Mike for writing me. I will try to type something up that might better convey what I want to create and track.
While I do that, do you know if I can simply share my base that I have created so far? It may prove useful at conveying my intentions. And/or I could send the Access DB your way? I created many of the tables and relationships, but never finished the other side of it, because the learning curve on the form/report side of things was too brutal.
FYI, up until this point I have used Trello and Excel as the solution to try and fulfill my needs but they just don’t do what I want.
Assets: Production Equipment (over 50 pcs 5 main types), HVAC equipment (25pcs), Emergency Lighting Equipment (30pcs 3 types), Fire Extinguishers (20pcs), and more
Parts and Supplies: example: 20 parts used for Prod. Equip. repairs across 5 suppliers with differeing costs.
Manufacturers: Info for Purchase Order forms, Manuf. Tech dept Contact info, Manuf Sales contact info for sending units in or ordering parts (this has overlap with supplier table I will need to resolve)
Suppliers: The suppliers for the parts and their contact info.
Cost: Latest prices for parts available from more than one supplier.
Maintenance Records: Any monthly, annual, or scheduled maintenance, as well as repairs and ongoing status updates regarding equipment.
Location: To help differentiate simple assets like emergency lighting, or fire extinguishers, but also for seperating records for futrue proofing, we have 2 building and may consolidate, as well as move some departmentss/ equipment. Location can also be used for inventory, to say these bulbs are stored in this storage area, and those toilet repair parts are stored in a different storage area.
Ideally I want to also record:
Asset to Asset Assignment: Production equipment has interchangeability, so printers can be swapped from this autmoated duplicator to that one, or into my shop for repairs, then put back onto a different automated duplicator then it was removed from.
Inventory: Inventory of parts and suppliers on hand, like filters, belts, as well as specific repair parts for production equipment.
Repair or user Manual/materials: Some sort of location guidance to pdf files, or physical folders in file cabinet, etc
Service Companies: Contact info for service companies HVAC, plumbers, etc. Possibly with records of what they did, and on what PO.
