Hi @Jaros
You may want to have a look there:
[Filtered Dropdown](https://community.appsheet.com/t/filtered-dropdown/15678) Questions
Hello to you all again! I have a table with Guardians and another one with Children. A third table, Connections, with 3 columns ID, Guardian, Children. In the Connections table, I want the dropdown for the child to be filtered and have only the unassigned children. I want to do this by checking the Connections table and if the child has not been on any records previously, then to have it in the dropdown. Any clues? Thank you!
[Filter a dropdown](https://community.appsheet.com/t/filter-a-dropdown/9969) Questions
I am trying to filter a dropdown depending on what the user put just before (year of the article and quantity) in the form of the app. I did like that: SELECT(Products[Article Id], AND(IN([_THISROW].[Article Année],Products[Article Année]),IN([_THISROW].[Article Quantité],Products[Article Quantité]))) My column is type ref and I put this formula in the suggested value. But the result gives all the column if I put a year that is in the column but I want just the article with this specific yea…
Even more, with a sample app:
[Sample App: Multiple (and optional) dependent dropdown filters](https://community.appsheet.com/t/sample-app-multiple-and-optional-dependent-dropdown-filters/23653) Tips & Tricks ?
I created a sample app to demonstrate setting up multiple search filters to narrow down the possibilities in a final Ref-type column. “Multi Filter Example” here: https://www.appsheet.com/portfolio/546920 This app does NOT utilize Appsheet’s implicit dependent dropdown feature, as described in the following post. The reason for this is to allow the user the option to filter by any, or all, or none, of the 4 filters, independently. Whereas the implicit dependent dropdown will auto-hide the …
…this question has been asked a lot on the community, I’m pretty sure you will find an answer among these posts:
https://community.appsheet.com/search?q=filter%20dropdown
Please see also (that may help you in writing expressions) :
[FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216) Tips & Tricks ?
Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…
Let us know if you have trouble at achieving your goal
Cheers !