8

If you're trying to get cell data from Excel (or any other table source) into a SharePoint list's Checkbox column in Datasheet view, the values in each source field must be delimited with the semicolon and hash characters (;#). Each cell's data must also have a leading and trailing semicolon/hash pair. This last bit is counter any other delimiting style I've ...


5

It is not supported for multiselect fields (i.e. fields represented in the normal UI as check boxes). The following quote is for 2013 but the same rules apply for the ListData.svc. You can filter on the client side, though, depending on how you represent the data and the controls you use. Queries for multi-value lookup fields and users Because multi-...


5

Go to the column drop down list in question. At the first entry on the list do a return to create a blank space. Inside that blank space place your cursor and press and hold down the ALT key while typing 0129 on the NUMERIC KEYPAD. This will enter another type of “blank character” that SharePoint cannot wipe away. In the Default Entry setting do the same. ...


4

The Right Way To Do This Using: SharePoint2013 Current Answer Not Acceptable I've seen several answer similar to the above. Everyone saying use ALT0129 or the blank font character. I found these workarounds unacceptable because they would create a disconnect from the default SharPoint column filter (Empty) and instead create a new check box that is just ...


4

I've done what Unnie describes above before. First you create a list and populate it with all your choice values. Then you configure your list people will add items to by creating a new column of type lookup that points to the list you just created using the Title column. You set it to allow fill in votes. Then in a workflow, you check if a fill in option ...


4

Multi-choice field values are stored internally in ArrayList How to get multi-choice field values in PowerShell $web = Get-SPWeb $Url $list = $web.Lists[$ListTitle] $item = $list.GetItemById($ItemId) $values = new-object Microsoft.SharePoint.SPFieldMultiChoiceValue($item[$fieldName]) //print multi-choice field values for($i=0;$i -lt $values.Count;$i++) ...


4

If you have pairing defined, you can use mapping method: var map = new Object(); // or var map = {}; map[myKey1] = "subCat1,subCat2"; map[myKey2] = "subCat3,subCat4"; function get(k) { return map[k]; } //Attach event with dropdown selector, of main category. $("#categorySelectorId").change(function(){ var subCategory = $("#subCategorySelectId"); ...


4

By default, the choice field in Sharepoint list has an auto-size style based on its content. To set a width style for all choice fields in your list form, Open the Edit / New form in a new tab. Edit the page. Add a script editor with the blow CSS style CSS <style> select { width:300px !important; } </style> To set a width style for Specific ...


4

Try with margin-left CSS。 Demo: <style type="text/css"> input[type="radio"] { margin-left: 10px; } </style> <input type="radio" checked="checked" name="edit" value="A">A <input type="radio" name="edit" value="B">B <input type="radio" name="edit" value="C">C Update: Try this JS code: &...


4

First of all, you should be aware of list row size limit is 8,000 bytes per row, 300 bytes are reserved. 7700 bytes for end-user columns. It's a boundary limit that can't be changed! For more details, check SharePoint 2019 Limitations compared to other SharePoint versions. Secondly, this info is correct " the maximum columns for Choice (multiple ...


3

Try this $(document).ready(function(){ $('#ctl00_m_g_de548742_27f6_4e71_b3ec_2d9a1ecca117_ff151_ctl00_DropDownChoice').on('change', function(){ var accountType = this.value; if(accountType == 'Military') { $('.milShow').show(); $('.ctrShow').hide(); $('.civShow').hide(); } if(...


3

Descerning the original values from the user filled-in is easy, as the additional values entered by a user are not added to the original choice field definition, which will remain unaltered. So, in order to retrieve all the list items where the choice field value is not one of the predefined values, you need to build a CAML query with the NEQ operator on ...


3

Retrieve choice field value in Rest API by attaching 'value' to the field name. for e.g. if your field name is Flags, use the term FlagsValue in the filter string. This works if the choice field is not a multi select field. Your url should be like http://tssites/departments/appdev/_vti_bin/ListData.svc/TeamCalendar?$expand=Flags&$filter=FlagsValue eq '...


3

This should do it: Download jQuery and save it to /SiteAssets/ Create a JavaScript file named comma-break.js and save it in /SiteAssets/ with the contents of: $(document).ready(function () { var str = $('.ms-listviewtable').html(); //; $('.ms-listviewtable').html(str.replace(new RegExp(", ", "g"), ",</br>")); }); Add a Content Editor Web ...


3

I have seen this happen before (when a programmer without SharePoint knowledge 'fixed' a problem with imported/pasted data and emptied/deleted the existing definition of DropDown values The underlying database stores anything that is written to it, so modern JSOM code can write values to a 'DropDown' field without checking those values actually match with ...


3

You can't do it like this because Lookups are internally based on reference-ids and not the values. As Formulas can not expand these complex types (same applies to: Multiple Select, [Me] and Person Columns) you can not use them in Calculated Columns Your workaround is to use Workflows to read the Complex type value and write it to a basic Text column, ...


3

You have to bind field value like below. In below Sample is your field's internal name. ThisItem.Sample.Value or Sample.Value will also work.


3

Is it possible to update information from one choice field into another choice field in a different list? Yes, it's possible and I applied this scenario multiple times on my side. But you should be aware of the value of first choice field should be within the list of values of the second choice field in the other list. For Example The Choice field ...


3

I am not 100% sure if this should be posted as an answer or a comment (but the question doesn't include a question). You can't get it without the #. The separator is actually ",#": a comma followed by a pound. Independently from SharePoint, Excel does handle drop down lists (choice fields), but does NOT handle drop downs with multiple selections. When ...


3

To set a choice field value, you need to set it as 1 or 0. Like - oListItem.set_item('emailcheck', 1); Also, once "updated", you need to execute it using executeQueryAsync to actually send data to the server and add a list item. Modify your code as below: function createListitem(){ var clientContext = new SP.ClientContext(_spPageContextInfo....


3

$(document).ready(function () { $("span[title='SelectAll'] input").click(function (event) { //on click $("input[id^='Geography_']").prop("checked", this.checked); }); }); This is more to selecting element In jquery, what I've done here is finding element span with title "SelectAll" and attach a click event in input element inside that ...


3

You can directly use the FormDigestValue in the RequestDigest header in Modern pages. The __REQUESTDIGEST is a hidden HTML element which is not present in modern pages. So, it had tripped up your code. Have modify your code as below by adding the payload separately and then stringifying it: var payload = { '__metadata': { 'type': 'SP.FieldChoice' }, ...


3

Conditional formulas in SharePoint online modern experience does not support Multiple choice column. Reference: Supported column types in conditional show or hide


2

I think it is actually your Email step that is not working correctly. The recipient does not look right. What I normally do to find out where my workflow gets stuck is I insert steps that adds entry to the Workflow History. There is a step to log a workflow history. If you are emailing the person specified in the People Picker, use the Email Address or ...


2

Probably no help but this could be done as a lookup to another (very short) SP list, with 'Yes' in the looked up column. Yes can then be selected but it's also possible to delete it to be blank.


2

There isn't that functionality out of the box, but it can be done with custom javascript or editing the forms with InfoPath.


2

This looks to be a compatibility issue with .docx documents being used in older versions of SharePoint (ex. 2007). https://social.technet.microsoft.com/Forums/office/en-US/6799e3cc-99e9-4548-8484-90d51d77a505/metadata-fields-not-saving-from-edit-properties-form


2

I too faced the same problem. The actual issue is with the space inbetween Event and Type. So, I created a column 'EventType' and added the choice values. Created the calculated column which has reference to EventType. Now it will save without any issues. After that edit the column and rename it to 'Event Type'. However you need not change the calculated ...


2

You should add two separate site columns, one for each derived content type. You could name first site column "computer asset type" for use in "computer" content type with lookup or choice values "desktop,lptop,tablet". Similarly, you could name second site column "furniture asset type" for use in "furniture" content type with lookup or choice values "...


2

You will need to create the structure using SPServices.CascadeDropdowns like 404 said. Also make sure you have the fields that you want auto-populated set up as required fields. If they are not required and for some reason don't want them required you can do the following (I would recommend requiring the fields, I just wrote this out before that crossed my ...


Only top voted, non community-wiki answers of a minimum length are eligible