Solved

Pulling data from Goldmine to Excel

Posted on 2010-09-16
2
595 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

823 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