nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can I display a subset of data from a table on a different page?

Jeff Clark_1ymbz7

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,

Jeff

Accepted answers

Andrey Khaneev _StiltSoft_

Hello Jeff,

Table Filter macro can hide columns of a table, but it is not secure. I think there is only one way to make it secure: to create a copy of the table on other pages and set page permissions.

All comments

Andrey Khaneev _StiltSoft_

Hello Jeff,

Table Filter macro can hide columns of a table, but it is not secure. I think there is only one way to make it secure: to create a copy of the table on other pages and set page permissions.

Jeff Clark_1ymbz7

Table filter wrapped around an excerpt include worked perfectly.

Thanks for your help Andrey.

Jeff

Andrey Khaneev _StiltSoft_

You are welcome, Jeff!

Casey Maynard

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

John Corwith

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.