So I’m looking to produce some functionality on one of my webpages for a 2D lookup table of dimensions of about 200x200. As per the example below, both dimension categories are identical (A, B, C, D): I want to interactively call and output the comparisons between them (ab, ba, cd…etc).
Here’s what the format of tabulated data looks like:
X A B C D
A aa ab ac ad
B ba bb bc bd
C ca cb cc cd
D da db dc dd
I have already built this table in Excel and have exported it as a .csv to a table on my wix site (in the content manager), and have created 2 dropdown list boxes: one for each dimension and selecting from A,B,C,D…etc. But here’s where I’m stuck: I need two more things to happen:
-
Perform the 2D table look-up from the 2 selected values of the dropdown list boxes, and immediately output the corresponding category comparison (ab, dc or whatever) into a textbox(?) or some other element displayed on the page.
-
Assign a ‘randomize’ button to each dropdown box that can randomize the value of each of them separately - and ALSO an overriding ‘randomize’ button that would randomize both their values.
-
bonus (if possible) can I modify the dropdown lists so that I can type into them and narrow their selection?
Any step-by-step help on this would be greatly appreciated! Thank you.
p.s. if it’s still not clear what I’m trying to implement, it’s basically the same as what this site does: https://pokemon.alexonsager.net/
(Although I am doing it with a totally unrelated dataset - nothing to do with pokemon!).