I have a table that I want to essentially act as a “classification” style writing structure where I want each of my rows to have a designation like “Section 1, Article 2”. I want to be able to manually sort the order of the sections and articles and have the number change appropriately.
So if I move a section to the top of the table it becomes Section 1. And then if I have 5 articles associated with any given section, they should be numbered based on their order within the table, but with respect to whether they are associated with the same section or not. That last part is the hard part that I need help with.
My setup so far:
My table has a relation to itself so that I can link the articles to the overall sections.
I have a formula column called Structure that when the relation column is filled for the row then it prints “Article”, otherwise it prints “Section”.
I’ve added 2 table views that filter for Section and Article respectively. So that’s the setup: one primary table but table views that only show sections and articles respectively.
Using this formula I am able to get a row number based on the current sorting order of the sections and articles respectively:
if(thisRow.Structure="Article", [Articles Table].Find(thisRow), [Sections Table].Find(thisRow))
So that gets me a current row order # of both the articles and the sections and it doesn’t mix the two. But that’s where I’m stumped. I don’t know what I can do to make the article numbering respect the section that the article is under. I’m imagining that this requires either a formulamap or a currentvalue, but I find these concepts a little tricky to wrap my head around. Could anyone help me out here?