Salesforce: More than 1 record matched the given creteria and could not be updated. Make sure the condition matches exactly one record
Hi, i'm having difficulty with a recipe between Google Sheets and Salesforce where a new sheet row in Google Sheets creates or updates a Campaign Member on Salesforce.
Error message: More than 1 record matched the given criteria and could not be updated. Make sure the condition matches exactly one record
However, I am using the Contact ID ... so its not possible that it matches more than one record?
Best Answer
P
Patricia Guevarra
said
almost 6 years ago
Hi Saul,
This error might be due to the fact that you have one contact in multiple campaigns. This causes an error because the recipe becomes unsure which one it should be updating -- should it be the contact under Campaign A, or the contact under Campaign B? The best way to go about this is to to do a search for the campaign member populating both the Contact ID field and Campaign ID field. This means that it will look for the contact that fulfills both conditions. From there, you can do two conditional actions -- if the Campaign Member is present then update it, if not present then create it. Do let me know if anything is unclear!
Answer
Patricia Guevarra
said
almost 6 years ago
Hi Saul,
This error might be due to the fact that you have one contact in multiple campaigns. This causes an error because the recipe becomes unsure which one it should be updating -- should it be the contact under Campaign A, or the contact under Campaign B? The best way to go about this is to to do a search for the campaign member populating both the Contact ID field and Campaign ID field. This means that it will look for the contact that fulfills both conditions. From there, you can do two conditional actions -- if the Campaign Member is present then update it, if not present then create it. Do let me know if anything is unclear!
Saul Macht
Salesforce: More than 1 record matched the given creteria and could not be updated. Make sure the condition matches exactly one record
Hi, i'm having difficulty with a recipe between Google Sheets and Salesforce where a new sheet row in Google Sheets creates or updates a Campaign Member on Salesforce.
Error message: More than 1 record matched the given criteria and could not be updated. Make sure the condition matches exactly one record
However, I am using the Contact ID ... so its not possible that it matches more than one record?
Hi Saul,
This error might be due to the fact that you have one contact in multiple campaigns. This causes an error because the recipe becomes unsure which one it should be updating -- should it be the contact under Campaign A, or the contact under Campaign B? The best way to go about this is to to do a search for the campaign member populating both the Contact ID field and Campaign ID field. This means that it will look for the contact that fulfills both conditions. From there, you can do two conditional actions -- if the Campaign Member is present then update it, if not present then create it. Do let me know if anything is unclear!
Patricia Guevarra
Hi Saul,
This error might be due to the fact that you have one contact in multiple campaigns. This causes an error because the recipe becomes unsure which one it should be updating -- should it be the contact under Campaign A, or the contact under Campaign B? The best way to go about this is to to do a search for the campaign member populating both the Contact ID field and Campaign ID field. This means that it will look for the contact that fulfills both conditions. From there, you can do two conditional actions -- if the Campaign Member is present then update it, if not present then create it. Do let me know if anything is unclear!