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
------------------------------
Hi Mark,
Thanks for getting back to me. :-)
The [Not Available] field is a lookup field. Its looking at a field in another table that's a summary field showing when the item is being used. I just want to say that if there's something in that field, I want the user to double check that its not being used during the dates they want it.
Do you know if there's another way to do it?
Thanks so much for your help!
------------------------------
Megan Hardison
------------------------------
Thanks for getting back to me. :-)
The [Not Available] field is a lookup field. Its looking at a field in another table that's a summary field showing when the item is being used. I just want to say that if there's something in that field, I want the user to double check that its not being used during the dates they want it.
Do you know if there's another way to do it?
Thanks so much for your help!
------------------------------
Megan Hardison
------------------------------
- See if this works for you:
If (
[Not available] = "",
"",
"Please check that your items are available during your event dates. Thank you!"
)
------------------------------
Brad Lemke
------------------------------- MarkShnier__YouIf Brad's suggestion does not work, try this
See if this works for you:
If (
ToText([Not available]) = "",
"",
"Please check that your items are available during your event dates. Thank you!"
)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
