I think maybe I posted this to Slack or Bitbucket, and I think there have been some sort of revisions to the lookup statement, but I’m still having a problem with this code:
local bucket
global postit
bucket=«First Name»+«Last Name»
City=lookup("New Panx Alex Mail","FullName",bucket,"City","",0)
if error
postit="true"
field Address
stop
endif
Address=lookup("New Panx Alex Mail","FullName",bucket,"Address","",0);Doesn't work!
State=lookup("New Panx Alex Mail","FullName",bucket,"State","",0)
Zip=lookup("New Panx Alex Mail","FullName",bucket,"Zip","",0)
Country=lookup("New Panx Alex Mail","FullName",bucket,"Country","",0)
«HomePhone»=lookup("New Panx Alex Mail","FullName",bucket,"HomePhone","",0)
email=lookup("New Panx Alex Mail","FullName",bucket,"email","",0)
Field «Date Received»
postit=""
It all works fine except for the line starting with Address. That line alone returns a blank, though the field in the source DB is not blank. It doesn’t matter if I change the order of the lines. I did check to make sure that I don’t have a typo or a subtly different field name. But evidently since all the other lookup lines work as expected, I’m making a programming error. I’m quite sure I don’t have a variable named Address. (Is there a way to list your variables?)
I’m really stumped, hope someone else can see what dumb mistake I’m making…
Thanks,
Bill