10-23-2015 11:43 AM
I inherited a database that needs some major adjustments due to various incorrect values entered and an import from a previous database gone wrong.
We have one multi-pick list that allows for over 5,000 records that needs to be updated. There are 11 values that need to be swapped for other values in the list. Some of the values are duplicates; differiented by a space.
For example, the value in the list will look like this:
_Broker - Developer *this is the incorrect value used
Broker - Developer
Is there away to bulk modify certain values in a multi-pick list. Eventually, I want to be able to delete those 11 values.
Does that make sense?
10-24-2015 07:12 AM
You will want to use the Edit | Replace function in Act! to get this accomplished. Prior to doing so, please do a backup (File | Backup) because there is not an "undo" option once you do the replace.
Below are the instructions to do the global replace on a lookup.
11-13-2015 09:49 AM
I'm having a problem that I sure hope you can help with. I'm trying to change the "stage" of multiple records from "Estimate Performed" to "Estimate Issued". Here's what I've tried so far:
1. Created a group that segregates all records matching the "Estimate Performed" criteria.
2. Did a group lookup, then an edit --> replace field.
3. A two-field drop-down dialogue box appears.
4. First drop-down asks me which field, next asks me for a value.
Problem is, the first drop-down doesn't include the "stage" field.
Any help would be much appreciated!
11-13-2015 10:08 AM
Unfortunately, the Stage field in the Opportunity section cannot be globally replaced within the native Act! application.
If you are working with an ACC (Act! Certified Consultant), they should have some tools to fix this for you. If you are not, let me know and I can assist you.
11-13-2015 10:37 AM - edited 11-13-2015 10:39 AM
Does this help http://www.freeactaddons.com/free-addons/opportunity-updator
11-13-2015 10:59 AM
Only hesitation on trying it comes from the warning that Chrome gives me.... something to the effect of "This file is not commonly downloaded... Could be harmful"?
11-13-2015 11:02 AM