Solved

Pulling data from Goldmine to Excel

Posted on 2010-09-16
2
592 Views
Last Modified: 2013-11-15
***This was posted in another Zone (MS Excel) apologies for any duplication****

I have a spreadsheet which pulls customer data from goldmine using the following syntax.

=IF((GoldMine|Data!'CONTACT1->PHONE1')=0,"",(GoldMine|Data!'CONTACT1->PHONE1'))

This particular syntax pulls the phone number for the customer.

My users leave this spreadsheet open all day and flick to through different cases. Sometimes the phone1 field is blank, when this occurrence happens, the previously viewed goldmine record phone number remains in view on the spreadsheet. I would like the formula to check the Phone 1 field and if its blank, then clear the cell in goldmine rather than leaving the previous phone number in view.

Any ideas?
0
Comment
Question by:daiwhyte
2 Comments
 
LVL 12

Accepted Solution

by:
GMGenius earned 500 total points
ID: 33690531
I left a message on that question , you have not responded to it, it might shed some light
0
 

Author Closing Comment

by:daiwhyte
ID: 33742495
Thank you.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

GoldMine CRM has a fairly open database architecture , however in this case the email distribution list is stored in a quirky way and does not allow easy access for external use. This article will give details of this and provide a method to extr…
Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now