Basic data lookup question

Hi All,

New bubbler here :slight_smile:

I’m trying to look up the values in the table below based on two selections and save the result in my db.

So I want to create two dropdown lists for example the user selects the values:

  1. < 25,000
  2. 3m / approx. 10ft
    Save to database value: 7

What would be a good strategy to implement this from a database and workflow perspective?


Hi there, @edwinpurnell1985… I would likely go with option sets on this one, and after playing around with it for a bit, I would have three of them.

The first option set would define the row options.

The second option set would define the column options.

The third option set would define the values (one option for literally every value in the table, not just unique values), and this option set would have attributes that link to the other two option sets.

On the third option set, you would modify the attributes for each option and specify the corresponding row and column options for the value.

With those option sets in place, you would show the row and column options in dropdowns. Finally, the following expression would get the correct value based on the dropdown selections.

Anyway, that’s one way you could go here, and I hope this helps.


P.S. Since I actually built out the option sets, you could copy them from my sandbox app into your app if you want to go the option set route. Hit me up with a direct message if you’re interested in copying them.

1 Like

Hi @mikeloc - Thank you so much for going to all that effort to answer my question!

I will look at implementing this towards the end of the week and let you know how I get on.

Thanks again!

1 Like