ANY(SELECT

makeappsheet · 09-28-2024 04:21 AM

Good morning friends,

I have this table, "PEDIDOS", with these fields:

Y esta tabla relacionada

The ARTICLE_ID field of the ORDERS Table is a ref to the ARTICLES Table and in the INITIAL VALUE section it has this expression:

ANY(SELECT (ARTICULOS[ID_ARTICULO],[ID_PROVEEDOR]=[ID_PROVEEDOR].[ID_PROVEEDOR],FALSE))

And this related table, ARTICLES:

I need that when a SUPPLIER_ID is chosen, only the ARTICLES related to that SUPPLIER are filtered and displayed.

Now it does not work correctly for me, since the list appears complete, without selecting ITEMS by SUPPLIERS

Thank you for your time, best regards

jballester

Hola,

el contenido de la pregunta contiene puntos que llevan a la confusión, por ejemplo;

"I have this table, "PEDIDOS", with these fields:
Y esta tabla relacionada"

Para vincular datos en un desplegable de una tabla que contiene varias referencias dependientes puedes hacer uso de "Valid_if". Prueba con;

Articles([ID_PROVEEDOR])

Toda la información en;
Appsheet support - dependent dropdowns (Valid_if)
https://support.google.com/appsheet/answer/10106620