Hierarchy Views

[Grant_Stead]

Expanding Tree - root/node style
Chart Style - Think org Structure
And as a group and sort option for drilling, tables/decks…

All we would need to do is indicate which column in the table contains the Parent Ref…
Maybe a customization on what level to start at, and hide/show “blank” levels…

Hierarchy is a easily achieved by having a REF column within that table the ties back to the same table… So the user can indicate the parent… EX: an employee table could have a REF column back to the employee table to select that person supervisor. With the Chart style view we could then look at a dynamic org chart that we can click and pan on. Or with the Tree, we could drill into it by supervisor.

@morgan Pretty Please?!
@praveen With sugar on top!

[Grant_Stead]

Here’s a video of my janky stuff:
Appsheet, save me from myself!

@Stefan_Quartemont not sure if you have more stroke than me to get some hierarchy going on the appsheet side…

[Stefan_QREW]

@Grant_Stead The way I’ve always achieved this is to have a low level record have reference columns all the way up to the highest record

Ex. Task Note record: Customer ref, project ref, task ref, task note

The task note has ref all the way up to the highest tlevel item.

So I could have a ref list at customer and see all the task notes. Likewise I could give a user access to a project, and filter out the task and task notes tables to only show ones that contain the key of that project

How would you visualize the relationships in the table you’ve made?

[Grant_Stead]

The difference here is that this all references the same exact table, there aren’t multiple tables, just one… So, i’m building the same “list” concept in a fashion. The point of the feature request is two fold, one “Appsheet, hook us up with some slick views that leverage this hierarchical relationship…” and two, "Appsheet, hook us up with some slick list expressions that automatically build these lists, so they don’t have to be in my sheet. Cause even though it’s all doable, the point of Appsheet is to be no-code…

Currently I have a drill down situation. Where I manufacture a starting list view, then when you click it, you go into the detail view for that item, the detail view only has the title and then ref lists, the first list is items that are immediately below the item your in, and clicking it drills into that detail view…

[aucforum]

Grant_Stead:

Cause even though it’s all doable, the point of Appsheet is to be no-code…

It took appsheet over two years to come up with UTCNOW() and TEXT() with date formatting arguments. Features I argue that should have been there natively from version 1.0 of the product that is based on mobile devices potentially operating across many geographic time zones simultaneously. And they were probably were not that hard to do engineering wise. I am still waiting for reusable expressions and components (not just copy and paste) that was mentioned at the start of 2018…

It makes one wonder how these Feature Requests are reviewed when they are not even officially acknowledged or tracked.

[Grant_Stead]

All I know is things are moving WAY faster now that google is helping with resources! I finally got my CSV import that I brought up 3yr ago… We just have to remember that Appsheet is still the best option, and in my opinion it’s because while certain solutions may not be ideal, you can get them done.

[aucforum]

I have noticed more staff in support… I am getting less email from Praveen though… When he was on support duty, I noticed the bugs I reported were fixed quickly.

[aucforum]

Dear Grant,

Do you have, or can you publish this as a demo application please?

I am keen to see how it works ‘under the hood’.

Thanks,

Colin.

[jader_james]

Genius

[Grant_Stead]

Colin, were you able to get something stood up for this?

[aucforum]

Yes I did. I got some more help too. Eventually alaeksi realised the new staff from Google were not being helpful with providing links to information when we needed a simple expression produced!

The hierarchy is on the back burner at the moment as other work priorities have taken root. But it’s still needs to be do e and I think a good demo in the public might generate some interesting and serendipitous feedback.

[Grant_Stead]

Bump, vote!

[Laurene_Haynesw]

I have seven tables and gosh knows how many slices I have to create just to get this accomplished.
Very much needed

[Grant_Stead]

@TDhers whatcha think?!

[Laurene_Haynesw]

So I am using dependent dropdown expressions to cut back on having to create slices. However, my app depends on the child node incrementing up to the respective parent node at interval periods. I am trying to think on how to do this as well without it affecting the app productivity. Please there’s so much need for this Appsheet.

[Grant_Stead]

Would love to compare notes and see what your approach is. Do you think you can share?