i’m absolutly new to .bubble and don’t know how to select data with a non-specific column.
For better illustration, the example below should help to break down the issues.
We have two databasis:
DB_One: is for holding the key informations of elements with different properties.
The header looks like [name_ele, prop_1, prop_2, prop_3, prop_4, prop_5]
DB_Two: is holding possible combinations of properties which have to be checked in a
different way. The header looks like [name_combi, first_prop, second_prop]
DB_One: [Element_2, 12, 10, 15, 20, 18]
DB_Two: [CheckOption_2, prop_3, prop_5]
→ wanted output of the query: 15, 18
I want to select (via two Input fields) the row of DB_One (which is absolutly fine) and the columns of DB_One, which are part of the chosen CheckOption. Therefore, i’m looking for a way to select the value of the field whith a variable coloumnname (where i’m lost).
I tried different workflows for looking at the values one by one and saving them in states, which is intuitiv. The main-problem is to look for a column, which has to be chosen in an indirect way via user input.
What did i overlooked or where is the problem of the databasestructure?
Thanks and best regards,