This topic contains 4 replies, has 0 voices, and was last updated by Jordan Manningham 7 years, 12 months ago.
-
Posts
-
Jordan Manningham- Contributions: 0
- Level 1
- ☆
The search returns all the customers, prospects, and leads we have. The problem is that a result is being produced for each contact at each company. We only want one result for each company.
What is some criteria that would accomplish this? There is no Main Line option for entity searches.
This is a cached copy. Click here to see the original post. -
erictgrubaugh- Contributions: 0
- Level 1
- ☆
Can you share your existing Criteria and Results columns?
You can try filtering by either "Status" or "Entity Type" to weed out what you don't need.
-
Jordan Manningham- Contributions: 0
- Level 1
- ☆
Criteria:
Status (is none of) Customer-Lost Customer, Prospect-Closed Lost
Inactive (is) false
Entity Type (is) Customer
Results:
Name
Sales Rep
Formula (Text) – '<a href=https://system.na1.netsuite.com/app/common/entity/contact.nl?id='||{activity.contact.id}||'>'||{acti vity.contact}||'</a>'
Formula (Text) – CASE WHEN LENGTH({email}) != 0 THEN '<a href=mailto:'||{email}||'>Send Email</a>' END
Phone
Formula (Text) – '<a href=https://system.na1.netsuite.com'||{custentity_link_lsa}||' >'||{custentity_link_name_lsa}||'</a>'
-
david.smith- Contributions: 0
- Level 1
- ☆
Might be your first results formula. If you ask for any sublist records, like contacts, it will return more than one result for that customer.
-
Jordan Manningham- Contributions: 0
- Level 1
- ☆
Just removed that results column. No duplicate results!
Much thanks!
You must be logged in to reply to this topic.