Forum Academy Marketplace Showcase Pricing Features

Deliver values similar to VLOOKUP

Bubble newbie here and I’m having trouble with a test app for my classes (I’m a prof). I want to have a limited # of inputs from users, that then have different hidden values attached. I then want to sum all the values to give a final score. In Excel this is VLOOKUP then SUM but I don’t understand how to do it in Bubble (I’ve read the forum posts on how to do this and seen tutorials on database design, but I just don’t understand them).

How do I tell a text element to reference an input element and then fetch the corresponding value? And where do I store the values? They need to enter inputs between 1-400 so I’d prefer not to enter each one by hand (e.g. 1-5=40, 5-10=30, 11+=10)