I find myself often wanting to use some kind of dictionary lookup in Bubble - example below:
A user can have a category of say A, B or C, which is saved to the User data type
When a user submits a score for a test, it is saved to a ‘Submission’ data type
The average score is also saved, which depends on their category…
… so say for a specific test, category A average is 72 points, category B average is 77 points and category C average is 83 points…
When a uses submits a score for this test, I want to be able to grab their category, look up the average score for that category for this test, and save the average alongside the submitted score in the Submission data type
Hope it makes sense, thanks in advance!