I want to trigger an update to a Salesforce object when a Google sheet is updated, where I’m mapping the data from one column into 1 of 6 different fields in Salesforce. IE, if the Sheets cell A2 contains “Event”, then field Event is TRUE in Salesforce, but if A2 contains “Call”, then field Call is TRUE in Salesforce.
RN, I’m using 6 different look up tables, one for each field - for event field, use lookup table with if A2=Event, then TRUE, otherwise blank.
Is there a better way to do this?
Best answer by DanversView original