Display specific collection data based on multiple criteria

I am working on building a reference site for various airplanes and the speeds that they must reach before taking off or landing (formally known as v-speeds).

My plan is to create a distinct collection for each airplane and have it display on an airplane profile page on my site. Here is an example of what my database would basically look like for a particular airplane:

I am open to advice on the best way to set up this collection/dataset to achieve my desired result. Obviously this is how my setup is in excel, so need to know how this would translate best into a Wix collection. I have seen some people leave the “title” field blank, so any advice on whether to make my “title” field the weight or to leave it blank would be appreciated.

Anyways, here is what an airplane page will sort of look like. I have created inputs that will allow a user to input the Weight of the aircraft and the Flaps setting to receive the correct “v-speeds”. These inputs will link to the Weight field and Flaps field of my dataset.

My goal is to have an output below the input boxes that simply displays the V1, VR, and V2 associated with the inputted weight and flaps. The values of these boxes would change dynamically as the input boxes are changed by the user.

I have programmed with python and R before, but I am relatively new to JavaScript. I’m hoping this could be a good first intro to understanding how JavaScript works.

Does anyone have any advice on how to setup this website? I’m hoping its a relatively easy solution. Thank you in advance for your help.

Friendly bump. Anyone know how I can use the two drop downs to select the relevant data?

No one knows how to link these site features to my database??

Still searching for a solution ?

This is an old post and is being closed.