.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

How do I get column values in Sharepoint designer so I can use them as a variable in code block?

Posted By:      Posted Date: September 05, 2010    Points: 0   Category :SharePoint
The code below is in my EditForm.aspx and it works but instead of it outputting "This is just a test!" I need get a number that is stored in a column named Phone Number that has 5555555555 stored in it and have the line that says TD2.innerHTML = "This is just a test!"; ouput what ever number is stored in the Phone Number column. Here is the code that is in my EditForm.aspx <script type="text/javascript">function DisplayItemID(){       var TD1 = document.createElement("TD");       TD1.className = "ms-formlabel";       TD1.innerHTML = "<h3 class='ms-standardheader'>Test</h3>";       var TD2 = document.createElement("TD");       TD2.className = "ms-formbody";       TD2.innerHTML = "This is just a test!";       var IdRow = document.createElement("TR");       IdRow.appendChild(TD1);       IdRow.appendChild(TD2);       var ItemBody = GetSelectedElement(document.getElementById("idAttachmentsRow"),"TABLE").getElementsByTagName("TBODY")[0]; 

View Complete Post

More Related Resource Links

Updating list item values in SharePoint Designer using code

Is it possible to programmatically modify the SharePoint objects using SharePoint Designer Object Model. By that I mean coding in SharePoint Designer (not Visual Studio). For example, can we access the list items of a list programmatically and change their values? I can do all this in Visual Studio using SharePoint Object Model but I don’t find a way of achieving this by using programming in SharePoint Designer. I searched through http://msdn.microsoft.com/en-us/library/bb208639(office.12).aspx but no success. If the answer is yes. Can someone please give example(s) or point to some articles etc? Thanks in advance.

Sharepoint: In Calculated Column, Code with multiple "IF" condition does not work.

Implemantation:  Calculate expected resolve date exclude "Saturday" and "Sunday"  based on Priority and Severity.Columns are:1. Priority:2. Severity:3. Raised on: Date record createdCode: Below is the code which contains multiple "If" conditions. For quick undersatnding, i separated major If condition. Below code does not work and sharepoint gives me Sytax error message. =IF(OR(Priority="Critical",Severity="Critical"),IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+3,[Raised on]+1),     IF(OR(Priority="HIGH",Severity="HIGH"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+4, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+4,[Raised on]+2)) ,   IF(OR(Priority="MEDIUM",Severity="MEDIUM"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+3),"dddd")="Saturday",[Raised on]+5,[Raised on]+3)) ) ,   IF(OR(Priority="LOW",Severity="LOW"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+6, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+6, IF(TEXT

Sharepoint Designer 2007 Variable Data on a form

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? 

Sharepoint Designer 2010 modified view breaks "hyperlinks" column and formats all hyperlinks to the

I have been trying to perform a simple task with sharepoint designer 2010 that keeps breaking one of my list colums (in the custom view that is).  Background:  I have a list that we are using to assist with Document control in our organization.  The list consists of a few columns: Document number, Title, Owner, Doc Type, and file link (hyperlink to a pdf).  When I create a new out of the box standard view, everything works as desired.  However, I need to adjust the column widths on a couple columns in SharePoint designer, which seems to break the file link column functionality (all of the hyperlinks are now formatted to go to the same document, thought the file paths in each list item are correct).  Funtionality of the file links column works perfectly, until I make a single change to the view in SharePoint designer and save.  Any insight on this issue would be greatly appriciated.  

"How to get distinct values of sharepoint column using SSRS"


    I have integrated sharepoint list data to SQL Server reporting services. I am using the below to query sharepoint list data using sql reporting services.

   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
         <Parameter Name="listName">
            <DefaultValue>{GUID of list}</DefaultValue>
         <Parameter Name="viewName">
            <DefaultValue>{GUID of listview}</DefaultValue>
         <Parameter Name="rowLimit">
<ElementPath IgnoreNamespaces="True">*</ElementPath>

By using this query, I am getting a dataset which includes all the columns of sharepoint list. Among these columns, I wanted to display only 2 columns (i.e Region and Sales type) using chart. I have created a Region parameter but when I click

how to trim a string value of a workflow variable using SharePoint designer.


I build a custom workflow using SP designer and have a need to trim a string value of a workflow variable. I tried using Calculation or Dynamic String builder but without success.

i store a user name type value into workflow variable called  check_name_var (string type). the logon name have this format  domainname\first_lastname 
how do i trim this value in check_name_var to only first_lastname.

Can anyone show me how or have suggest on how to accomplish this or is it possible to do this in SP designer?

Thanks for your help

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

Summing a calculated column with comma's in sharepoint designer



Sharepoint designer has the trait of getting goofed up with calculated columns that display with a comma.  I typically deal with this by doing a format-number(number(translate(@MyCalculatedColumn,',','')), ###$%%^formatstuff).  this replaces the comma's with nuthing so it will format as a number.

I'm trying to do a sum now...is this possible?


  <xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row[contains(@FileRef,$TheIDweWant)]"/>
  <xsl:variable name="zNumMales" select="sum($Rows/@MaleLives)"/>
  <xsl:variable name="zTotalMaleVolume" select="sum($Rows/[number(translate(@MaleVolume,',',''))])"/>

The zNumMales works fine...it's just a number column populated by a workflow.

The zTotalMaleVolume is calculated, has commas so it displays as blank, we need to get rid of the comma's.  the above syntax is upchucked...anyone happen to know what it is?



How to get distinct values of sharepoint column using SSRS: paramter Greyed out


I'm referring to a previous thread: How to get distinct values of SharePoint column using SSRS.  I followed all the steps as set out but when I view my report, the parameter is greyed out.  I then downloaded the example report of Jin Chen.  In that report, he suggests a blank parameter label for the main parameter, as well as, a default value for the hidden parameter (which is different from the initial thread posted).  When I change my report accordingly, I get an error: An error occurred during local report processing. MainParameter.  Anyone with suggestions?

Sharepoint Designer - Conditional Formattting with column not in view


I'm trying to apply conditional formatting to a view and it works, but only if all the columns the conditional criteria are based on.  

This sort of defeats the purpose since I want to just highlight an the Title of the list item if a column within the list item that is not currently visible meet my criteria. I'm trying to save screen real estate space by displaying fewer columns and also to try to increase page rendering time. However, I doubt I'd really be decreasing page load times if I'm still requiring even data that is not displayed to be read.  

Anyone know of a workaround?  

How to use VB code in SharePoint Designer



I am new in SharePoint Designer.

I like to create a web page with some VB code functions (I want to convert one web site that created by Visual Studio 2005 to SharePoint server with SharePoint Designer tool).

But I always get the error when I tried to copy the VB function from Viscao Sdeio 2005 to SharePoint Designer's page.

Can you help me on this or send some example to me?



Xiao Qi

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!

Assign SharePoint list sum total value to a sharepoint designer workflow variable


I have a similiar question and get answered but the solution is possible but not simple as I thought.   So I like to ask it again

I use SPD to build a workflow and I need to be able to get a SharePoint list column sum total value to assign to one of the workflow variable.

Do anyone have a similar situation and have came up with a solution , please share

Environment is  MOSS 2007 /SP2.

Thanks you so much in advance.


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.

How to set the column values and add attchment in document library in sharepoint using webservice.



Can you please provide me C# code to add attachment in document library and set the column values in document library.For this I can use only Web Services and not the object models





SharePoint Designer

This video series shows you how to quickly and easily build complex business solutions on the SharePoint platform. Microsoft Office SharePoint Designer 2007 Business Administrator Training is a one-and-a-half hour, 300-400 level training series, produced in collaboration with the SharePoint Product Team and Total Training
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