Inline View show/not show a column based on view

[Austin]

I have 2 views, one for Parts and one for Location. I have a table that has a reference to both. I don’t want the inline view to show the Parts column when I am in the Parts view but I want it to show when it’s in the Location View. I also want the reverse where the location should show in the Parts view and shouldn’t show in the Location view. Just using the Show if did not work as the column that should be hidden is just blank instead of not showing the column. Also tried making a vc based on CONTEXT but I knew better and that doesn’t recalculate. Anyone have any ideas other than make 2 copies of the table so I get 2 inline views to set the column order on.

[Marc_Dillon]

You need to make a new slice for each new Inline view layout, as well as the appropriate REF_ROWS VC for the new slice.

Funny, I basically just answered the same question twice in a row:

New Bug Encountered: Inline views displaying as main view Questions

Hi Team, Its happening that my inline views are displayed as the configuration of the main view. For example, on this app my inline view should be Table, but are displayed as a Deck [image] Here the config of the main view of “Presupuestos” [image] If I change the view type of the main view, it changes [image] Could you help me with this? Thanks in advance

[Austin]

So I have to make 2 slices of this table and only include the columns I want to display in each? I don’t see how this gets back to my inline view?

[Rafael_ANEIC-PY]

Austin_Lambeth:

So I have to make 2 slices of this table and only include the columns I want to display in each? I don’t see how this gets back to my inline view?

You can create a custom inline view by linking a virtual column that uses a ref_rows() expression to a slice of a table that has your desired column configuration, after that you only need to create a table view linked to that same slice to serve as an inline view.

You can repeat this process so that you have as many custom inline views as you need, after that it’s only a matter of managing the show_if permissions for your new virtual columns, so that only one of them is shown at any given time.

[Guillermo]

Is there any sample for this? I would like to see it running. This is a very useful solution!

[Austin]

That did not seem to work. So make a VC from my Parts table to a slice of the table I want my inline view to be?

[Rafael_ANEIC-PY]

Here’s a list of steps that i wrote to another post:

Variable inline column distribution depending on view Questions

Hey @Aurelien, videos are not my strong suit, basically what Steve said can be done following these steps: Create a slice of the table with your desired alternative column distribution. Create a table view of the slice in the ref position. Add a new virtual column to your table, using the ref_rows() formula pointing at your slice. Manage show_if conditions as you see fit for your new custom made inline child view.

[Austin]

Variable inline column distribution depending on view

Hey @Aurelien, videos are not my strong suit, basically what Steve said can be done following these steps:

1. Create a slice of the table with your desired alternative column distribution.
2. Create a table view of the slice in the ref position.
3. Add a new virtual column to your table, using the ref_rows() formula pointing at your slice.
4. Manage show_if conditions as you see fit for your new custom made inline child view.

Problem for step 1. I want to remove the Ref column from the inline view. So the Parts inline view wouldn’t show the Parts column. If my slice doesn’t have the Ref column then I can’t make the VC using the ref_rows()?

[Rafael_ANEIC-PY]

Austin_Lambeth:

Problem for step 1. I want to remove the Ref column from the inline view. So the Parts inline view wouldn’t show the Parts column. If my slice doesn’t have the Ref column then I can’t make the VC using the ref_rows()?

You can include the REF column in the slice, just don’t include it on the table view

[Austin]

So the inline view just used the inline view from the table the slice was made from instead of using the table view I made for the slice when I did that.

[Rafael_ANEIC-PY]

That’s weird, when i needed a variable inline view i didn’t have that issue, it should pick up the view for the slice if both the VC and the view are pointing at the slice, if you do include the ref column on the inline view, does it let you use it?

[Marc_Dillon]

I was able to throw together a sample app for this tonight:

Sample App : Child table with multiple parents. Show different inline views for each parent Tips & Tricks 💡

Here is a common scenario, where you may have 2 main data tables, then a single “join” table that is a child of both. In the attached sample app, you see the scenario of product and order, with the join table being line_item. In the join table, there is a reference to a product record, as well as an order record, amongst other data such as quantity.

Here is the backend data

[image] [image] [image]

The Detail views for both parent tables will show an inline view of “Related line_items”. However…