Solved

Pulling data from Goldmine to Excel

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
User problems installing software 7 82
android why multi records for one contact 5 97
Inventory Management 6 98
Find Duplicates in 2 EXCEL 2007 Spreadsheets 3 98
Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
The need for Texting We all wear many hats. Part of this article's focus is the marketing hat... and another part is the consumer hat. Those of us who are consumers frequently are either ambivalent toward, or hiding from... those of us who are mark…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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