I have created 2 custom lists in Sharepoint 2010:
List #1: INTERNAL PROCESSES (fields: Process Title, Reference)
List #2: PROCESS STEPS (fields: Step Title, Step Description, Process Title[lookup of 1 item in previous list], Department Assigned)
I created an action in the display form for list INTERNAL PROCESSES called "Create Instance"; when user clicks on it, it redirects the user to mypage.aspx?processID={itemID}
(I couldn't find a way to pass the title instead of the ID in the querystring).
So now I need to accomplish the following in mypage.aspx:
Find the item in INTERNAL PROCESSES using the ID received in the querystring. If field Reference is not NULL, ask the user to enter a value for Reference (e.g. if the Reference contains the word "Member", ask the user to enter the Member Name).
Get the Process Title from list INTERNAL PROCESSES for the ID received in querystring
For each list item in PROCESS STEPS where field Process Title matches Process Title looked up in step#2 , create a new TASK list item with the following values:
a) TASK Title = Step Title + Value entered in step#1 (if any)
b) TASK Description = Step Description
c) TASK Assigned to = Department Assigned
I'd like to avoid using code, if at all possible, because I've never done it. If code is required then please point me in the right direction.