Share
ReportHi,
Is there any way in CRM interface to get the list of records that are exceeded the size of X characters for a specific field.
Thanks,
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi,
Is there any way in CRM interface to get the list of records that are exceeded the size of X characters for a specific field.
Thanks,
*This post is locked for comments
Hi Sam,
You can try some work around to find that.
Option One: If you want to manually update field content from 20 to 10.
1. Add new checkbox as "FieldLength".
2. Build a simple custom program to check the field length in the related Field and check the "FieldLength" box if more than 10.
3. Use adv find to query for all the records with "FieldLength" been checked.
4. Export the data and manually update the record and import back into CRM.
Option two: If you want to automatically truncate the field content from 20 to 10.
1. Build a simple custom program to check the field length, if more the 10, just truncate to 10.
Yeah, it is a text field . Account name, Contact, Phone number fields
Hi Prashanth,
The initial length of the X field is 20 characters and that field contains some records that is having 20 characters. Now that I want to reduce the field legth of that to 10 characters. However, when I change that field length to 10 characters, the old data which is 20 chars still remains in the old fields and after the change it allows only 10 char in X for the new records.
So, Now I want all the list of records for which that is having 20 char.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (