We have tables in app maker that shows data in list view and it will add default features like sorting, paging. We want filters on top of each column in
that table, drop down control acts as filter that will list all the distinct values on its configured column. When I select a value in dropdown it should
filter the value from datasource and load in the list view.
If two filters or more filters is applied at the same time, the filters should act as AND condition that will bring values satisfied with all filters.Answer1:
There is no such type of table in App Maker at this time (but you can always file feature request <a href="https://issuetracker.google.com/issues/new?component=192783&template=833410" rel="nofollow">here</a>)
Meanwhile you can put some effort and implement it on your own. You just need to add input widgets, layout them and bind to <a href="https://developers.google.com/appmaker/scripting/api/client#Query" rel="nofollow">filters(_equals, _in, _notIt, _startsWith...)</a>:
There are some relevant apps with this functionality:<ul><li><a href="https://developers.google.com/appmaker/samples/project-list/" rel="nofollow">Project List</a></li> <li><a href="https://developers.google.com/appmaker/templates/project-tracker/" rel="nofollow">Project Tracker</a></li> </ul>