Hide button based on 4 input text fields.
This is the formula that is inserted button / property / visible:
If(And(!IsBlank(Firmanavn.Text),!IsBlank(Adresse.Text),!IsBlank(Postalkode.Text), !IsBlank(Cvrnr.Text)),true,false)
But I'm getting syntax error.
Thanks for your help
Solved! Go to Solution.
Hi @ bitvrbit:
Do you want the button control to be visible when all four of these TextInput controls are not empty?
I did the same test but didn't encounter the problem you said:
Set the button’s visible property to:
If(And(!IsBlank(Firmanavn.Text);!IsBlank(Adresse.Text);!IsBlank(Postalkode.Text);!IsBlank(Cvrnr.Text));true;false) /* Same as your code*/
To find the problem, I suggest you check the following two points:
1\The name of your Text Input control: Did you quote them correctly in the formula?
2\ In some region, “;” represent “,”, “;;”, represent “;”,maybe you can try:
If(And(!IsBlank(Firmanavn.Text);!IsBlank(Adresse.Text);!IsBlank(Postalkode.Text);!IsBlank(Cvrnr.Text));true;false)
In addition, I think
And(!IsBlank(Firmanavn.Text),!IsBlank(Adresse.Text),!IsBlank(Postalkode.Text), !IsBlank(Cvrnr.Text))
is enough. For brevity, there is no need to use "if"
Best Regards,
Bof
Hi @ bitvrbit:
Do you want the button control to be visible when all four of these TextInput controls are not empty?
I did the same test but didn't encounter the problem you said:
Set the button’s visible property to:
If(And(!IsBlank(Firmanavn.Text);!IsBlank(Adresse.Text);!IsBlank(Postalkode.Text);!IsBlank(Cvrnr.Text));true;false) /* Same as your code*/
To find the problem, I suggest you check the following two points:
1\The name of your Text Input control: Did you quote them correctly in the formula?
2\ In some region, “;” represent “,”, “;;”, represent “;”,maybe you can try:
If(And(!IsBlank(Firmanavn.Text);!IsBlank(Adresse.Text);!IsBlank(Postalkode.Text);!IsBlank(Cvrnr.Text));true;false)
In addition, I think
And(!IsBlank(Firmanavn.Text),!IsBlank(Adresse.Text),!IsBlank(Postalkode.Text), !IsBlank(Cvrnr.Text))
is enough. For brevity, there is no need to use "if"
Best Regards,
Bof
Thank you very much v-bofeng-msft thank you .you don't know how much time I have lost for this function. I gladly accept info for syntax for beginners. ciao ciao 🙂