Apparently, there is no reasonable or feasible way to mass update a record's related list

Apparently, there is no reasonable or feasible way to mass update a record's related list

  • I have a module called “Properties”
  • I have a module called “Segments”
  • each Segment record will have a related list of several hundred properties and each property may belong to more than 1 segment (yes it’s a multi-lookup field)
  • Lets say I have a Segment record called “Chenai-Krishna” and I need to select several hundred properties to add to its related list “Properties” below.

 

My problem is there is no way (and definitely no good, simple or reliable way) to select a few hundred Property records in bulk and add them to the related list in my “Chenai-Krishna” Segment record.

  • Mass update does not offer lookup fields
  • Macro does not offer lookup fields
  • Trying to add records from the assign button in the related list does not allow me to filter the records
  • Deluge programming has no api call to bulk update a related list
  • Deluge programming has all kinds of complications and limitations regarding how many records can be retrieved at once and how many records can be updated at once

This process of assigning Properties to Segments is something I have to do all the time, and I need to establish a process for this to happen simply and reliably