I am new to Coda, and was playing around with a situation where our business interacts and sells components to multiple OEM’s of large systems. In this manner, I would like to have a table, “OEMs”, that lists each major OEM and then has a subitem column next to it for each model which that OEM makes.
I would then tie this to other tables with further data (e.g. a table listing various regions / states etc., and marking which OEM’s operate there). The OEM column would be a selectable list of text related to the OEMs table giving you the option of each company name. Because I want to tie the OEM to a specific region in another table, I also want to have a “model” column that I can select which model is used in that region.
Here’s what the “OEMs” table could look like:
While I could technically make the main column of this table “models” and it would be simpler, I feel like readability and from a category standpoint “OEM” is the top level.
Ideally, I would have the “regional” table with a column “OEMs”, which lists the “OEM1”, “OEM2” and so on for options, and if I select “OEM1”, the next column “models” would automatically filter only the options from “OEM1” - “OEM1 model 1”, “OEM1 model 2”, and so on.
Is this possible? I’ve tried coding it myself but keep hitting a wall. Thanks!
Edited to add:
I was trying some of this as inspiration but still not getting it right:
