Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Saved search with Formula (Text) help needed
Good Day
My goal is to create a saved Contact search that I can use in a Marketing Campaign.
I need to gather a list of Contacts that have purchased a model in a specific series. There are over 100 part numbers in the series, but all the parts start with the same 4 characters.
From a Contact search, I can use the Customer field, "Customer: Items Purchased" in the criteria and define it to all the part numbers, but then I have to manually include every iteration of the part number. Its ugly.
I was hoping to be able to use the Formula (Text) field and create a formula with the first four digits of the part number plus the percent (PXR3%) sign to include all iterations of the part number.