I create an appsheet system generated UNIQUEID() for the Key value for people, assets, projects, etc. But then I also have another column in which I allow the user to “assign” a UID with a datamatrix sticker, and now an NFC tag. This allows these codes to be assigned instead of system created. Printing datamatrix codes in the field to match the system generated key is difficult, as is encoding the NFC to match. It’s much easier to have them all pre-printed / pre-encoded with UID, and assign them as needed. It also makes it easier if the tags are damaged or lost to simply reassign new ones vs printing/encoding to match the system. (I hope that makes sense…)
So, how do I use this to my advantage? For example checking in an asset: If I buy a truck, I can add it as a record in the system, and I assign it a pre-encoded NFC fob, or stick a pre-printed datamatrix sticker to the window. Then when a driver needs to fill up the tank at the gas station, they can simply scan the tag, and it looks up what vehicle that is, and inserts the true vehicles key UID. In order to do this I need to have a “sacrificial” column just to scan the assigned tag, and then the real REF column doing the look up for the actual Key.
In practice this get’s a little messy. Cause what if the tag won’t scan. Or, what if the vehicle doesn’t even have an assigned tag. Then they have to be able to access the REF field so they can search for the vehicle.
Anyone have any great ideas?