In Tamanhos(s) i have in valid_if:
SELECT(
unidades[tamanho],
[of] = [_THISROW].[numero_of]
).
It returns the correct sizes in almost all OFs, but in some like this example I sent it is exchanging one size for another, and I can’t find the error.
Olá Felipe:
I assume that by:
is exchanging one size for another,
You want to say that Tamanhos(s) appear in a different order than what’s in your table.
In my view this is not caused by AppSheet but by how your dara source is returning values.
To straighten this you need to use Orderby(…)
If I understand your table structure correctly, in the “unidadas” table, the “of” columns needs to record the “id_armazem” value and not the “numero_of” value.
You would then also need to adjust the “of” column configuration to be a REF type column to the “arazem” table. Additionally in this table you would set the “numero_of” column as the LABEL column so that the correct value is displayed.
I hope this helps!
