Tables displayed as outlines — outline layouts

I’d like to be able to display a table as an outline. I use Coda to take notes and organize information. There are so many times that one note I take speaks to two or three different issues. Maybe I’m taking notes on community gardens and farmers’ markets. I find that a nonprofit does both community gardens and farmers’ markets. I will want to mention the nonprofit when I’m discussing communiity gardens, and I’ll want to mention it later when I’m discussing farmers’ markets.

Group lets you do something similar, but it is different when it comes to multiple values in a column. Take this table:
Replace
Beth is both in my family and my co-worker. Adam is both a friend and in my family.
Replace 2

However, if I were going to write about them, I’d have something like this:

Co-worker

  • Beth
  • Doris
  • Edward

Family

  • Adam
  • Beth

Friend

  • Adam
  • Charlie

In this case, Adam and Beth both show up twice. Ideally, I wouldn’t want to call out those repeated rows graphically unless I hovered. The best way to do it might be to show an extra “find” icon alongside the expand icon/button that you can click on to edit a row in a popup. Clicking on that icon would open a filtered view of the table. The filter would be for the row. If I were to click on the “find” icon in front of Adam, I would see this:

Family

  • Adam

Friend

  • Adam

As an aside, I realize that the column labels wouldn’t show in such a view. That is, the words, “Name” and “Relationship” would not be seen in the outline.

The best part is that this sort of outline could be another bridge between Coda’s text capabilities and its table capabilities.

Hi @Bruce_F_Donnelly and Welcome back to the Community :blush: !

To be honest, I think you could easily do something similar using a Lookup (instead of simple select list) and group a Relationship table instead of People and Relationships :blush: (see the sample :blush: )

As for creating outlines based on the content of tables, it’s possible using canvas formulas :blush:
(See below the 2 tables in the sample :blush: ).

For example, a canvas formula such as this one …

Relationship.FormulaMap(
  List(
    CurrentValue.Relationship,
    BulletedList(CurrentValue.[People & Relationship].Name)
  ).Join(Character(10))
).BulletedList()

would return …

With Coda New Editor (currently in Beta), announced during the last Block Party :partying_face:

A formula looking like this …

Relationship.FormulaMap(
  Concatenate(
    CurrentValue.Relationship,
    BulletedList(CurrentValue.[People & Relationship].Name)
  )
).Join(LineBreak())

… would return :blush:

Here’s another topic with a somewhat similar demand / possibilities of gathering content from tables :blush:

(Don’t hesitate if you need explanations :innocent: … I was just trying to show you some ideas :blush: )

2 Likes

Thanks!

I had to set aside time to look at it, so it took a while, but I appreciate it. I get the concept of a few things like FormulaMap in the sense that I can follow it, but I have no intuitive sense of when to use it. That said, the new editor will help a lot, apparently. The second one is much easier to follow – if you don’t mind my saying, the first one seems to go through gymnastics.