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:-
- Add new record to “TableA” with ID value of “xxx” 2. Select a view based on “TableB” that only contains records with ID value of “xxx”
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.
- Have simple form to enter data for “Table A” - 3 columns comprising TableBid (unique value), ID (text), Filter (Y/N) 2. Action on form saved called “GotoFilteredView”
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:
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?