BigCommerce - Hosted Ecommerce Software by Interspire

Interspire Forum

 
Go Back   Interspire Forum > Interspire Email Marketer Community Forum > Customization and Integration

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 12-12-2011, 07:47 PM
pieter + pieter is offline
Interspire Customer
 
Join Date: Dec 2011
Posts: 3
Default "In between" segment rule for custom field zipcode

I have a contact list with about 50.000 contacts. I need to create segments by state, and the only way to do this is to look at the zipcode.

For example state X has zipcode 4000 to 6000.
I can only use 'is' and 'contains' what means I have to create 2000 rules.

Isn't there a way to use the in between rule for custom fields?
  #2  
Old 12-13-2011, 08:52 AM
masilon + masilon is offline
Interspire Customer
 
Join Date: Jan 2004
Posts: 170
Default

yes but you have to create the zip code field as "Number Only" custom field
  #3  
Old 12-13-2011, 08:56 AM
pieter + pieter is offline
Interspire Customer
 
Join Date: Dec 2011
Posts: 3
Default

That makes perfect sense. I created it as a textfield because the Dutch zipcodes also contain characters, like 5000AM..

Looks like I can't change the field now..
  #4  
Old 12-13-2011, 09:44 AM
masilon + masilon is offline
Interspire Customer
 
Join Date: Jan 2004
Posts: 170
Default

>Looks like I can't change the field now..
It is not possibile to change the field type. I think the only solution is to dowload the list, create the new zip code number only custom field and to reload the list correctly mapping the zip code value to the new zip code field.
  #5  
Old 12-13-2011, 09:47 AM
pieter + pieter is offline
Interspire Customer
 
Join Date: Dec 2011
Posts: 3
Default

That's a very good idea. I'll try that. Thanks!
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump