Behavior to show nested table column

For example, public template "Field Delivery" shows nested table column like below

amufaamo_0-1656072825116.png

 

I want to show nested table column when I select a row of table or deck view. 

For example, when I click "Driver 1", the jobs of the driver are shown.

amufaamo_1-1656072958998.png

amufaamo_2-1656073010225.png

 

I think I need to make behavior, but I don't know how to make it.

 

 

 

Solved Solved
0 5 715
1 ACCEPTED SOLUTION

Here's info about Reference views - AppSheet Help

The key points regarding your scenario are:

View solution in original post

5 REPLIES 5

You may need to select a different Row Selected event action for your equivalent of the view that lists drivers. You may already have a system-generated action like View Ref (Job ID) that you can select. If not, you can create an action using the type "App: go to a view within this app". Also, you may not have the necessary references between your tables.

Sorry I could find View Ref (Drivers) , but I could not find View Ref (Job ID)

amufaamo_0-1656078448089.png

Could you tell me how to make Ref view?

Here's info about Reference views - AppSheet Help

The key points regarding your scenario are:

Thank you I understood, but I cannot still make the view. I thought I make slice, make view, and make action to show this view, but I cannot succeeded yet.

Actually, I am making task management app. Some tasks are flow, so I made 4 columns, "Unique ID", "Thing", "After", "Before". "Before" is virtual column.

Actual data is like below

amufaamo_0-1656117161274.png

Expression of "After" is below. I can choose rows.

amufaamo_1-1656117321084.png

The expression of "Before" is below.

select(not done task[Thing], in([_thisrow].[Thing], [after]))

amufaamo_2-1656117426817.png

When I select "Eat breakfast" row, I can see the tables of "make coffee" and "make bread".

amufaamo_3-1656117468844.png

I want to make view if I select "Eat breakfast", I can directly see the list of "make coffee" and "make bread".

I tried to make slice, the expression is below, but it shows nothing. Is something wrong?

IN([Thing], [_thisrow].[Before])

 

So sorry it is quite long sentence

Sorry I put question again.

Top Labels in this Space