Limit Office Choice on Address
I have a project table that has a choice for office and the project address. Depending on the input of address I want it to display a message if the project office and the address do not align. I trie...
Forum Discussion
If([Project Address: City]= "Longwood Medical Area",
This line is missing the second part of the formula. So that would probably cause some unexpected behavior.
Also you do not need to nest your ifs like that. You could remove every if you have except the first one and get rid of your long tail of parenthesis and it would work just the same. Quickbase will continue down the formula until it hits something that matches or show your else which would be N/A in your above formula.
If(
[My Field] = "Something", "Do This",
[My Field] = "Something Else", "Do That",
"Nothing matched!"
)
One thing you should make sure to do when testing a form rule is that once you type into the address box, the city part, make sure to click somewhere else in the form. Any other text box and then the form rule should fire. It doesn't consider the field changed until you click into another one, to give you time to type everything you need. Depending on how your form rule is set up it it may not fire at all.
That said this may not be the best approach to doing this. Unless you don't think the formula will grow much larger than this. It would just be a nightmare to maintain I think.
This line is missing the second part of the formula. So that would probably cause some unexpected behavior.
Also you do not need to nest your ifs like that. You could remove every if you have except the first one and get rid of your long tail of parenthesis and it would work just the same. Quickbase will continue down the formula until it hits something that matches or show your else which would be N/A in your above formula.
If(
[My Field] = "Something", "Do This",
[My Field] = "Something Else", "Do That",
"Nothing matched!"
)
One thing you should make sure to do when testing a form rule is that once you type into the address box, the city part, make sure to click somewhere else in the form. Any other text box and then the form rule should fire. It doesn't consider the field changed until you click into another one, to give you time to type everything you need. Depending on how your form rule is set up it it may not fire at all.
That said this may not be the best approach to doing this. Unless you don't think the formula will grow much larger than this. It would just be a nightmare to maintain I think.