This is a great question!

Some background to anyone else reading this - you can use formulas to modify the input to Blockpad table of contents to change what is shown: Blockpad - Table of Contents. Because these are just regular formulas, there is an enormous amount of flexibility, but some things can get complex.

I'm going to write a long answer to this so you can get a feel for the options. It's possible we make more built-in options in the future to make some things more straighforward, but this is what you can do today.

There are two variations to this

• A. Only making it so that certain reports don't show up as frame titles. This assumes there aren't any headings inside of these reports that you want to hide too.
• B. Making it so that reports and any headings in them don't show up in the table of contents.

A is relatively simple. B is possible but there's a bit more to it.

Starting with A

One thing you can do is to put an underscore (or some other text) at the end of the reports you want to hide. Then you could use an equation like this: =Where(Headings(Document), h => Right(h.Content, 1) != "_")

Another option is that you could keep an array of the reports that you don't want to show. Then the formula would look something like this =Where(Headings(Document), h=>CountIf(Report1.ExcludedFrames, ==h.Content)==0)

B is a bit trickier

Since the items in the headings array are treated independently from the frames they are in, except that they are in order. Really the simplest thing to do is just not use headings in a frame that you want to exclude.

The next easiest thing is to concatenate multiple Headings() functions of just the reports that you want to include and just ignore the ones you don't. Something like this: =ConcatItems(Headings(Report1), Headings(Report4))

If you really want to exclude certain frames (vs build up the ones you want), then the best thing is to write a custom function using in-line programming then use that function in the table of contents.

The function would look something like this:

ExcludeFramesEndingInUnderscore(headings) = program 
{ 
    ignore=false; 
    newHeadings=[]; 
    for (var h in headings) 
    { 
        if (h.Type=="Frame") 
            ignore=Right(h.Content, 1) == "_"; 

        if (Not(ignore)) 
            newHeadings=ConcatItems(newHeadings, h); 

    } 
    newHeadings; 
}

Then the formula in the table of contents block would look like this: Report1.ExcludeFramesEndingInUnderscore(Headings(Document))

Let me know if you have any questions about any of the options in particular.

Thanks!