Hi, I have 4 fields in our opportunity entity that I was using as calculated fields and populating based on other field values within the same (or a related) table. Limitations on the number of calculated fields we can have is forcing a different approach, so we are creating a new simple field for each value to replace the calculated field. It seems that a workflow would achieve the same thing. It is two simple If-then-else processes that set the field values of the 4 fields.
The workflow logic is straightforward, but I don't know how to automatically trigger the workflow when new records are imported en masse.
Since we are changing the field to a new simple field, I will also need to either run the work flow on all 37K records currently in the table, or export and import with the revised fields populated. Any help on making this easier with the 10K export record limit would be appreciated as well.
*This post is locked for comments
I have the same question (0)
