How do I automate data transfer between two SharePoint lists?

Kenny537
Kenny537 used Ask the Experts™
on
Hello,

I will try to explain this as best as I can.

We have two sharepoint lists.

List 1 is the main list

List 2 is based on an email we sent out (mail merge), clicking the customized link in that survey will link them list 2 on the sharepoint, where they will create their own row in the list, filling out the survey.

List 1 and 2 both have a primary key (ID).  

I need to find a way to automate the process where the survey responses resulting from list 2 are displayed in the correspond row (based on primary key) in List 1.  Or ideally, just merge the two rows.

Did that make any sense?  How can I do this?  

Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Anyone?

Commented:
You could use a list event receiver, or a simple workflow built through SD,

regards

Author

Commented:
What is SD?
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
Blah, don't have administrative rights on my work laptop - won't let me install it =\.

Commented:
In that case there is little you can do but ask your sharepoint developers to create a workflow for you...or ask the company to install it for you.
...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial