ContactReview :: View topic

ClareLondon · Obsessive GoldMiner

First, here's me being good... Laughing

GoldBox 5, professional
GM6.70
build 70226
XP

So, here's me experimenting with replacing a field, but blow me, can't work out why it doesn't give me the expected results.

What I'm trying to do is to update a field to YES when an email address exists. I run Q files overnight, so always have an up to date group of contacts with eMail.

FILTER
InGroup("Clare", "Yes eMAIL")

REPLACE FIELD
Contact2->Uemailshot

EXPRESSION
"Yes"

GoldBox doesn't kick up about any of the above. All seems well. All field information is accurate. The procedure runs. And yet it produces zero results.

I running this on MAIN CONTACTS.

Could anyone throw any light, please?

Thank you!

automationstation · Sensei of the GoldMine

You could use a lookup.ini to fill this in for you:

IIF(trim(&emailaddress) < ' ',"No","Yes")

BobTaylor · GoldBox Guru

I don't see why what you are doing won't work; but it's not the "correct" way to do it. That would be using the filter

.NOT.Empty(PullEmail('MAIN'))

ClareLondon · Obsessive GoldMiner

Hi Eric

Thanks for this. I’ve only just started to introduce lookup ini into my GM, but it certainly is a valuable feature.

You could use a lookup.ini to fill this in for you:

IIF(trim(&emailaddress) < ' ',"No","Yes")

What I don’t get in the above, is how that relates to my own fields. How does that expression work in replacing my Contact2->Uemailshot field? Seems to me the lookup needs 2 components:

(a) if there is a valid email address
(b) then update field Contact2->Uemailshot

Doesn’t it???

ClareLondon · Obsessive GoldMiner

Hi Bob

Well, I'm nearer - and far-er.

I tried your filter, but it didn't pull any results.

So, I experimented with replacing a straight field value with a different value - that worked.

Then, I experimented with replacing one field value when another field had a particular value - and that worked.

Then I tried putting in a different ingroup(FILTER) - and that worked too.

Then I tried putting in my original group filter - possibly with a typo corrected, I guess, although I couldn't see anything originally - and that worked too.

Then I tried your filter again - but that didn't work.

So, I'm left with knowing that

(a) I can use an inGroup filter and that works
(b) I can use lookup ini (soon, once II've worked it out, but I'm sure I can, there's examples everywhere)

Your email filter - is it saying 'if a primary email address exists' or is it saying, if a primary email address exists, pull it out? I don't get this exactly. For instance, when I create my groups of "YESemail" - I use

isEmailAddr()

and that works okay.

Thanks Bob for any further elucidation. Fact is, every snippet of info goes into the old grey cells and is a useful build-up of knowledge.

I mean, LOOK at how much I know NOW about GoldBox in contrast with the past. I almost know.... one zillionith of what you know... think about that!