im busy investigating how to do this, and if anybody has some guidance that would be great. :)
I have 3 lists.
An Application object consists of a Candidate and a Position.
Currently, I am creating a Position, creating a Candidate, and then creating and Application using both.
Is it possible to, at the Candidate level, select a position from a Position Lookup field and then on save, automatically create an Application object? Using the Candidate object, and whatever positions is selected (multi-select)
First time using Sharepoint and Sharepoint Designer, so I'm playing around a bit with the workflow editor but now sure Im getting it right...
If anybody has some workflow experience and might have some pointers for me, I would appreciate it. :)
Update: Here is my workflow so far for the 'Candidate' list, and is kicked off when an item is created.
So here I cam creating a new item in 'Job Applications' (I dont understand yet what the 'Output to Variable' field means, and have left it untouched)
For the 'Applicant' field, I am assigning it 'CurrentItem:ID', which I assume is the ID required for the Candidate object lookup field which that 'Applicant' field has.
For the 'Position' field, I am assigning it 'CurrentItem:Applications'. This field under Candidates is an 'Positions' object multi-select lookup field. (So we can select multiple positions the applicant is applying for from the 'Position' object list.)
So with all that done and said, no new Applications object is created when a new Candidate object is created with those fields supplied.
Am I doing something wrong still?