Today I did a whole lot of Napkin maths to figure out the prices and XP values of shop items.

Next I realised I'd have to create a whole new DB table to hold what items the user has bought in the past.

Ideally I'd have a table like this:

user_items ——————————————————————— User | Item | Purchased ——————————————————————- ——————————————————————- User007 | Water | No ——————————————————————-

User007 | Steak | Yes

However this was impossible in Bubble. I ended up having to add a user field to my shop_items table, in order to display the items in a repeating group