I am creating a lab inventory app in which I will have an admin create an account, and the admin will add users to their group that can manipulate the inventory. I would like the admin to be able to create different inventory buttons based on the amenities that they have in their lab (some labs may have a -80C and -20C freezer while other labs may only have a -20C freezer). How do I go about employing this functionality? Below is a sample of the “main page” I have for my app, that displays the currently pre-defined buttons and their inventory lists.
1 Like
Hi,
I suggest your db structure:
Data type1: Lab
Data type2: storage type
Data type3: storage (fields: lab, storage type)
Data type4: stored item
Data type5: inventory transaction (fields: storage, stored item, qty)
Then you can play with forms for inventory transaction (add items to storage, move items from one to other storage, issue items from storage)
For report:
List inventory transaction
Inventory report (by storage, lab, item, etc)
1 Like
Thanks! I’ll try some of these suggestions.
I have another question as well. I have been struggling with ways to securely upload information that goes directly into the database. It would be nice for the user to be able to link with a specific Google Sheet or upload the files directly. Do you know of a way to do this (without paying for the monthly plan that allows import of CSV files?
Hi, sorry i have no experience with upload directly into db
but actually i am not convenient with such a way since we can not have record for who should be responsible (user) for the data recorded