Add New Record, Select Record and then Deeplink to Filtered View?
Can anyone help me out? I am trying to add a new record to โTableAโ and then select a view based on โTableBโ that matches a criteria set in โTableAโ. In summary I want to achieve the following:-
I do not want to set a filter on a slice and so thought the approach noted below would work, but it simply ends up displaying all the records from โTable Bโ and not just the ones that fulfill the filtered view criteria.
Action GotoFilteredView comprises:-
Action name: GotoFilteredView For record in table: Table B If this condition is true: [_THISROW].[Filter] Do this: App: go to another view within this app Target:
LINKTOFILTEREDVIEW(โTableViewBโ, IN(TableB[ID],TableA[ID]))
Validation message states โNavigate to โTableViewBโ โฆand show rows where this condition is true: ( โฆ(TABLEB[ID]) is one of the values in the list (TABLEA[ID]))โ
Problem may be to do with using the filter condition โTRUEโ in TableB but I donโt know how to select the data for just the new row I have added to filter any other way.
I have spent hours trying to get this to work and at face value cannot see why it doesnโt - can anyone HELP me out?
If I understood your request correctly, you could try it like thisโฆ LINKTOFILTEREDVIEW(โTableViewBโ,[ID]=[_THISROW].[Filter])
Thanks for your prompt response, sadly that doesnโt work either. I have confirm action on and it says it is running the action, but it ends with blank screen not displaying any records. Also when I run โTestโ in expression builder it displays all records and not just the filtered one. Also the formula is not comparing the correct columns so I have just tried amending and ignoring filter (Y/N) column for the moment
LINKTOFILTEREDVIEW(โTableViewBโ,TableB[ID]=[_THISROW].TableA[ID])
However that then errors stating
Cannot compare List with Text in (TABLEB[ID] = [_THISROW].TableA[ID]).
So I tried IN expression and still returns all records. Just cannot understand why this will not work.
Finally resolved it!
For the benefit of anyone who may experience the problem I dropped the idea of a filter column and then changed the expression to
LINKTOFILTEREDVIEW("โTableViewBโ", [_THISROW].[ID] = [ID])
Note: if you include the table name in front of the second [ID] I found it (a) doesnโt need it and (b) doesnโt work.
Hopefully this may save some of you the hours of fun that I have had trying to get it to work.
Wuhuu
Thanks for this, I almost gave up on idea after attempting for
over 1 week. This is really a great featureโฆ
Glad itโs of help!
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |