This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi, folks.
Let’s say you have a base with two fields: Pet (single line text) and Fruit (multiselect: Apples, Bananas, and Oranges).
Turns out that the comma is used as a multiselect field separator. After much trial and error, the following CSV impor...
Greeting from beautiful Austin, Texas!
I’d like to suggest a new logical operator, “IN”. It would return true if any value matched the field.
It would look something like this:
IN({myTestField}, “text1”, "text2,…)
or
IN({myIntegerField}, 2001, 2002, ...
Hey, Bill. I would assume that the underlying software would look at the field type. For text fields (like single select) it would have to match the entire field.
For example, if( IN({myTextField}, “apples”, “pears”), “fruit”, “not fruit”)
would be e...
