Is there a way to search for customers using a set...
# beginnersc
Caleb Fong
06/19/2020, 6:50 PMIs there a way to search for customers using a set of zip codes? I tried just doing a customer search with
zipCaleb Fong
06/19/2020, 6:54 PMI could set up a stack of
ORCaleb Fong
06/19/2020, 7:01 PMThere is 164 in the set, so I'd rather not have to make each one it's own line.
b
battk
06/19/2020, 7:02 PMbattk
06/19/2020, 7:02 PMAlthough in your case, the formula is easier to work with in the ui
c
Caleb Fong
06/19/2020, 7:03 PMI'll check it out. TY!
t
Tony Zuko
06/22/2020, 9:54 PM@Caleb Fong I built a special tool for this that generates a formula for you to use. https://docs.google.com/spreadsheets/d/1eK38CDt5nDB4EMKlTNgspgRGLUXn4GLTf7nC5o_r6SY/edit?usp=sharing
Tony Zuko
06/22/2020, 9:55 PMThere are instructions in the template that should be fairly comprehensive
c
Caleb Fong
06/22/2020, 10:06 PMOh! Thank you! I was struggling to wrap my brain around the SQL commands
Caleb Fong
06/22/2020, 10:06 PMI’m not super versed in the text language of databases.
t
Tony Zuko
06/22/2020, 10:07 PMTotally! I’ve never shared this outside my org., let me know if you have any questions 🙂
c
Caleb Fong
06/29/2020, 5:42 PM@Tony Zuko It took a smidge of trial and error, but I got the formula to do what I wanted/needed! Thank you so much for such a fantastic little tool!
t
Tony Zuko
06/29/2020, 5:42 PMAwesome! 😄 I really appreciate that feedback!
c
Caleb Fong
06/29/2020, 5:44 PMdouble checks output Hmm I may have been a little premature in my celebration. BUT I am a heck of a lot closer to a solution, and with a bit more tweaking I think I'll get it.
Caleb Fong
06/29/2020, 5:44 PMThis is not a negative about the tool, just need to work out how to properly use the formula.
t
Tony Zuko
06/29/2020, 5:58 PMGotcha, I think Zip Codes are on a separate address record so I can definitely see how it could take an extra step to link them. Are you having trouble getting the right results columns?
c
Caleb Fong
06/29/2020, 6:03 PMI had a different filter line that was reducing the count of records too soon. Once I took that out, the numbers went up to what I was expecting.
Caleb Fong
06/29/2020, 7:38 PMIs there an easy way to filter down to just the unique values in the results?
I know I can group, but that doesn't quite cover it.
t
Tony Zuko
06/29/2020, 8:37 PMI can’t think of anything besides using grouping when you put it that way. But if you’re “that close” to something in NetSuite, it means there’s almost always a creative way to do it, but sometimes you need to back out of a specific solution a little and take a slightly different approach. What problem are you trying to solve?
c
Caleb Fong
06/29/2020, 8:54 PMSo I'm trying to generate a list of customers within a geographic range (see the zip codes), and I want to glean their emails to target them them with a new shipping service announcement email.
Such as it is, there are some replicated entries, because people move or what have you. But if their email is consistant I can focus on showing them a new valuable service and less time trimming the 'fat' off of this csv.
Caleb Fong
07/06/2020, 3:51 PMWell the long/short of it was, an manual tightening of the list. We're not likely to run this search often so ... I guess this is fine. But I'm not fully satisfied.
2 Views