Solved

Copy Data to another cell in the same record

Posted on 2010-11-09
4
507 Views
Last Modified: 2012-05-10
I would like to copy data from one cell on the Account record in MS Dynamics CRM to another also on the Account record.  I see the script that you have suggeted but I have no idea how to run it. What would the workflow look like if I was to build an on-demand workflow to do this?
0
Comment
Question by:KAOSS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 34094230
The script that you saw in the related post is added to the OnLoad, OnSave or OnChange event for the form of the  account entity.

When do you want the copy of data to happen? The answer to this will decide whether the script metho(JavaScript on one of the above events) or a workflow is the best way to go.
0
 

Author Comment

by:KAOSS
ID: 34094342
This is a one time thing. I am going to copy the data from one cell to another for current records. All new records will have the info entered into the correct cell.
0
 
LVL 29

Accepted Solution

by:
Feridun Kadir earned 500 total points
ID: 34094403
In that case, I would use workflow.  You will need to use an Update Record step. Click the Set Properties button next to the step and in the Update Account screen click in the field that you wish to copy to and then on the right hand side in the Form Assistant choose Set to under Operator, Account under Look For and then the field that you want to copy from underneath Account. Then Click Add and then click OK towards the bottom of the form assistant.

Yellow hightlighted text should appear in the field that you want to copy to. Then click SAve and Close. This is the workflow. When you run the workflow the source field will be copied to the destination field.

I've attached a screenshot where I've got Street 1 being set to the value of Street 2.

hope this helps.

update-account-workflow.PNG
0
 

Author Closing Comment

by:KAOSS
ID: 34095764
Worked Perfectly!  Thank you so much for your step by step explanation (with pictures!)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question