Can we use one field from Salesforce to Map to two fields in Netsuite
Can we use one field from Salesforce to Map to two fields in Netsuite
0
Can we use one field from Salesforce to Map to two fields in Netsuite
Comments
Thanks for posting this question Nishant.
Can you please provide more details on which field from Salesforce you would like to sync to multiple fields in NetSuite? Theoretically, it's possible but we would like to have more clarity before confirming.
Thanks!
Hi Sushil,
Thank you replying.
So I have a picklist field in salesforce which is mapped via Integrator flow (Standard flow) via static look up to a picklist field in Netsuite.
So the requirement is that we need to map this picklist field from salesforce on the same object in Netsuite. Is there a way we can achieve this?
Please let me know if you need any further clarification.
Kind regards,
Nishant
Thanks for the clarification, Nishant. Yes, we can use one field from Salesforce to map to two fields in Netsuite. This is possible through the use of expressions in flow mappings. For example, in the case of address fields, Salesforce stores all addresses in an address text box (single field), while NetSuite stores address in individual lines (two or more fields based on the configuration set). To map and split multi-line address from Salesforce to multiple address lines in NetSuite, you need to use an expression in your flow mappings.Here is an example of how to map Salesforce Address to NetSuite Address Lines 1, 2, and 3:
1. Refresh the “Export Field (Salesforce)” and “Import Field (NetSuite).“
2. Map ShippingAddress1 export field to Shipping Address 1 import field.
3. Map ShippingAddress2 export field to Shipping Address 2 import field.
4. Click field setting next to Shipping Address 2.
5. From the settings box, select “Multi-Field.”
6. Enter the value {{ShippingAddress2}}in the Expression text box.
7. Click Save.
8. Map ShippingAddress3 export field to Shipping Address 3 import field.
9. Click field setting next to Shipping Address 3.
10. From the settings box, select “Multi-Field.”
11. Enter the value mentioned below into the Expression text box:{{#if ShippingAddress2}}{{regexReplace (regexReplace ShippingStreet '' ShippingAddress1 g) ''ShippingAddress2 g}}
12. Click Save.
13. Click Save.This process allows you to map a single Salesforce address field to multiple NetSuite address lines. The same principle can be applied to other fields as well.
Let me know if this helps, Thanks!
Hi Sushil,
Appreciate your reply!
My requirement is quite straight forward. So I have a field say "X" which is a pick list field in Salesforce which I want to populate on "A" and "B" pick list field in Netsuite. So I want to map it in the following way:
Salesforce------------------>Netsuite
Field "X" -----------------------> Field "A"
Picklist x------------------------Picklist a
Picklist x1-----------------------Picklist a2
Picklist x2----------------------Picklist a1
Similarly,
Field "X" -----------------------> Field "B"
Picklist x------------------------Picklist b
Picklist x1-----------------------Picklist b1
Picklist x2----------------------Picklist b2
I am asking this because at the moment Field "X" is mapped to Field "A" via Celigo. And the requirement is that I need to populate Field "X" from Salesforce into another new field in Netsuite Field "B" as well.
Can we achieve this or do I have to create another field in Salesforce and then map it to Netsuite?
Happy to have a call.
Kind regards,
Nishant
Hey Nishant,
Apologies for the delay in the response. Yes, you can achieve the above scenario with mapping and settings as shared in the below document.
https://docs.celigo.com/hc/en-us/articles/360042707152-Map-picklist-multi-select-fields-in-Salesforce
Thanks!
Please sign in to leave a comment.