We have set up a custom object with a one to many relationship with the lead. (Lead can have multiple Invoices). Instead of using a random number generated by the API (InvoiceID) can I use a combination of 2 de-dupe fields (LeadID and DebtorID) to dedupe? Where if the system sees that if the value of these 2 columns ever match that that is a duplicate? In the example below Invoice 1 and 4 would be duplicates. Is this possible? If it is, do I just indicate that both LeadID and DebtorID are both de-dupe fields? Or is something else required?
InvoiceID 1: (LeadID = 1) & (DebtorID = 1) DUPLICATE
InvoiceID 2: (LeadID = 1) & (DebtorID = 2)
InvoiceID 3: (LeadID = 2) & (DebtorID = 1)
InvoiceID 4: (LeadID = 1) & (DebtorID = 1) DUPLICATE
Did you ever get an answer on this from Marketo themselves? I can see you have no response from the community... I have a similar problem with multiple records with identical email addresses belonging to more than one workspace. I would like to add a custom dedupe field but not sure where to start...