validif list does not turn up all data list

[aminsaleh]

Hi

In my google sheet DB file I have a table called database

inside it there is a column called size (contains about 45 sizes)

>> in my app size column I have this validif 

SELECT(Database[Size],TRUE)

which should read tlist of sizes from the sheet. But the problem it only reads about 18 sizes and does not show other sizes. Even I used search and nothing found.

[A-Yavuz · Accepted solution]

Hi,

I am not sure but that might be due to the name(database) that you use as table. It might be a reserved word in Appsheet. My suggestion would be to try it with another name.

Best

[aminsaleh]

@A-Yavuz 

Thanks very much, yes indeed that helped.

I think appsheet should have an alert system to warn us once validating a formula or an expression against using any system reserved syntax.