Display Latest Things in Repeating Group

Need help Database
1

I always struggle with how much context to give in these requests for help.

In short I want to display a list of each products most recent inventory.

Inventory is a thing (that contains a field for product and inventory counts for various things - different warehouses, different statuses etc)

Inventory is pulled daily, and the user has the ability to look back in time and select, say, the inventory for the end of last week.

Product is a thing (that contains data like price, name etc)

So in my repeating group, by default I want to turn up a single inventory for each product, but only the latest one for each product.

I feel fairly certain I could do this if I made a list of inventories on the product data, but over time we will get up to 1000’s of nested inventories, which I believe to be too much for Bubble to handle.

I also feel that doing something like making it a list of products, and then doing a search for each products last item is flawed because the user needs to search the inventory for various fields.

How would you set up this repeating group?

2

You could have a yes/no field on the Inventory type called “Latest” or something. Whenever the newest inventory is created, that field = yes, and you update the previous record’s field to no.

Your RG can then be a search for Inventory records where Latest = yes.

1 Like
3

I needed to take a shower to figure it out - but that’s exactly what I wound up doing!

I do my best thinking in the shower lol.

1 Like