Product Counts by Date

asbg · 2024-12-28T10:36:58.551Z

Hello everyone.

I am making an inventory management system where users can add future entries and exits. However, what I need to do is to give an alert if the entries are less than the exits on any date. However, I need to be able to do this for each product type added by the user. I want to explain the system where I can make for a single product right now.

1- I create the dates with this application Calendar & Timeslots Custom · BEP Plugin | Bubble.

2- I print the dates with an RG with a data type of “date”.

3- There is an input with the initial content “Search for Entries (date=Cell’s date) minus Search for Exits (date=Cell’s date)” in the RG.

4- A musician also checks if there is a value below 0 in all RGs every time the page is refreshed and gives an alert.

This system is probably pretty stupid too. But at least it works. But what I need is to be able to do this for both “Chocolate” and “Doritos” for each date. Any suggestions would be greatly appreciated.

Thanks.

mitchbaylis · 2024-12-29T07:36:58.431Z

if all entries need an exit I’d structure it like this

inventory item - name etc
inventory_entry - inventory, date_in, date_out

then a user would submit a form which create inventory_entry and adds the date_in date.

user could select the entry in a repeating group and then add the date_out (or you could use buttons to simplify)

this gives you the ability to do a simple search - search for inventory_entry where date_out is empty

you could also have multiple inventory_entries for the same item that have not been checked out yet.

given your explanation above this is what I’d do, but I don’t quite get the purpose of it so it might not be the correct data structure