Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Nov 22, 2021 03:52 AM
Hi
I have a lookup field that is displaying values from a multiple select field, which I have converted into a comma-separated format.
Let’s say the values in that field (field A) are:
Cat, Dog, Antelope, Lion
I have another field (field B) that has the possibility of having at least some of the same values as the first field. It might look like:
Lizard, Elephant, Cat, Eagle
The order of the variables is, well, variable because the user may enter them in whatever order they wish.
What I need to do is evaluate whether any of the terms in field A match any of the terms in field B.
In this case, it would return true because ‘Cat’ appears in both.
Thanks!
Nov 24, 2021 11:48 PM
Unfortunately this isn’t currently possible in a formula because formulas can’t iterate through a collection of items and perform operations on each item in the collection. However, this is definitely doable with a script, either in a Scripting app (available to anyone) or an automation script action (available in bases that are in Pro-plan workspaces or higher).