Hello AppSheet community,
I'm building an application and I'm having an issue with data validation in one of my columns. I have a field called "Fecha acordada con el estudiante" (Agreed Date with the Student) in one table (let's call it MainTable). I want the valid values for this field to come from a column called "Fechas Nivelaciones" (Leveling Dates) in another table called Fechas (Dates).
Currently, in the "Data Validity" section of the "Fecha acordada con el estudiante" column, I have the following formula:
= Fechas[Fechas Nivelaciones]
The problem is that the dropdown list generated in the application is not showing all the values from the "Fechas Nivelaciones" column in the "Fechas" table. This column contains approximately 150 unique values, but only a few are displayed in the validation dropdown.
I have verified that:
The table and column names match exactly (MainTable, Fechas, Fechas Nivelaciones).
The data type of the "Fechas Nivelaciones" column in the "Fechas" table is Text (or the data type that contains the dates).
My questions are:
Is there a known limit to the number of items that can be displayed in a data validation dropdown?
Could there be a performance or initial loading issue causing not all values to be displayed?
Are there any additional settings I should check to ensure that all values from the referenced table are available for validation?
I would greatly appreciate any help or suggestions you can offer to solve this problem. Thank you in advance!
LinkedIn
Twitter
