Spend the time and I keep complicating with the dependant dropdown!
I have a product table with: Category Product Brand Size Colour
Another table with purchase orders and a daughter table with the order items. In the latter I have the same columns configured as Ref type and with Valid If Price list [Product] Price list [Brand] Etc.
There everything works well.
But not in the Price List table. When loading a new product does not filter the products of the category. I set them up as Enum, then as Text, and also as Ref pointing to the same table.
I tried with ValidIf Price list [Product] And with In ([_ THIS] .SELECT (Price List [Product], [_ THISROW]. [Category] = [Product])) As indicated in the article “How to make a dropdown with choices that depend on the value selected in another dropdown”
With that expression, it no longer shows the field in the form
What I want to achieve is to be able to load a new article, either from the form of the price list, or while loading a purchase order.
In my opinion, it should work only with putting Price List [Column], just like in the table of items …
I will appreciate any help!
And I take the opportunity to suggest if you could create a single document with all the information about different types of dependent dropdown, when it is applied to the same table, when applied in reference to another table, why sometimes you see “Add or Search” and others only “New” and how to control it, if using Valid If cancels the possibility of adding new items?; with many examples of use, and for what kind of need each one applies. It is one of the few more complex issues of appsheet and really very useful.
Thank you very much and a great 2019!