Greetings! There have been a couple of other topics about this, but none of them seem to solve my issue.
The end result of what I am looking for in the App is:
Where I select a product from one table (Recipes-Kits-Final) using the Record Selector
When selected, the table below returns the filtered results of just the recipe components for that Record.
The tables are linked.
So in the example above, if I select “14 - Softball Mallet” I would like the table below to show just the lines where the “Link-Recipes-Final” (the linked field) are “14”.
How would I do that??
What other info could I provide to help solve this?
Hi,
I’ve build a demo using the Project Management template. The goal is to show all the projects in the record selector and the corresponding tasks in the table element.
-
Create a new application
-
Adjust the path so that you can pass an optional query string parameter with the project id. You need to use a query string parameter instead of a path parameter because you not always require a project id (for example: there will be no id on the initial load)
-
Create a data source that gets all the projects
-
Add a form to the page and add a record selector to the form. Refer to the data source with the projects
-
Create a data source to get all the corresponding tasks. This data source will filter the tasks on the project_id that is passed to the page. If no parameter is passed, all tasks will be shown.
- Add a table element and use the tasks as the data source. As you’ll notice, all tasks are shown by default. Fill in a project id at the top of the page and you’ll notice that the tasks are filtered.
- Select the form and to the the Events tab. Create a new Open page action, refer to the same page and set the project_id parameter to the selected project from the record selector.
- Add a second action that refreshed the data source of the tabel.
Test your application, every time you select a value and click the submit button, the table will be filtered.
Thank you. But just to confirm, there is no way to have it filter based on the Record Selector without creating a “submit” button…correct?
Indeed, we don’t have an event yet that checks a change in a dropdownlist.
