Hiding both columns and rows of an Excerpt table

Kent Thayer

I have several tables that contain both private and public information. Currently, for our weekly public meeting, I copy all the tables over to a public page, and remove the private columns, then remove the private rows. What I would like to do is display just the public portions from the original table.

Using Excerpt table I got the table to project to the public page. Then wrapped it in table filter to hide the private columns. However, I haven’t found a way to hide private rows by default.  Maybe I’m doing this wrong, but adding another filter only hides the data interactively, which leaves rows visible by default.

Assuming that I want to hide all rows where the column “status” contains “internal”. Is there a [better] way to do this?

Katerina Kovriga {Stiltsoft}

Hi @Kent Thayer ,

To hide several rows from other users, you need to create two pages: 

1. Public with no restrictions
2. Private with the required view restrictions

Now divide your tables into two parts - with public rows and with private rows. Paste these tables to the corresponding pages.

Then use the Table Excerpt/Table Excerpt Include macros to show your private part on the public page.

To combine the two tables into the big one, use the Table Transformer macro, the default Merge preset.

As the result, you'll get the following:

• you will see the whole big table on the public page
• other users will see only the public rows. The private rows will be hidden from them automatically. Besides they won't be able to find any confidential data in the HTML code of the page and in the preview of the Table Excerpt macro

 

And if you need to hide several rows on your own page just for presentation, i.e. temporarily just to share your screen, go to your Table Filter macro where you hide columns and set the dropdown filter for your status column. Then go to the Filtration Tab -> Select Reversed Filters and choose the required status that you don't want to show. After that don't forget to hide the filtration pane and control buttons.