Hi ALL,
Today I startet with Appsheet with google sheets.
Ok I think it a great application if I only get to work.
I reed a lot a real lot and pulled some youtube tutorials but I guess the most are all old versions.
I read a lot over here and allot of toppic are a dead endโฆplease ban the ones that donโt replay the solution.
Finally I ask it me self over here
See the image.
the Categorie set fills the dropdown with > Valid_if โ lijsten[Categorie] โ < I can pull it down and al items are there and working fine.
but if I do that with AXACTLY the same settings with > Valid_if โ lijsten[Element] โ < the item disappears completely from the form.
I read thisโฆ
"@Edgaโฆ Hi Edgar, regarding the original problem: this problem has nothing to do with the Valid_If expression. Rather, the problem is caused by the use of the columnโs app formula.
Any column that has an app formula is a read-only column, i.e. the app user cannot edit the column. This is because the app will automatically compute the columnโs value using the formula. If it also happens that the formula in question generates a blank/empty value, and the column is a required column, then the app user will face a conundrum: the column must be filled out because itโs required, yet it is blank and also read-only. In such a situation, the app user will be prevented from submitting the form even though they have done nothing wrong. As the app user are unable to do anything to remedy this situation, the app will automatically hide the column so that the app user can proceed with filling out and submitting the form."
but why is it working with Categorie column and not with te element column.
thanksโฆ
EDITโฆ
HAAAโฆif I set te Categorie list as Valid_if Lijsten[Element] the Element shows on the form and the Categorie list has the Element items and the Element also has the Element. if I put it all the Categorie list back to Catagotie againโฆthe element list disappaers again from the form
Youโve stumbled upon a โfeatureโ:
This has nothing to do with the behavior youโre seeing: you donโt appear to be using an app formula.
There wasnโt any formula. I guess playing with all the goodies I did something wrong. I donโt know what. Just started all over and now its fine got a nice working app nowโฆand manny more ideas.
Thanks Steve.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |