CRM Software - CABC | Maximizer | Maximizer Add-ons | Services | Support | Store | News

    Find out about Linktracker for Maximzier
CABC    Maxtalk  Hop To Forum Categories  Maximizer CRM Software  Hop To Forums  Maximizer Support    Convert UDF from Table to Alphanumeric
Go
New
Find
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Member
Posted
I need to do this so that I can use Copy and paste for a macro, to copy field information from UDF's to Basic information.
 
Posts: 17 | Location: Durban, South Africa | Registered: June 07, 2001Reply With QuoteEdit or Delete MessageReport This Post
Maximizer Specialist
Picture of CABC Support
Posted Hide Post
There is a way to convert a single value table into an alphanumeric UDF.

However I am a little bemused as to why you want a macro to copy information from a UDF to a Basic Info field.

What is the purpose of your intended macro?
 
Posts: 498 | Location: PO Box 162,Newbury,Berks | Registered: January 03, 2000Reply With QuoteEdit or Delete MessageReport This Post
Member
Posted Hide Post
I want to copy information like the address fields out of the UDF area to the Basic info area. In South Africa we have an address via a private company int he legal market, and we use that instead of postal. But all the users until now have captured this into the UDF area. It would be too much PT to add a new address to each contact.
 
Posts: 17 | Location: Durban, South Africa | Registered: June 07, 2001Reply With QuoteEdit or Delete MessageReport This Post
Member
Posted Hide Post
Do tell! How does one convert a table UDF to text?
 
Posts: 30 | Location: Auckland, New Zealand | Registered: April 05, 2001Reply With QuoteEdit or Delete MessageReport This Post
Maximizer Specialist
Picture of CABC Support
Posted Hide Post
OK - but please note that I said a 'single value' table!

There isn't an automatic way to convert the table but it isn't too difficult if your table field doesn't have to many items.

Simply follow these steps:

1) Create an alphanumeric field

2) Then for each item in the table field

2a) Search for that item on the table field

2b) Select the whole list and then Global edit the item value onto the alphanumeric field.

3) When you have done this for each item delete the table field.

4) Rename the alphanumeric field to that of the table field (you could have called it the same name to start with if you don't mind getting confused!).

You could only do this with a multi value table if you prioritise the items and global edit the most important item last (possibly overwriting less important items).
 
Posts: 498 | Location: PO Box 162,Newbury,Berks | Registered: January 03, 2000Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

CABC    Maxtalk  Hop To Forum Categories  Maximizer CRM Software  Hop To Forums  Maximizer Support    Convert UDF from Table to Alphanumeric

© CABC Ltd 2002 - 2005. All Rights Reserved.
Maximizer is a trademark of Maximizer Software inc.