Help with a custom data rule formula
I'm trying to add a custom data rule for a table that will come up with a message for the user. Can you help me figuring out whats wrong with this formula? If ( [Not available] = true, "Please ch...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe syntax error is a field type mismatch. The lookup field looks like it might be a multi-select field or some kind of text field and you are trying to use it as if it was a checkbox field.
What is actually in the field you are checking against?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
What is actually in the field you are checking against?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Got an error on both. Here's what they said below. Any other ideas? Thanks so much to you both for helping me!
The first error: Formula Error -- Type Mismatch
You may need to do one of the following to fix the problem:
------------------------------
Megan Hardison
------------------------------
The first error: Formula Error -- Type Mismatch
| The expression [Not Available] on the left hand side of the operator "=" is of type textlist while the expression "" on the right hand side is of type text. The operator "=" cannot be used with these types of expressions. |
You may need to do one of the following to fix the problem:
- Add a type conversion function.
- Choose a different operator.
The function name IIf(bool, text, text) is unknown.
------------------------------
Megan Hardison
------------------------------
- MarkShnier__YouIn the second version, remove the extra I in IIF in the IF. s/b IF not IIF.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Oh shoot. Sorry!
Now it works, but once the error comes up and they check it and the dates are okay, how do they save? It wont let me save.
------------------------------
Megan Hardison
------------------------------- MarkShnier__YouI think that we are really not understanding at all what is in that field when you do want to allow save and when you do not.
Maybe Custom data Rules is the wrong tool for the job.
Can we start over and have you say in words what you are trying to do, with an example or when you want to allow save and when you do not.
You should also make an example for your self in the actual app so you know what is actually in that field.
Mark
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------