Grist does not have conditional drop down lists but it is a feature we would like to implement.
Our cross join is a few steps but way easier than the first way I sent! Always learning new things Grist can do! I updated the example with two new tables; All Options and Cross Join.
In each column of the All Options table, we have a reference list for each option; Type, Material, Clock Setting / Voltage and Connection Technology. In each column, we have a formula in the following format:
Previously, I set up a table for each option with the different choices available. That’s what we are using here. Below, you see that the equation for the Clock Setting / Voltage column is Clock_Setting_Voltage.all and the column type is Reference List pulling data from the Clock Setting / Voltage column of the Clock_Setting_Voltage table. We see all options listed in the cell.
Once you have this page set up for all options, you can cross join by making a summary table and group by all options
This is the ‘Cross Join’ page I created. It only includes this summary table.
I added the Combo column that combines the values in each column.
Next, we want to detach the data. In the Table Configuration menu on the right hand side, navigate to the Data section and then select ‘Detach’.
This turns our summary table into a regular table with all of our data! Now, you can name the table and call it in formulas elsewhere in your document.