New answers tagged

0

By "mouseover" I am assuming you mean what is usually referred to as a "tooltip" - a small bit of text that is shown when you move the pointer over some other element. The event that happens is "mouseover", the effect of showing a small bit of text is a "tooltip". In order to do that, you can use the default HTML title attribute. Instead of setting the ...


1

If you execute the items API call without any filter, you will get a result set that contains all the items in that list. Maybe not a problem if the list only contains a small number of items, but obviously lists can potentially contain thousands of items and that would not perform well. The following example gets just retrieves the most recently modified ...


0

Yes, by using the embed webpart. Step 1 : Copy the NewForm.aspx page url. Step 2 : Add embed webpart on the page where you wish to show the form. Step 3 : Open webpart property and add the embed code url. <embed width="800" height="600" src="http://mysite.sharepoint.com/sites/mysite/lists/mylist/NewForm.aspx?IsDlg=1" /> Step 4 : Save the page. It ...


0

@LZ_MSFT Isn't that the code for NOT Wrapping column text? It looks like it is. Thus the code TO wrap column text would look like what I show below. Copy the code below and paste it in the Column Formatting text box for a column --> Click Save --> Go back to the list and hover over the column breaks --> Adjust the column width as desired --> Click dropdown ...


2

Don't create formulas in column validation on the PrjStatus column, because the formula cannot refer to another column. You can create list validation. Navigate to list settings->Validation settings->create the following formula->save: =IF(PrjStatus="COMPLETE",AND(NOT(ISBLANK(SummaryLink)),NOT(ISBLANK([End Date]))),TRUE)


0

The special characters are nothing but pound symbol and ID of that user in that site. That's SharePoint exports the user field to excel. It's by design and we cannot change it. I understand that you want to remove the number and ;# in excel file. You can use formulas to achieve this. =SUBSTITUTE(H2, ";#", " ") Change H2 to the column which contains the ...


1

First, as mentioned in the comments above, you should not assume that ID of the first item is 1, you need a more predictable way to get your item. Second, the set_item method should be called from the variable that holds the reference to the item you retrieved. You code calls listItem.set_Item, but listItem is not a defined object. Finally, the attempt to ...


0

You could try the Totals setting in the list view settings. In Group By section, Group By the column "Employee Name". In Totals section, choose sum for column "Occurrences". The view would be like this:


0

SharePoint does not natively provide rollup totals for calculated columns, but you do have some options on-prem. You can get the total number of days between the two dates for each row with the following calculated column formula: =DATEDIF(Modified,Created,"d") To emulate a rollup value, you will need to do some JavaScript trickery. This article ...


Top 50 recent answers are included