I’m sure that this little technique of mine is frowned upon by AppSheet. I don’t think it’s part of Google’s “material design” concept for apps. Still, I wanted to make a hierarchical outline like this:
In this case, I think the outline structure is easier to understand than a plain list.
So, how is it done? With spaces . . . I know, I know . . . not exactly rocket science. But, there is a trick to it just the same. Ordinarily, AppSheet would ignore spaces at the beginning of a line. So, I had to trick the platform into doing my bidding. Here’s how I did it:
- In the Google spreadsheet
You can’t see it but there are lots and lots of spaces between the quotation marks.
I’ve explained what this HEX2DEC character does here:
How to make a mirrored histogram in AppSheet
The “L7” cell has text that I use in other contexts. It may not be necessary here. Then again, it might be necessary to have something after all of the spaces. I can’t recall right now. (It’s been a long time since I first did this.)
- An “indent” virtual column
The column in the step above this one is “Quotes” in my app. Here’s what I have in my “Indent” virtual column:
The number controls how many spaces will be used in the indent. Season to taste.
- The target column
I use something like “concatenate([indent],”• your archive")" to get what I want.
That’s it. By the way, with an outline like this, a show/hide toggle might come in handy:
It would also be nice if we could control the spacing between lines.