Reviewing the data model
With the template workbook created, we are now ready to review how the Honeycode team set up the data model for the Inventory Management app. However, before we dive into that, let's take a couple of minutes to think about the data that is required for such an app.
From the requirements, as listed earlier, we would need to have categories defined for the consumables supply versus the asset for tagging the items. Furthermore, we would require sub-categorizations for each of those types. For each asset, we would need to maintain its category and sub-category, along with its status regarding whether it's available, has been requested (and who requested it), has been assigned (and to whom), and more. We would also like to maintain a record of the following:
- Who all the assets were assigned to
- When it was assigned
- When it was returned for auditing and usage purposes
Now that we have an idea of what data we need, let's explore...