At the moment two records have a checkbox which equals true which is pulling in the relevant information using the filter feature in template builder but is there a way to prevent the ‘Creator Name’ from populating multiple times if it is the same name? For example, there could be 5 records belonging to one Creator, we need all the information pulled in from each record but ideally we don’t want the name repeated 5 times.Recap/Suggestion from A5 Apps Consulting:
This button is merging from some object that has the related list and you want to merge values from the related list for one record basically because it’s the same value. Then merge multiple records from the related list.
Is there a way to get that single value of Creator Name on the main/base object instead of merging it from the related list? That would be an easy fix. You may be able to merge the field without a table if that would work to merge one value. And last thinking is there any way to filter to have 1 record for that first merge.
Final Client Solution:
Created some workflow rules to get the ‘Creator Name’ onto the Parent Object, so the document is now merging the Creator Name once. Also have a filter to pull in records that have a checkbox ticked.