LinkedIn
Twitter
Hey everyone!
I have the following issue:
Inside a detail view (table_A) with some information on the chosen row I also have a ref chart (filtered slice of table one as chart view). Below that chart I have placed some buttons (enum) to filter the information inside the chart.
Currently the buttons refer to a row inside the table_A row. The problem with this is, that the choice of the buttons is different within each single row of the table_A (so the choice is specific attached to each row).
But I want much rather to be able to make a general button choice.
F.e. my selection of “blue” should remain the same inside every row of the table_A.
I tried to make a solution with the ref_row virtual table. So I have created a new slice within my Google Sheet that is called “user_choice” to save the general selection of the color there. Then I have created a detail view with the enum button.
But I do not know how to link both of this data. As List and ref (as for linking table views) seems not to work.
My question is:
How can I integrate the buttons of the “user_choice” detail view into the “table_A” detail view (not using a dashboard, but keep my detail view). I kind of need a virtual copy of the buttons of “user_choice” detail view inside the “table_A” detail view.
So that If I change the color from blue to red inside the table_A detail view, the choice would be general and shown in each row of the table_A detail view.
(If it is the virtual columbs + ref, what do i have to type into the app formula, the type and element type?)
Thank you much 
