Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Making a Table from the unique values in a formula

Topic Labels: Formulas
190 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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