Segment a list based on a numeric custom field

neilgd72

neilgd72

New Member
Hi,

Is there any way of adding a numeric custom field? For example, I'd like to have a (private) custom field with how far away a customer is from me in miles, and then segment based on eg <50, <100 and so on.

Thanks!
 
I believe a regular text field will do it as well. Internally, MailWizz checks if the value is numerical and if it is, the comparison against the database is made against a numeric value, so it should do exactly what you're after.
 
Thank you! That works great, but it also includes customers with a blank (i.e. null, or empty string) field. Is there any way of excluding those? Thank you again!
 
It depends on your conditions I guess, but if you have specific conditions like FIELD > 5 AND FIELD < 10 then it should leave empty fields alone. But again, you should play and see.
 
You must log in or register to reply here.
Back
Top