Multi-user item tracking based on common database

Ask the community
1

Hi there,

I’m trying to create a site to allow users to track their collections of in-game items in a video game I play. The devs don’t have anything like that at this time, and I think it would be a good addition to the online tools we have. What I’ve done is create a G-Sheets database of those in-game items which is categorized based on various criteria. I’ve already spent a few hours building out the pages for the site and adding tables that pull in the data. Now, I’m sort of stuck. I would like to be able to have people log in, and then tick off boxes as they collect items. Then, I want to ‘award’ achievements based on completing sets of items (armor sets, skin sets, manufacturer sets, etc). From what I can see so far, someone ticking the “Status” box in the chart would mark the item as collected for everyone. Please let me know what you’d recommend. Thanks!

2

The old saying, “There’s lots of different ways to skin a cat” comes to mind, If I’m following you correctly, I think you are going to need a better database than G Sheets to do what you are trying to achieve, or at least you are going to need to set it up in a different way and/or use an outside automation resource. Firstly, each user needs to have their own unique record (row), then the items collected would need to be a different column in that row or linked to another record in a relational database. Once they check the box, you want it to ‘trigger’ a different action, you would need that to happen through an automation such as a script, zapier zaps, make or airtable automations.

or

I suppose in your G Sheet, you could have a formula in a different column, that when box A is checked, Box B = something else, then in Softr, you only display column B.

1 Like