Chr1sG
February 24, 2024, 3:52pm
7
YvetteLans:
If the campaign has product ID [1] [2] and the order has [2] [3] the orders are not linked correctly.
I was hoping that it still finds a match because [2] is present in both strings, but it seems that’s not the case?
Indeed. Comparing two collections to see what entities they have in common (or comparing two strings to see of they have any degree of ‘overlap’) is not possible as far as I know.
Still waiting on union and intersection functions
I have two list fields in my Database: Tags and [Project Tags]. (Tags is an x:many relation and [Project Tags] is a lookup of an x:many field.) I want to combine them into a single list field [All Tags], so if (eg) Tags = (foo, bar) and [Project Tags] = (baz, bam) then [All Tags] = (foo, bar, baz, bam). Is this possible? I can’t figure out how to do it with a formula or a lookup.
Extra complication: ultimately I actually want the unique set of all tags, so if (eg) Tags = (foo, bar) and [Pro…
