In this webinar, our experts showcase a variety of demo use cases of how different components of the...
While migrating data from a legacy system to Microsoft Dynamics CRM, you might run into a situation where you need to migrate dropdown values from a source system to CRM using Scribe. This task may take some time given the fact that in Scribe, you can use "if" conditions to accomplish the task. It can become tedious to write "if" statements for a long list of dropdown values.
To overcome this, you can use the DBLOOKUP2 formula. You can query on the stringmap table which stores all the mapping between dropdown text and values.
Here are the steps to accomplish this:
Scribe is a powerful tool to migrate /integrate data to Microsoft Dynamics CRM and make your migrations a lot less cumbersome. If you found this blog valuable, check out our other blogs about migrating data into CRM with Scribe!
Happy CRM'ing!
If you want to map a source field to a CRM picklist field, you can map the source string directly to the CRM picklist (integer) field. Scribe will understand what you're trying to do and convert this to a picklist value automatically. No need for the dblookup.