Hi all,
I am managing data on a "Mother table".
My customers, need to only access a few items on the table.
I wish to create few separate pages with a relevant filter from the same "Mother" table.
For example, one filter is regional, that's how my Australian customers will have a page that is "filter locket" for AUS.
Another customer only needs to access the filter "Status", I wish to create a separate page for them to pull the relevant data/
what is the best way to do it?
In this case, you can try the Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros to display data from one page to another and then filter it with our Table Filter macro:
Here's the example:
Katerina
Stiltsoft
Hi Thanks a lot for your help
Tried that and received this error on the "child" page
What am I missing?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Racheli Shuraty
Please raise a support request then and attach pages storage format.
You can view the Confluence storage format for a given page by choosing ... in the top right corner - > View Storage Format.
Thanks!
Katerina
Stiltsoft
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
is it possible that since I'm not an admin I cannot reach to the support request?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You may try to attach your screenshots here - it seems that your Table Excerpt Include doesn't get the table from the Table Excerpt macro.
Attach the macrobodies (settings) of these two macros - maybe smth is wrong with their names or smth.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please, make the screenshots of the Table Excerpt and Table Excerpt Include macro bodies - where you specify their names and where your Include macro should look for the Excerpt macro.
Do you see the parent table in the preview of the Table Excerpt Include macro?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
And again you didn't give me the screenshots of the Table Excerpt/Table Excerpt Include macro settings - I can't get why your Excerpt Include doesn't collect your source table.
From your screenshots of the edit mode I can see only the beginning of your settings near the macro name - name = NPI Status Database.
Check that the name is 100 percent the same for the both macros and check where you find your Excerpt.
You should definitely see you sorce table into the Excerpt Include preview.
Here is our documentation related to these macros.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks for your help, are these screenshots helpfull?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For the second screenshot you have a "Specific page" chosen but nothing for the "Page title" - specify the title of the page with your Excerpt macro.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes! this is what I was missing,
thank you!
is there a way to choose only a few coloumns to show on the child table?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Go to the Table Filter macro settings > Filters tab and check the Hide columns option.
Then go to the Filtration tab > Set filters' default values > Columns to hide and specify the columns that you don't want to show.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unfortunately, not for Cloud due to the new editor limitations.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
got it.
This was very helpful for me, thank you very much! appreciate it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
if you don't mind.
One last question,,
how do I set a rull of one column to hide a row?
for example IF status= Done,--> hide
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check this abstract - you need to use reversed filters.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks,
is there also a way or "freeze" a few columns on both view & edit mode?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, there is an option to freeze columns and rows.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.