cubanGuy
  • Member for 7 years, 9 months
  • Last seen more than a week ago
2 answers
9 votes
37k views
get list of all users SharePoint using REST API
Accepted answer
4 votes

You may want to take a look at this link: Users, groups, and roles REST API reference. As noted by the comments from @eirikb and @Vadim, the url you are using will never give anything close to a list ...

View answer
2 answers
5 votes
25k views
Caml Query Datetime
2 votes

have you tried combining CAML with JavaScript? Get the current month: JS: var monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "...

View answer
4 answers
1 votes
1k views
jQuery not working properly
2 votes

Have you tried: $("select [title='Option']".on('change', function(){ alert("yes"); });

View answer
1 answers
0 votes
6k views
Cascade drop down lists in SharePoint 2013 using jQuery, REST and AJAX
Accepted answer
1 votes

The answer to my question was simpler than what I thought.I just added an "onchange" event to the select element itself: <select name="stateDD" title="state" id="stateDD" onchange="populateCounty(...

View answer
2 answers
2 votes
5k views
the IF(OR) statement
1 votes

Ok, I deleted the previous answer. Now I'm back in the office in a SP environment where I can test. This worked for me: =IF(OR([Project ID]="A1",[Project ID]="A1",[Project ID]="A1",[Project ID]="A1",[...

View answer
3 answers
2 votes
6k views
XSLT: Set the background colour of cell when the task is overdue
1 votes

I have used something similar to what you need: My XSLT: <xsl:attribute name="style"> <xsl:if test="ddwrt:DateTimeTick(ddwrt:GenDisplayName(string(@Test))) &lt; ddwrt:DateTimeTick(...

View answer
4 answers
0 votes
5k views
How to get the list item column values based on the html drop down and display in the alert box using Javascript?
1 votes

This should do it. But you have to use jQuery and SPServices in order to make it work. You can create a simple HTML Select (If the options will not increase) or just can populate using SPServices in ...

View answer
2 answers
0 votes
84 views
Datasheet style forms
1 votes

Try this: Create a Data View Web Part Select the Data Source Select the fields you want the user to be able to modify On Data Source tab, select 4.1 "Select Selected Fields as..." 4.2 "Multiple ...

View answer
2 answers
2 votes
7k views
Calculating Fiscal Year
1 votes

This formula should work: =IF(DATE(YEAR(Created),10,1)>Created,YEAR(Created),YEAR(Created)+1) This is an adaptation from this link. Created is a column that stores what the name implies. I hope ...

View answer
1 answers
0 votes
1k views
Wrong format by ddwrt:Today()
Accepted answer
1 votes

You are missing "FormatDateTime". In my case would be: ddwrt:FormatDateTime(string(ddwrt:Today()),1033,'dd') This link may be helpful too: Custom Date and Time Format Strings I hope this helps.

View answer
3 answers
1 votes
5k views
Cascading dropdown not working
1 votes

Have you tried adding the "parentColumn" option also? This is something I tried a while ago and wrote some comments that may be helpful. //State - County Dropdown list $().SPServices....

View answer
2 answers
1 votes
4k views
how to use getuserprofileByName in infopath?
1 votes

Have you tried the jQuery library SPServices (SPGetCurrentUser)? var thisUserName = $().SPServices.SPGetCurrentUser({ fieldName: "Title", debug: false });

View answer
1 answers
2 votes
2k views
How to add link to Title field when list data is fetched using REST API and rendered through Datatable.js
1 votes

I'm not a programmer, but probably you can try something like this: HTML: <table width="100%" cellpadding="0" cellspacing="0" border="0" class="display" id="example"> <thead> <tr> ...

View answer
2 answers
0 votes
703 views
Use Google Visualization with Datatables plugin and which get data from REST
Accepted answer
1 votes

I went ahead and used HighCharts plugin and SPServices library, and it works great. The fileds (columns) in the answer are not the same as in the question, because I created a test SP list, but you ...

View answer
2 answers
0 votes
106 views
Change the text of a td based on its content in SharePoint 2013 (XSLT)
0 votes

After all, I found a solution that worked. I want to post it here just in case it helps somebody else. <xsl:choose> <xsl:when test="@Closing_x0020_Date = 'Null'"> <td class="ms-vb"&...

View answer
2 answers
0 votes
489 views
New list form does not add entry to list?
0 votes

Something similar happened to me a while ago. Check the XSLT code in SP Designer and look for something like this: <SharePoint:SPDataSource runat="server" DataSourceMode="List" And change it to: ...

View answer
2 answers
1 votes
2k views
REST API: Show each unique item only once while retrieving categories from a list
0 votes

I have drop-down list that I populate using element fetched from a SharePoint list.Some of the rows are repeated, in order to eliminate the repeats this is what I use. JQuery: var alreadyUsed = {}; ...

View answer
1 answers
0 votes
363 views
SP2013: List with columns "Lookup (information already on this site)" display as URL's
Accepted answer
0 votes

Something similar happened to me a while ago, and the solution was to modify the XSLT using SharePoint Designer: Look for the tags that should look like this: <xsl:value-of disable-output-escaping=...

View answer
1 answers
0 votes
177 views
How to extract data from the list and put it in the form using jquery
0 votes

Try this: HTML <label for="ageList">Age from List</label> <input type="text" id="ageList" /> <br></br> <label for="ageForm">Age from Form</label> <input ...

View answer
3 answers
0 votes
67 views
Need help in Calcuated column formula
0 votes

What I would do would be to recreate/ export this list to Excel and try to replicate the scenario there first. SharePoint formulas work just fine in Excel, it will allow you to check the formula step ...

View answer
2 answers
4 votes
3k views
Adding data views and data sources
0 votes

I really hate SPD 2013, and what happened to you is one of the many reasons. Go to the code and click anywhere inside the tag. <WebPartPages:DataFormWebPart> and the Add/Remove Columns should ...

View answer
1 answers
0 votes
595 views
How do you send data from Excel to SharePoint?
0 votes

The only thing I've seen similar to what I think you are trying to do is when you have a Custom List and export it as an Excel file to your desktop. This file in your desktop remains connected to ...

View answer
4 answers
0 votes
3k views
Using REST call and Datatables plugin to retrieve SharePoint Date field
Accepted answer
0 votes

I found out that all that is needed is to add this to the column containing the Jason Date: function LoadAIP(state) { var call = $.ajax({ url: "https://xxxx/xxxx/_vti_bin/listdata.svc/AIPList? $...

View answer
6 answers
1 votes
10k views
Filter list data using SPServices, CAML Query, and dropdown list
Accepted answer
0 votes

This actually worked with the query: CamlQuery = "<Query><Where><Eq><FieldRef Name='Regional_x0020_Office' /><Value Type='Text'>" + regionalOffice + "</Value></...

View answer
1 answers
0 votes
191 views
SharePoint list first row duplicates by itself over and over
Accepted answer
0 votes

I think the issue is that I refreshing the page. Apperantly this is known issue.

View answer
8 answers
6 votes
19k views
How to get the ID of a list item with a given GUID in Sharepoint online with REST api?
-1 votes

As I mentioned in my comments, move the &Top=1 to the end of the URL. .../_api/web/Lists/getByTitle('docLib')/items?$select=id,GUID&$filter=GUID eq '2779cf8051-381f-4834-93dc-ece6345dde33'&...

View answer