Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Making a Table from the unique values in a formula

Topic Labels: Formulas
659 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Alivia_Smith
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

0 Replies 0