How to mass update the text fields?

Hi,

How to mass update the text fields in sugar 7.2.x?
There is no option from to studio of Mass update for text fields.
Can somebody advise?

Thank you,
Usman

Parents

0 Usman Saeed over 11 years ago

Thank you Frozen for the help.
My business logic was like that.
Client want to see the contact-name,email and Mobile on the Opportunities list view so that he can export the opportunity with the contact details.

I created the text fields and put formula of related contact field.
So, I need to mass update the fields.
In the list view I selected all the records and than recalculate the values instead of mass update and it did the trick.

@chris for querying to database. You can use logic hooks, esp before_save or after_save.
http://support.sugarcrm.com/02_Documentation/04_Sugar_Developer/Sugar_Developer_Guide_6.5/03_Module_...
check this and in the hook function you can use the global db variable to do custom queries eg.
global $db;
$db->query("SELECT /update/ insert query");
for fetching $db->fetchByAssoc($query);

Thank you, for helping.
Usman

Reply

0 Usman Saeed over 11 years ago

Thank you Frozen for the help.
My business logic was like that.
Client want to see the contact-name,email and Mobile on the Opportunities list view so that he can export the opportunity with the contact details.

I created the text fields and put formula of related contact field.
So, I need to mass update the fields.
In the list view I selected all the records and than recalculate the values instead of mass update and it did the trick.

@chris for querying to database. You can use logic hooks, esp before_save or after_save.
http://support.sugarcrm.com/02_Documentation/04_Sugar_Developer/Sugar_Developer_Guide_6.5/03_Module_...
check this and in the hook function you can use the global db variable to do custom queries eg.
global $db;
$db->query("SELECT /update/ insert query");
for fetching $db->fetchByAssoc($query);

Thank you, for helping.
Usman

Children

No Data