How To create a dropdown menu in my table in Confluence

Darien Curry
Contributor
February 7, 2024

Hey all,

I have been trying to create a simple drop down menu in Confluence almost similar to how you can create one in excel or Google docs. For example in the table you will see "Animal" and the drop down you can select between Penguin, Giraffe, Elephant. I have been trying to figure out how to do this but I need help.

4 answers

6 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 8, 2024

Hi @Darien Curry ,

It is not possible natively but there are 3rd party apps that provide such functionality.

For example, if to talk about apps that are developed by our company, you may take the Table Filter, Charts & Spreadsheets app and its Table Spreadsheet macro.

This macro provides all the basic Excel-like functionality (dropdowns, filters, cell formulas, conditional formatting, etc.) and you'll be able to edit your tables both from the page view and page edit mode.

And you may also choose the Handy Macros for Confluence app: its Handy Status macro will also do the trick with dropdowns within native tables. 

Ram October 7, 2024

Does it support cloud ? we have this plugin installed in our cloud instance but how do we get the dropdown macro ?

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 7, 2024

Hi @Ram ,

If you are talking about the Table Filter, Charts & Spreadsheets for Confluence app, then you may use the Excel-like dropdown option inside its Table Spreadsheet macro.

If you need dropdowns inside native Confluence tables, then you need the Handy macros app and its Handy Status macros.

2 votes
Darien Curry
Contributor
February 7, 2024

This is helpful but will I be able to use this macro in the page mode instead of template mode. I want to my entire team to be able to edit the page and not just the template in my account.

Alessandro Cristiano
Contributor
February 8, 2024

Hi @Darien Curry 

Alessandro from Ricksoft here, thank you for posting! 😊

I believe that Excel-like Tables for Confluece will help you to achieve what you want, by using the very same features as you would in Excel or Google Sheets.

Our app will allow you to add a gadget to your page with a full featured spreadsheet app, including drop-downs:
Screenshot 2024-02-08 at 12.57.32.png

You can also add the gadget to a template, so whenever a new page is created, the spreadsheet will be already there for you.

Hope it helps! 

Cheers,
Alessandro C.

Darien Curry
Contributor
February 12, 2024

Hey @Alessandro Cristiano I would love to use this. I'm trying to download it and use it now. 

Like Alessandro Cristiano likes this
Alessandro Cristiano
Contributor
February 13, 2024

Glad to hear it, @Darien Curry !

Should you need any help or have any questions, just send a reply, we at Ricksoft will be happy to help you out. 😁

Cheers,

Alessandro C.

2 votes
Michael Yaroshefsky - Visor for Jira
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 7, 2024

Hi @Darien Curry

Welcome to the Atlassian Community.

If you're an admin, you can try creating a global template. From there, create a list then add a variable to the list. Here's a screenshot to make it easier for you to see how to do this:

Screenshot 2024-02-07 at 4.58.58 PM.png

This support article from Atlassian might also help you https://support.atlassian.com/confluence-cloud/docs/create-a-global-template/

Let us know if this help,

Michael

Darien Curry
Contributor
February 8, 2024

Yeah this works for templates perfectly. But I've been trying to put drop downs in a table on the Confluence page. But it's looking like the table spreadsheet is the only option. But is there any other option to do this without using the table spreadsheet.

 

Kevin Jewett
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 18, 2024

Hello @Michael Yaroshefsky - Visor for Jira ,

Will/should the variable-list functionality work on non-global templates? I am not an admin but can create my own templates in my personal space. I've tried to get the variable-list to work as a drop down with no luck.

My configuration is below, but when I launch the template, there is nothing in the field where the variable macro is located.

Capture.PNG

Jason Meloche
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 30, 2024

@Kevin Jewett 

When you first select the template it gives an overview of the template as a whole before you start filling in the template. At the top it displays this 
Screenshot 2024-08-30 111931.png

Scroll down to your variable in the template here first before clicking "Create". You'll see the variables are selectable now. Then when you click "Create" it will fill in the selected variable and populate it in the page. 

Not real ideal to be honest but it works I guess. Hope this helps

0 votes
Oki__PolarisOffice_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 12, 2024

@Darien Curry 

If you need to add an exel file and edit it in a Confluence pagePolaris spreadsheet can be a good option. 

Our app, Polaris spreadsheet allows you to embed an existing excel files in a confluence page and directly edit it.
It offers full editing capabilities for excel files and provides an advanced view mode that allows you to use filters, scroll, and find. Please check the details.
A month's free trial is available now! 

Atlassian Marketplace 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events