 | Org Chart - Multiple Fields per Level? |  |
 Posted: Fri Feb 08, 2008 1:49 am |
Points: 0  |
|
| radioflyer |
| GoldMine Journeyman |
|
 |
| Joined: 01 Oct 2007 |
| Posts: 33 |
| Location: Belvidere, IL |
|
|
|
|
|
 |
|
I have a client who wants to have org charts set up to run automatically in GoldMine 7 to group all contacts working in individual buildings at large corporations. I have GoldBox 7 running and have been playing with the Virtual Org Chart functionality to create them.
The problem I have is that while I can get the org charts to create multiple levels deep, I can only get it to work on single fields. So a sample org chart looks something like this:
Parent Company
_City
__Address
___Individual
What the client wants is to combine two fields, so it would look like this:
Parent Company
_State, City
__Address
___Individual
Is there a way to combine two fields in a single level? I tried adding them together and it didn't give me an error. However, it also didn't combine the two fields.
I'm hoping I'm just setting something up incorrectly. Any help would be appreciated.
Thanks in advance,
Bob |
|
|
|
|
| | |
| Posted: Fri Feb 08, 2008 2:48 am |
Points: 0 |
|
| BobTaylor |
| GoldBox Guru |
|
|
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
|
|
At the bottom of the OrgChart page on my site, I show a screen shot of an OrgChart that is set up using State/City in one field. In the chart, the entries are populated by dBase expressions (or fields). In this case, the expression is:
| Code: |
| IIF(Empty(Gview4th->State).AND..NOT.Empty(Gview4th->City), Trim(Proper(Gview4th->Country))+", "+Gview4th->City, IIF(.NOT.Empty(Gview4th->State).AND.Empty(Gview4th->City), Trim(Gview4th->State)+", City Unknown", Trim(Gview4th->State)+", "+Gview4th->City)) |
|
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
ContactReview Forum Index » GoldBox
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin
|
