Hi Guys
I have the following example scenario to illustrate the requirement. On sales order a new lookup field is created for countries. Countries entity contain guid (PK), code (AU,NZ) and Description (Australia). Now when I create the relationship as expected I can select a country in order form. My requirement is to populate a custom field on the order with the country code instead of guid. I know how to do this via Javascript. Can the same be achieved via workflow when saving the record (only required after saving for integration to another system). Related question is what are pros and cons of using:
1. Javascript
2.Workflow (classic not PA)
3. plugin
The problem I have with plugins is its complicated when using "update" event as a user may update the country selection after the initial insert.
My biggest problem with JS is code maintenance , its all over the place and I cannot easily see everything in VS code or VS like plugin. I wonder how people manage JS code without loosing track. Classic workflow i havent played around much but some talk of MS deprecating. I dont like PA no code stuff as its hard understand after adding 10-20 steps unlike C# programming plus licensing is an issue when working with clients.