.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Sharepoint Designer 2007 Variable Data on a form

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
I am a lifetime COBOL programmer trying to make a new career in a Sharepoint world. I am working on a project where I have created a list of Employees.  Almost all of the employees on the list must update their status on a day-to-day basis. A view was created on this list using [ME] as the search criteria to only return the employee who is updating his own info. With Sharepoint Designer 2007 I created a custom form. I cut and pasted the code for the view that I described above and then created a series of buttons to allow the employee to choose a status. For each button, I built a workflow to do the specific updates to the employee's list line. I was able to set up an onclick event for each button to execute a Javascript function that would go to the webpage and start the workflow.  I got the actual workflow URLs from the Sharepoint Intranet webpage after I completed each one. Here is my problem (and it is probably my inexperience that has got me stumped); The URL that is fed to the Javascript function has a hard-coded number representing the ID field of the Employee list (that is what probably sets the "Current Item" in the workflow.  I can see that the listview from above the buttons has the ID field as one of its Fieldrefs.  How can I substitute some kind of ID variable in the set of parameters that is fed to the Javascript? 

View Complete Post

More Related Resource Links

How can I show data from a Workflow variable in a SharePoint Designer Collect Data from User form?



I have collected some data (a comment) from a user in a SharePoint Designer (SPD) workflow step and I now want to display that comment in a second "Collect Data from User" form at a subsequent step in my workflow.  How can I add the content of my Workflow data variable, or even data from my original item, in the Collect Data from user form?

The Collect Data from user form is generated out of the Workflow Tasks list and only contains the url of the item where I could store the comment and which has the workflow attached to it.

This guy says he has done something similar but he appears to only use the URL and static info and does not explain the detail in any case: http://www.mstechblogs.com/paul/spd-workflow-collect-data-from-a-user-modify-the-generated-task-form

I'm keen to hack at the aspx form in SPD but I really need the particular line of code that will do it as I'm not a developer.

Your help is greatly appreciated!

Commit Variable from SharePoint Designer 2010 to an InfoPath Form 2010


I saved a string into a SP Workflow 2010 variable, and want to pass this variable to an InfoPath 2010 Form, so that I can display/use this string in the Form.
Please tell me how to commit that.

Thank you in adnavce!

Kind regards,
Milan Stojadinovic

Passing data into a Sharepoint Designer Form Action workflow


I have a workflow that is triggered by a "Custom Action" on a "Form Action Button" that I added to a DataFormWebPart in SharePoint Designer. So the workflow isn't associated to any list or document library. What I need to do is pass some data to this workflow so that it can do some useful stuff.

I see from here that Natalya Voskresenskaya shows a method that allows you to pass a single list item value into a workflow variable but if you hack this into the aspx file as suggested, when ever you subsequently open design view and the workflow on the button again, all the hacks are removed by SPD.

I have tried this method and it seems to work for one variable, but I cant figure out how to pass more than one. Here is another post that is very similar but slightly different.

In this post Ibrahim said on April 1st 2008:

"I am having difficulty building a Javascript string for my particular requirement; SPD had already built a concat

How to attach Custome Edit form to Document library using Sharepoint designer 2007



I have created lot  of costom .aspx page using  sharepoint desgner 2007 and attached to custome list successfully .   tha same  approach i followed for document library in moss 2007 . but i tried to attach that form to docment libarary  its giving error "The page you have selected does not contain a reference to the correct SharePoint list".  i ahve googled  to sort out the problem  and find out  content type should be 'Item' type. but this is document library  so  content  type is document . ther is no ther option  for Item.

Please help me to come out from this   problem.

I have created custom form using sharepoint designer 2007 .


Thanks and regards

Jandel Singh 



Sharepoint Designer 2007 not showing the updated site summary usage data


HI All,

I have sharepoint designer2007 in my production server.That Sharepoint designer is not showing the updated usage reports.It is showing only from 2008 Nov to 2009 Apr hits and downloads.But if i look in the site directly for the site usage reports site is showing updated reports properly.But Why not in the Sharepoint designer? And one more catch here is the same sharepoint designer displaying the updated usage reports for the sites which is running in other server.Can any one help on this issue please?

Thanks in advance Sreeni

Selecting a Task List in Sharepoint Designer 2007 while setting up "Collect Data from User"

When using Sharepoint Designer 2007 to Collect Data from User the task list cannot be selected.  Instead the Task list that is defaulted is the most recently created Task List.  How can I select a specific Task list to associate with"Collect Data from User"?

How to update Workflow variable cross-workflow in SharePoint Designer 2007?


Hi All,

created two SharePoint designer 2007 workflow, which attached WF1 to Pages and WF2 Workflow Tasks List,

then I created a workflow variable in WF2,

can I update the variable in WF2 by action in WF1?

appreciated any help, thank you.

Trying to send email using Sharepoint Designer 2007 workflow and email enabled list


I have a a list that recieves email. I have few fields that shows me the originator: "E-Mail From" and "E-Mail Sender".

I am trying to create a workflow that will generate an auto reply to the originator but the SPD fails to recognize the email address in these two fields. It's either truncating part of it or uses the html ( href=mailto:Demo@DemoSomething.com) in the To field.

Thank you,


Submtting Calendar items with variable date information via InfoPath 2007 form



I've seen several posts regarding submitting to a list using and InfoPath form which I am successfully able to do in limited form. (only passing a basic date value) My environment: MOSS 2007 Enterprise w/SP2, InfoPath 2007, SPD 2007.

I'm basically trying to recreate a calendar form with the same data elements (and some additional ones for a specific business requirement) as the standard calendar newform.aspx form. (start time, end time broken down by date, hour, minute and All day event)

I need the form users to be able to select the date and if it is not an All day event...be able to select the hours and minutes just like on the newform.aspx. (date picker control for date and drop downs for hour and minute selection)

On submit I then need to create the list item with the appropriate data passed via a workflow.

My Start Time has a validation rule to not allow dates prior to the current date (and it can't blank) The End Time has a validation rule to not allow dates prior to what is specified as the Start Time value. (Also can't be blank) When I attempt to include conditonal formatting to hide the hour and minute drop downs if 'All Day Event' is selected I get errors stating the fields can't be blank.

I also can't figure out how to pass the entire date/time values or the All Day Event to the list withou

How to Establish a Remote Web Site Connection in SharePoint Designer 2007


I am modifying a SharePoint site and so far so good.  Some of the objects were created using Visual Studio 2008 (C#).  I was able to modify these objects and implement them on the targete machine without issue.  The final step is to implement the ASPX pages that were modified using SharePoint Designer 2007.  These are aspx pages that are used to modify items in lists.  All the pages involved in this upgrade are customized.  I need to upgrade the target site with the modified version of these pages.  My intent is to copy the code from the page in the source site and past it into the same page on the target site.  I tried using the Remote Web Site connection tool in SharePoint Designer 2007 but received the following error message:

"Unable to open 'https://(site address)'.  Server Error:  Could not find a Web server at 'website'.  Please check to make sure that the Web server name is valid and your proxy settings are set correctly.  If you are sure that everything is correct, the Web server may be temporarily out of service."

I am not sure how to first check to see if the Web Server is temporarily out of service.  I would appreciate your input on how to verify this.

Background information of target machine:  WinServer 2008, IIS 7, Sharepoint (MOSS2007), site on port 80

How to create scrolling table for columns in a SharePoint Designer Data View


I have a fairly complex SharePoint Designer 2007 Data View they have added two more requirements.

1. Have the columns on the right side be able to scroll left to right as there is a large number of columns, while the first 3 columns on the left side stay locked in place.  This is only one list not two, and because of some other requirements I have it must remain to be just one list.

2. Then they also need to have scrolling up and down of the entire list with the headers locked in place.

The first requirement is more important than the second, but preferrably I need to do both.

I am new to XSL so not familar with the syntax. Is this something I can do on a custom Data View? Does anyone have any examples of how?

I have a drawing that show how it needs to look but I don't see an option here to upload a graphic.

So here is a link to my graphic example uploaded to my blog area: http://lindachapman.blogspot.com/  or just the image here: http://4.bp.blogspot.com/_aB01ue__NvQ/TGL42MOvrGI/AAAAAAAAAA4/c3xP4uCy4BU/s1600/Scrolling.png

I failed to mention that 3/4 of the columns are HTML Calculated fields wh

wss2.0 Infopath 2007 'This form requires connections to data sources when it is loaded. At least on


Hi all

I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form located on a WSS2.0 site.

The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.

I am not aware of any other users experiencing this issue.

Any ideas please?

How to show previouse user comments on the task form of a user in sharepoint Designer

I am using sharepoint designer for designing workflow. I have 4 steps. on each step a user write some comments for the next user. now I want to show all those comments on task form for the current user to whom the task has been assigned.

Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.

Importing SharePoint List Data into Project Server 2007 Custom Fields

Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.

Problem with SharePoint Designer 2007 and Custom List Forms


I created several forms (Create/Edit/View) for a SharePoint list, using Custom List Forms.  I'm using Content Types in the list to ensure that each item only has the necessary fields.  When I created the ASPX forms, and inserted the Custom List Forms, I selected the correct Content Type, and I got the right fields inserted in the form.

Now, for some reason I can't identify, every time I create a new form, and insert a Custom List Form, SPD is bringing ALL fields from the list, instead of just bringing the fields included in the selected Content Type.

I have tried many different things to solve the problem, including creating new lists/content types/forms, etc. but SPD is doing the same thing all the time.

Can somebody tell me what may have gone wrong in SPD or MOSS?


Share Point Designer 2007 Workflow (Sequential) - multi-collect data from user

I am currently building a multi-step workflow using ShrePoint designer for MOSS2007. I am getting a bit confused as to if I have an error or if I am doing something incorrect. Here is what I have going. My workflow consists of something similar to the following New document comes in, a collect data from user routine is ran and assigned to a reviewer. My understanding when I create a collect data from user WorkFlow step is any data I request is saved in the "Tasks" list. Therefore I need to grab the workflow task ID in order to later lookup what the reviewer submitted... I understand this...   However, I have one more collect data from user workflow step and I have one more item to collect. Even though this is a brand new collect data from user workflow step - does the collected data still go into the "Tasks" list? In other words, if I have two steps in a workflow and both of these steps are "collect data from user", does the data from both steps go into the same "Tasks" list?  I could see how this might be possible as long as the Task list columns contain all the items for all the different "collect" data from user steps.  I don't see two different Tasks lists representing or named "Reviewer" or "Final" or anything, so I assume the items are all in "Tasks"   However..
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend