We want to create a high over list of products that customers are interested in, based on the following information.
When our contacts make an appointment, we can link the product(s) they are interested in. They can have more appointments with the same product they’re interested in. This is a many-more relation.
When we change the lead status of our contact, a customer journey entity is created. In this customer journey entity, we set what product they are interested in. They can have more than 1 custormer journey entity with the same product. This is a many-many relations.
A requirement of this high over list is that I should still be able to manually change the ‘interested in’ product items. So a lookup or formula is not the end solution.
I’ve tried everything I could come up with, but I can’t seem to figure out how to create a single list with an overview of all the products they’re interested in. Based on the linked product in appointment and customer journey.
There is no way to ‘union’ two collection fields using a formula.
It may be possible to create a collection field that gets updated when each of the feeder fields changes using a set of automations (linked and unlinked triggers) but it will be ugly, and users can potentially edit such a field.