I’m trying to build a lookup between a list of web conversions that are classified by type and a text field for each of these types. (The use case is to use for email personalisation in a CRM based on different types of conversions)
The issue I’m running into is that my type today is set by a formula field
Here’s an example of what I want (unrelated, I know nothing about cars it’s just an example )
Type = IF (Find(“Volkswagen”,Name),“Volkswagen”, “Other”)
Volkswagen Mini // Type = Volkswagen // Lookup = I’m happy to hear you have a Volkswagen.
Volkswagen Van // Type = Volkswagen // Lookup = I’m happy to hear you have a Volkswagen.
Blue Honda // Type = Other // Lookup = I’m sorry to hear you don’t have a Volkswagen.
I want my lookup to be a central list in a table, do I need to be working on a JS script here?