?
Solved

How to move souce List1 Data to Targer List2 data and how to use choice column value in target list coulmn through lookup column?

Posted on 2011-03-10
6
Medium Priority
?
355 Views
Last Modified: 2012-05-11
Hi,
I am having two list one is source list List1 and target list List2.List1 has some column with choice value and when the user will enter new row/value in List1 then the same value i want to populate in List2.
Exp: Source:  List1-> Manager name(Choice Type),Request Date(TodayDate),UniqueTag# (Autogenerate-Text)

In the target list we have  total 30 column where first 3 column are same as List1 which user entered just now. When User will enter the data in List2 , i want the first 3 col should be autogenerate from List1 because as user has already entered the value previously.
I can see the use of Lookup value in SP2007 but when i select the "Get information from:" i.e. List1 then "In this column:" i am getting only text type col name here ,the choice col is not listed here in "In the column" .
So i can see here only my "UniqueTag#" column because its a text col here.
How to achive this with lookup technique or any other idea.
Pls Note:Our Client is now allowing for any custom coding for SP2007 in .net.

Please Help.
Thanks
0
Comment
Question by:neenavishwakarma
[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
  • 3
  • 3
6 Comments
 
LVL 12

Expert Comment

by:Hairbrush
ID: 35097674
Have you considered using a workflow created in SharePoint designer to automatically create an item in list2 when you finish creating the item in list1?
0
 

Author Comment

by:neenavishwakarma
ID: 35097818
no i have not done through workflow...how its possible?
0
 
LVL 12

Accepted Solution

by:
Hairbrush earned 2000 total points
ID: 35098012
Do you have SharePoint Designer 2007?  If not you'll first need to download and install it.

Then, take a look at http://office.microsoft.com/en-us/sharepoint-designer-help/create-a-workflow-HA010100591.aspx
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:neenavishwakarma
ID: 35234041
we did have SharePoint Designer 2007 means my company didnt have that but in couple of month they are in process of deploying Nintex workflow.Is that will help for same.Can i try in this workfolw as your suggest soluction.Pls let me know
0
 
LVL 12

Expert Comment

by:Hairbrush
ID: 35234102
SharePoint Designer 2007 is a free download (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42&displaylang=en)

You could use Nintex to create a similar workflow, if you prefer.
0
 

Author Comment

by:neenavishwakarma
ID: 35234295
yes i know SharePoint Designer 2007 is free now but they are already in process...
i will try with Nintex.  thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

764 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