Making a Table from the unique values in a formula

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

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!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.