Hey! I am having great fun learning and setting up n8n for pushing new email subscribers into our Salesforce account received via a webhook.
My question is specifically around dealing with Picklist fields in Salesforce. For example, our leads in Salesforce have a picklist field called ‘communication preferences’, this could be for example ‘summer’, ‘winter’, ‘spring’ and ‘autumn’.
When using the USPERT or UPDATE node for Salesforce, I can’t find a way to change the settings to append data, rather than overwriting data.
If the lead comes in with a different first name, overwriting this data field in Salesforce is the correct approach. However for the communication preferences as an example, the lead may come in with ‘summer’, but already have ‘winter’ in their lead profile in SF. Currently, the node overwrites the field to just be ‘summer’, but ideally it would be ‘winter;summer’ as we don’t want to lose this preference information we gained at a previous time. So I want to append the preference, but the node defaults to overwriting.
Is there a way to define if a field is appended or overwritten? Does anyone have a clever workaround for this?