How to Update Salesforce Standard Fields with Google Form

Have you ever tried to update standard fields in Salesforce using a Google form and found that it's not working? You're not alone. This is a common issue that many users face. But don't worry, we've got a solution for you.

The Problem

When trying to update standard fields like FirstName, LastName, BillingStreet, BillingCity, BillingCountry in Salesforce using a Google form, the flow only updates the custom fields on the account record. The standard fields remain unchanged, and it's not clear why this is happening.

The Solution

The issue lies in the mapping. If you look at the mapping, it's "Answers.Address: Pincode.Grade.Feedback.textAnswers.answer:value" which is incorrect. The correct mapping should be "Answers.Address: Pincode.textAnswers.answer:value". So, you need to get the text answer value, not the grade.feedback.text answer. Once you correct the mapping, the flow will update both the standard and custom fields in Salesforce.

Troubleshooting Tips

  • Check if the values from the Google form that you're mapping into the standard fields are non-empty.
  • Try the Get Record Module and enter the record id to check if the record is updated with all the values you mapped from the Google form.
  • Make sure that the Answers object is an array. If there is just a single element in that array, you can simply put a "1" between the square brackets in every mapped field that includes square brackets. That will retrieve the first element of that array.

Conclusion

Updating standard fields in Salesforce using a Google form can be tricky, but with the right mapping, it's definitely possible. Remember to check your mapping and ensure that the values from the Google form are non-empty. With these tips, you should be able to update both standard and custom fields in Salesforce without any issues.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.