Can you have a table which allows both filtering and the use of 'edit contents'?

[Joseph McManus]

I'm trying to use confluence to create a control list of monthly tasks with a columns for each month. Within each cell I'd like a drop-down to flick from pending to complete and a text box to add supporting evidence (links to other pages/attachments). I'd like users to edit using 'edit contents' where they can filter for their own name and easily find their tasks.

I've managed to create the table the way I'd like it to work using the TablePlus macro (I'm aware I'll need to change the names of some of the List Data to make sure they're all different later), but when trying to fill in fields using 'edit contents', the information doesn't save. From what I gather, this could be down to the use of the TablePlus marco as it's sees it as a 3rd party table for display only. Is there a way round this?

May be limited to standard Macros in our organisation.

[Mercy · Accepted solution]

You’ve run into a limitation of how macros handle inline editing in Confluence Data Center. The Edit Contents feature only works with macros that store their data natively in the Confluence page storage format. Third-party macros like TablePlus render their own data structures and don’t write changes back to the underlying page content, so edits made through Edit Contents can’t persist after saving. Atlassian’s native macros such as Table Filter and Charts for Confluence or Page Properties Report can support filtering or dynamic reporting, but none currently combine inline editing with filtered views in the same table.

[Stiltsoft support]

Hi @Joseph McManus ,

The Table Filter, Charts & Spreadsheets for Confluence app that was kindly mentioned by @Mercy is developed by our company.

Indeed on Data Center in the view mode you can filter but not edit your table with the help of the Table Filter macro (in the edit mode you can both apply filters if required and edit the table data).

So, to filter, edit and add dropdowns in the page view mode, we can suggest taking the Table Spreadsheet macro instead. It looks like an Excel sheet with all the familiar features.

Hope this helps your case.