Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to make a simple button, that can leave out all contacts that hasn't got an email address.
I have created the Button, and added a "Select inf Field" action. First I'd just like to leave out all the contacts where the email adress is '' (just an empty string).
I have chosen the email field and then the search string I have entered is "<>'' ", but this doesn't work - it simply doesn't do anything. If I then instead change it to "=''" I get a list of customers where the email address is blank.
I can't figure out why the = works but the <> doesn't since there is definately contacts with a blank email.
I'm new to Qlickview, so maybe there are other ways to do this, but I think this should be fairly simple and straightforward.
Regards
Steen
Hi Steen,
Have you tried allowing for this in the scripting ?
eg :
if(isnull(emailaddress),'None',emaileaddress) as emailaddress,
You could then make the button select "None"
Hi,
In Button actions, Add action as select in field and search string is "". (empty).
Then add Select exclude action and use that same field.
Hope it helps.