Solved

Is it possible to add fields from the related list item to a Task form generated by SharePoint Designer by using the "Collect Data from a User" action?

Posted on 2013-01-16
4
1,934 Views
Last Modified: 2013-07-02
I have a custom approval workflow that I created using SharePoint Designer 2007.  The workflow uses the "Collect Data from a User" action.  The Generated form contains the Title and Description fields, an Approval Status radio button list, a comments multi-line text box, and a link to the related item.  I would like to display a few fields from the related list item so the approver knows what he or she is approving without having to click the related item link.  I added a Data Form Web Part to the top of the Task Form but I need to filter it so only the related item displays.  In the list that the related item is stored in, there is a tracking number column.  That tracking number is the same as the link text for the related item link in the Task form.  When I try to "Send a row of data" from the Task form to the related item's Data Form to use as a filter, the only option I have is the "WorkflowLink" column.  If I choose that, the "Create a hyperlink on" drop-down list is empty and I cannot complete the Web Part Connection Wizard.  Any ideas on how I can expose the related item link text value to the item list Web Form as a filter?  Currently, my only tool is SharePoint Designer 2007 so .NET code is not an option.

Thank you.
0
Comment
Question by:BLEIP
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:sharepointguru14
ID: 38797686
I may not be following what you want to do correctly so I apologize if I got this wrong. But I would get rid of your webpart. Open the task edit for in Infopath designer. You can create a new data source and have that linked to the related item list. In the properties there you can create a filter and you can then filter with items on the current item so in other words your current item:tracking number = Related list datasource: tracking number.
This will then filter the datasource to only items with that tracking number and you can now use this datasource to set field values or just display the results in the form.
0
 

Author Comment

by:BLEIP
ID: 38820501
Unfortunately, we don't have InfoPath and we only have MOSS 2007 Standard.  Is there a way to do something similar in SharePoint Designer?  Basically, I want to add a couple more fields from the list item that the workflow is running on to the SharePoint Designer generated form that is created when the "Collect Data From a User" action is added to the workflow.  I set the "Collect Data From a User" action to ask the user whether they approve or reject the document and to allow them to enter comments.  When the task is assigned to the user, the user is going to want to know what he or she is approving.  Right now, there is only a "Related Item" link which doesn't tell the user much unless he or she clicks on it (which navigates away from the task screen).  I'd like to display a few fields from the workflow item on the "Collect Data" task form so the user doesn't have to click the "Related Item" link.
0
 
LVL 15

Accepted Solution

by:
sharepointguru14 earned 500 total points
ID: 38821394
Open the Approval Workflow in SharePoint designer.
Click on Approval to edit task process.
Add another text field named "your field" on the task form.
Click ‘Change the behavior of a single task’.
In the ‘Before a task is assigned’ section, add an action ‘Set task field’. Set the "your fields" column to get the value of Current Item: ColumnName.
Publish the workflow.
0
 

Author Comment

by:BLEIP
ID: 38845074
Sorry but I'm having a little trouble following you.  I open up SharePoint Designer 2007 and I can either open the workflow for editing or open the form that was created as a result of using the "Collect Data from a User" action and edit it.  I do not see an area where I can "Change the behavior of a single task" and I'm not seeing a "Before a task is assigned" section.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

932 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now