Hi,
I have a Year Table in Table View, and a Product Table in Table View.
When I click on a specific Year, I would want only the Products made in that year to show up.
I created an action;
For a record of this table: Year Table
Do this: App: go to another view within this app
Target: LINKTOROW (id, "ProductTable's View Name")
Under Product Table View In UX pane I've changed the Event Actions to the one I've just created, but still shows me every product from every year.
What am I doing wrong??
Solved! Go to Solution.
You are going from the Year Table to the Product table.
So the "id" in your LINKTOROW means the id (key?) of your Year Table.
So it is trying to match the Year Table's id to the Key of your Product Table, which is, I am guessing, most likely not what you want. (year : products = 1 : n )
Try
LINKTOFILTEREDVIEW( "ProductTable's View Name" , [year] = [_THISROW].[year] ) where
the first [year] is the year col in the Products and the second [year] in the Year table.
You are going from the Year Table to the Product table.
So the "id" in your LINKTOROW means the id (key?) of your Year Table.
So it is trying to match the Year Table's id to the Key of your Product Table, which is, I am guessing, most likely not what you want. (year : products = 1 : n )
Try
LINKTOFILTEREDVIEW( "ProductTable's View Name" , [year] = [_THISROW].[year] ) where
the first [year] is the year col in the Products and the second [year] in the Year table.
Thank you, worked perfectly~!
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |