Hello,

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 :winking_face: )

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?

thank you!