Creating a results table from a Dropdown selection

PRASHANT SINGH_roe1wv

Hi there,

I would like to create a page on confluence where I can select options in two Dropdown lists and then display a table with the results that are in my spreadsheet.

First Dropdown: Select 'Type'

Second Dropdown (based on what is selected above: Select 'Brand'

Based on the Selection I would like to display a list of all the relevant models. I have about 300 models across the spreadsheet. Below is the structure of my spreadsheet.

 

 

 

Could you please tell me the best way (and possibly low-code) to do this if this is feasible?

Appreciate your help. thank you.

 

Stiltsoft support

Hi @PRASHANT SINGH ,

Not sure if you are talking about a spreadsheet that is provided by a specific 3rd party app from the Atlassian Marketplace or about Excel/Google Spreadsheet file that is outside of Confluence but you want to get the same functionality right in Confluence.

If you are talking about the first option, please clarify which app you are using.

If it happens so that you use our Table Filter and Charts for Confluence app and its Table Spreadsheet macro, then please check this Community question. There @Katerina Rudkovskaya _Stiltsoft_ explains how to create dependent dropdowns. 

If you are talking about the second option, then it is not possible to implement out of the box. You'll need to find a suitable app on the Atlassian Marketplace.