How can I filter in a form?
I want that when I'm selecting in estat, "Magatzem"
only appears in subestat: "mecanitzat" and "pintant"
thks in advance
JVS
Solved! Go to Solution.
Try this without True
IF( [ESTAT]= "Magatzem" ,
{ "mecanitzat" , "pintant" } ,
{ "mecanitzat" , "pintant" , "comprat" } )
Go to column [SUBESTAT] and use this function in Vaild If
IF( [ESTAT]= "Magatzem" ,
{ "mecanitzat" , "pintant" } , True )
Hi Izzat, thks but
appears this error message
"IF function is used incorrectly:the second input (value-if-true) and third input (value-if-false) should have the same type."
Try this without True
IF( [ESTAT]= "Magatzem" ,
{ "mecanitzat" , "pintant" } ,
{ "mecanitzat" , "pintant" , "comprat" } )
Izzat, thks a lot for your help!
You are welcome.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |