- 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