Change custom field value for over 500 records

💬 General Discussion
1

We want to update the custom field for over 500 records in the contacts module.

Could we use the Import Contacts option to do this? Or is there another way to do it easily?

2

Multiple ways ..

  • Import (first create a report, export the CSV, change in LibreOffice Calc or similar and re-import)
  • Switch the list view temporarily to 500 records and do a mass update
  • Use the API
  • Use the DB

A mass update could become challenging with workflows (timeouts etc.)
Import: Try to only import the columns that you really need (e.g. ID, name*, your_custom_field_c)

1 Like
3

One more method I often use if the value is based on another value in SuiteCRM I use workflow to do mass updates.

1 Like
4

Thank you; it is about updating only one field for records.