Skip to main content
Question

Help with a custom data rule formula

  • September 23, 2020
  • 0 replies
  • 54 views

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 check that your items are available during your event dates. Thank you!"
)

The [Not available] field is a lookup field, so I'm trying to say that if it contains any dates, to show this message. However, I'm getting an error that says that on the left hand side of the operator "=" is of type textlist while the expression true on the right hand side is of type bool. The operator "=" cannot be used with these types of expressions.

Thanks!


------------------------------
Megan Hardison
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • September 23, 2020
The 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
------------------------------