Controlling view type for child (REF data)

Hello everybody :smiley:

I have a question how to control the view type for the child records in the Parent-View.

Parent table has a Child table ref to the Parent table.

In the Parent-detail-view, I would like to control the view type of Related-Child shuch as Map, Deck, Table, etc.

How could we control the view type???

Thanks in advance :hugs:

You can configure ā€œChild_inlineā€ view.

2 Likes

@TeeSee1

Thank you very much for your advice!

Is it possible to create several ā€œChild_inlineā€ views and use each of them in different cases?

https://support.google.com/appsheet/answer/10106516?hl=en

AFIK, you cannot.

2 Likes

You can create dashboard views and show different child views but controlling which dashboard to display based on the parent row you pick is not doable.

Out of curiosity, what is your logic to choose the correct view???

2 Likes

Yes, use one Slice per view you need. Then change the [Related …] column in both, the REF_ROWS() expression as well as the column config so that you point it to the Slice instead of the table. Then your children will be presented using the Slice’ Inline view

4 Likes

@TeeSee1

Thank you for your help!

My logic to chose the view is like this;

I have 4 tables

ā€œApartmentsā€, ā€œFloor Mapsā€, ā€œEquip Pinsā€, ā€œEquipmentā€

One Apartment has multiple related Floor Maps

One Equipment has multiple related Equip Pins on the Floor Maps

From the ā€œApartmentā€ view, I would like to show ā€œFloor Mapsā€ in Deck view or Card view.

Feom the ā€œEquipmentā€ view, I would like to show "Related Pins on ā€œFloor Mapsā€ in Table view.

1 Like