4/9/2023 0 Comments My home inventoryUsing the database model above, I can create custom tables for the system in the Microsoft Dataverse. Master Bedroom, Living Room, etc.), and an ItemType (ex. Each Item will also have a lookup to a Manufacturer (ex. Each Item record may have 0 or more Image records. There is an Item table that contains most of the data. Using the requirements above, I can derive a simple database model. AI – While this is a tall order, it would be neat to take a picture of an item and have it recognized what kind of item it is, perhaps even determine its Item Type.Photo of Receipt – item would be a nice feature to include a picture of the receipt for proof-of-purchase and returns. This could be for serial numbers, model numbers, or even UPC for the entire item. Bar code Scanner – for items with a bar code, it would be helpful to scan these automatically.In addition to the requirements, there are some future enhancements or “nice to haves” that I can investigate adding to the system later, for example: The system should allow Admins to export the inventory. Admin App should provide the ability to create, update and delete Manufacturers.Admin App should provide the ability to create, update and delete Locations.Admin App should provide the ability to create, update and delete Item Types.Phone and Admin Apps should provide the ability to create Locations.Columns: Name, Support URL, and Support Phone.Phone and Admin Apps should provide the ability to create Manufacturers.Phone and Admin Apps should provide the ability to create Item Types.Users should be able to add an Item Image.Location will look up from the Locations table.The manufacturer will look up from the Manufacturers table.Item Type will look up from the Item Types table.Required columns: Name, Model Number, Item Type, Manufacturer, Location, and Image.Columns: Name, Description, Item Type, Manufacturer, Serial Number, Model Number, Location, Date Purchased, and Approx.Phone and Admin Apps should provide the ability to create, update and delete Items.The system should include a phone app for data entry and a web interface for administration.The requirements of the initial system are straight forward: I set out designing my home inventory system using the Power Platform with these things in mind. I want to use my phone and its many capabilities for data entry instead of walking back-and-forth to the computer. “having a list or a visual reminder of your belongings can make a big difference in how much your homeowners’ insurance will pay, and thus how well you’ll recover financially.”Īt the time, I purchased Quicken Home Inventory Manager, which was adequate at the time however, advancements in technology have made it obsolete. I wondered what would happen if I were robbed, had a fire, or some other disaster and found myself wondering if my insurance would cover all my technical assets? According to Consumer Reports: Several years ago, I started considering the number and value of technical assets I had obtained over the years.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |