Using Section names in formulas

Hey @Philipp_Alexander_Asbrand-Eickhoff great question! @jakobheuser posted a bit about this topic in this thread. Since there is no way to get the section name using a variable, there is a bit of a hack you can use to get the name yourself to be used for a filter, view name, etc. The hack involves creating a table with one column being the full link to the section and the 2nd column with the following formula:

=thisRow.ToText().Split("/").nth(6).RegexReplace("_.*","" )

This formula uses regex to tease out just the section name which you can reference in the canvas. In this case, I reference “Bugs-Experiment” by writing =@[Bugs/Experiment].Stub to get just the text “Bugs-Experiment” in the canvas. You can then assign a variable name to this calculation (in my case I named the calc myFilter). You can then reference myFilter anywhere in your doc!

4 Likes