I would like to create a page with a table that contains 10 columns for gathering data about a group of virtual machines that I manage. I would like to use this single table to contain data like name, create date, desc, region, userid, password, etc. I'll call this table the Master table. I will restrict access to this page so only I can see and edit it.
On another page I would like to have another table that only displays a subset of the columns from the Master table. For example, I will have a vm credential page that only displays the columns for Name, userid, and password. Then I can restrict access to that page for only the users who I want to see the vm login information.
I will repeat this process and create other specific pages that display only the data I'd like to show from the Master table, restricting access to only the users who need to see that data.
I was thinking that I could put the master table in a multi excerpt region and display that data on other pages, but I don't think this will work.
I'm not able to find a way to only select and display 3 columns from the 10 columns on the master table.
Has anyone tried or succeeded at doing something like this before? If so, I'd really appreciate hearing about your project.
Thanks in advance for your help,
The problem with that is that if if you have multiple pages references the original table the filters to not work independently on the new pages.
Page 1: if you filter table on this page, Page 2 and Page 3 are also filtered
Page 2: this works oK, but if you change the filter that carried over from page 1 it changes the filter on page 1
Page 3: if you change the filter on page 3 it changes the filter on page 2
So you can only filter one way on a different pages
I can't seem to get this to work.
- I created a source table on page 1 (no table filter - just a plain table) and put it inside a multi-excerpt.
- I created a page 2 and added a table filter with a multi-excerpt include inside it.
- I edited the table filter and selected "Hide Columns," and then I selected two columns that I did not want to show on page 2.
- I saved the table filter and the page 2.
- I still see all of the original columns from page 1.
Any ideas what I am doing wrong?
P.S. The "Hide Filters" box does not seem to save. When I click on the gear icon the "Save" option is grayed out. I click on the regular save button but when I go back in there are no columns listed in the "Hide" box.
I was able to make Barb's case work on the current version of Confluence we have. Barb could you check you have done these 2 steps below in the table filters macro
1 - Within the "Filters" Section, tick the "Hide columns" box, and nothing more to do.
2 - In the "Filtration" section, go to "Set filters' default values" and in the appropriate location select the columns you want to hide, and save from here.
If you do not do 1 you will not be able to do 2. Hope this might help.
Put your data in an Excel spreadsheet and use the Office Excel macro on each of the pages. One can show you all the data, for the others you can specify the last column of data you want to show. You'd have to order your data so that the left most column(s) are the ones everyone can see... Or, you can put all the data on one worksheet in the Excel file, and have additional worksheets in that file that just display the columns you want. I'm not sure on how permissions would come into play.
- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events