Tag Info

New answers tagged

1

You can use below formula =CONCATENATE("FY",YEAR(Date+274)," Q", IF(Month(Date)>10,1,IF(Month(Date)>7,4,IF(Month(Date)>4,3,2)))) Logic CONCATENATE can be used to form formatted TEXT First find FY - So here we can use the same Excel formula FY + Year(Date+274) To calculate Quarter - We need to use IF statements. It take form ...


0

I agree with Eric that LOOKUP is not a usable formula for calculated column. This is the formula I have used for displaying "Q# YYYY" format for a date column: =IF(ISBLANK(TestDate),"",(CONCATENATE("Q"&(INT((MONTH(TestDate)-1)/3)+1)&" "&(YEAR(TestDate)))))


0

I don't remember Lookup being an allowable formula in the calculated column syntax. I think you'd need to replace those with Ifs. This is my go to article for calculated column references. If you break the formula into separate pieces, you should see it work for both year and quarter. To make it easier, you can create the if branch in a separate column, ...


3

Yes you can do this Using jQuery to dynamically change this on document.ready event Recommended way - Using JSLinks Option #2 you can use JavaScript to specify how a field should be rendered. For more check this article. http://zimmergren.net/technical/sp-2013-using-the-spfield-jslink-property-to-change-the-way-your-field-is-rendered-in-sharepoint-2013


0

You have to roll your own logic in that case, the default Save action saves and closes the form. So if you want some sort of tabbed interface that allows the user to "save" then finally "submit" you need to create functions that do the following: the Save button would create a list item if you are on tab 1 otherwise it is an update to the list item, Submit ...


1

Are you sure the field name is same as internal name? Title field is always same, no matter external or internal but other fields, especially the ones with the spaces between them, are different. Best way (for debugging) is to remove all fields and add 2-3 fields at a time and then run your code but to avoid wasting time, i would suggest check the internal ...


2

The list instance was created on the site on which you activated the feature. Your list should be in a web-scoped feature. Site-scoped features are for site scoped things like master pages, content types and web parts. They will not cause web-scoped things like lists to become automatically provisioned on subwebs. This means every subsite you want the ...


0

If the Scope is "Site" it creates only at root site level, change it to "Web" and deploy it. Please deactivate, uninstall and retract completely before you deploy your changes.


0

SharePoint lists will have 3 default template pages when you open in designer. Dispform Editform Newform So based on your choice you can customize in designer or info path for a non code solution. In your case, you should include a script which does the show/hide actions in the disp form - for existing items.


1

Out of the box SharePoint only supports receiving email to specific types of lists and libraries. For instance, you can receive email on an Announcements list, calendar list,discussion board and libraries. However, you cannot receive email on custom lists. As a workaround, either you use an announcement list or library and customize it according to your ...


0

Yes it is possible to batch update or create List Items function updateListItems() { var itemArray = []; var clientContext = SP.ClientContext.get_current(); var oList = clientContext.get_web().get_lists().getByTitle('TestList'); for(var i = 1; i<= 5; i++){ var oListItem = oList.getItemById(i); oListItem.set_item('Title', 'My ...


1

Since you haven't told us which API you prefer, below is demonstrated how to retrieve and update list items using JSOM API: function getListItems(listTitle) { var deferred = $.Deferred(); var ctx = SP.ClientContext.get_current(); var list = ctx.get_web().get_lists().getByTitle(listTitle); var items = ...


1

I have a list called rohit_list1 on which i am updating title for all the items with ID greater than 15. You Write your own CAML query to get ID's. Design : <input type="button" value="updateMultipleListItems" onclick="getItemsToBeUpdated()" /> JSOM Code : <script type="text/javascript"> var colllistItemToBeUpdated = ""; var ...


1

To begin, go to List Settings > Advanced Settings Select Yes on Allow management of content types Click on one of the existing content types under the Content Type section Next, click on the column you intend to hide, and choose the option Hidden. Click OK Go to the New Item tab and select the Edit form. You will see that, on both the New Item and Edit ...


0

I found the solution after lots of tries...to get the result use JavaScript "string contains" where you have to use "IndexOf" I just had to change my condition in if statement to if (empName.toUpperCase().indexOf(Name.toUpperCase()) > -1 && distDeput != DisDep) {


1

This is the default behavior of SharePoint. This is how it works. You will not get the Image URL or FileRef as a lookup column from picture library. Here is an ARTICLE that explains about Using the Lookup column to display an Image. Another ARTICLE that might help you but it would create a custom lookup through JavaScript.


0

Did you try to change the width by: Edit page -> Edit web part -> Change width in Appearance section Or else you can change the width using JavaScript. Add a js file and change width using .css method.


0

You can use jquery to show/hide fields on sharepoint list forms. Using jQuery, you can control the visibility of fields. For example refer this link.


1

As I mentioned in comment, this is known limitation in Office 64bit. Datasheet view, open with access are not working with office 2010 x64. Did you try to install Data Connectivity Components? install this on test machine and test it. ...


0

Looks like you have some kind of Workflow or Event receiver can cause this issue. you can avoid this in future to implement the Uniqueness on the column. Enforcing Uniqueness in Column Values Now to remove the Duplicate values from list, couple of options. Option # 1 Make sure all item are at least major version and checked in. Create a fresh view ...


1

Two possibilities A workflow Event Receiver Workflow you can check using SharePoint Designer. Event Receiver - You can download SharePoint Manager and connect to SharePoint server or you can use below PS script $site = Get-SPSite -Identity "http://siteurl" $web = $site.RootWeb $list = $web.Lists["ListName"] $list.EventReceivers | Select assembly, ...


0

I found a solution which seems to work well. I created three Lists: Employees Employee Name [free text] Location [dropdown] Resume [hyperlink] Skills Skill [free text] Category [dropdown] Master Employee Name [lookup to Employees] Location [additional lookup to Employees] Skill [lookup to Skills] Category [additional lookup to Skills] Skill Level ...


4

It is one of the limitations Microsoft clearly states as why you should use 32 bit office instead of 64 bit. In SharePoint, the list view won’t be available. See Choose the 32-bit or 64-bit version of Office on https://support.office.com And in your bounty you mention It currenty only works for 32bit office. The majority of the users I support are ...


1

It seems and issue fixed by a hotfix for 32-bit Office. you can download the hotfix here: Hotfix Install it and restart you pc.


0

Might want to try in a different browser.. I sometimes get this error in Google Chrome, but it will work fine in Internet Explorer. Not sure why..


0

Lists are a part of SPWeb not SPSite. Once you have the correct web, it's pretty easy to extract the list from the web. ClientContext context = new ClientContext(webUrl); context.Credentials = new NetworkCredential("user", "password", "domain"); targetWeb = context.Web; targetList = targetWeb.GetList("http://server/listUrl"); context.Load(targetList); ...


0

I've solved error changing date format... This: var date = moment(data[i]['Date']+' '+data[i]['Time'], 'M/D/YYYY hh:mma'); data[i]['Date'] = date.format('DD/MM/YYYY HH:mm'); To this: var date = moment(data[i]['Date']+' '+data[i]['Time'], 'M/D/YYYY hh:mma'); data[i]['Date'] = date.format('YYYY-MM-DDTHH:mmZ');


0

I have stumbled upon a similar issue and found a workaround for the issue. What I did was write a loop that tries to create the column and with a try catch construction, removes the duplicate column in the catch clause. I encountered the issue when trying to create a taxonomy site column with the same description as an existing column. bool createSucceeded ...


1

No matter what some blogs tell you can not use TODAY in a Calculated Column. See the Use javascript/jquery to see if items in list are due soon in Sharepoint 2013 topic for some alternatives, like CSR/JSlink, XSLT or stuffing Javascript in a Calculated Column


0

OP stated SharePoint Designer can not be used. You can stuff Javascript in a Calculated Column; but its a real pita to debug if you make any typos. Change the [Enddate] to your duedate field Change the Range setting to the timeslots you require ="<img src=""/_layouts/images/blank.gif"" onload=""{" &"var ...



Top 50 recent answers are included