18

You could use a unicode character that does not print anything. I tried it with U+205F and it seemed to work as expected. To put this character in, open up the charmap (Start->Run->charmap) on your machine, then select a font that has unicode support (I chose calibri), scroll almost to the bottom and find the U+205F. You can then double click the ...


11

Why do you need mappings First things first: let me explain, why do you need to use mappings at all. With some accuracy it can be said, that a Choice field in SharePoint represents a DropDownList control. And in the ASP.Net DropDownList control, each item (ListItem, to be precise) has two essential properties: Text and Value. Obviously, Value property acts ...


7

Choice fields are returned with a Value without the need for expansion: Example: IP_WorkflowStatus = IP_WorkflowStatusValue Here is an example of a query without using expansion: $filter=IP_WorkflowStatusValue eq '2-Validated' If you want to use expansion, then you need to use expanded field notation Relation/Field: $filter=IP_WorkflowStatus/Value eq '2-...


6

Looks like you're using default Update method of SPContentType when updating your content type in feature updating receiver. To push changes to all inherited list content types, you should use another overload of the Update method, and pass true to it: contentType.Update(true); Description of the parameter from MSDN: updateChildren Type: System....


5

You can do it in InfoPath, cascading drop downs. But since you said you need to do it in jQuery, there is a very useful library, called SPServices, available to assist. Marc has created a function in the library to do cascading drop downs, which is exactly what you want. Look over that information and see if it's helpful.


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. ...


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

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 ...


4

Just create the Choice field as a drop down list with the only option of Yes and set no default value. When an item is submitted an empty value will be set in the list. If a user sets the field and wants to revert back to no value, they'll be forced to go into datasheet mode to remove the selection. THe regular editform will not give them a means to ...


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"); ...


3

The only solution not involving code is: Create the column as: Choice Not required Unique Choices: 1, 2, 3, 4 and 5 (not None) Drop-Down Menu Clear default value That'll allow the users to create any number of entries without a priority, but only one for each of the 5 values. This seems is like you want it to work. BUT once an entry has been assigned a ...


3

All credit goes to Xiang Zeng for providing the answer, many thanks! This is a bug in Sharepoint. However, there is a workaround. Directly modifying the SchemaXml property to change the choices is allowed: public override void ItemAdding(SPItemEventProperties properties) { base.ItemAdding(properties); string itemTitle = properties....


3

SPFieldChoice has a property named FieldRenderingControl. Using reflector you can find this code in the FieldRedneringControl property: .... switch (this.EditFormat) { case SPChoiceFormatType.Dropdown: control = new DropDownChoiceField(); break; case SPChoiceFormatType.RadioButtons: control = new RadioButtonChoiceField(); ...


3

You can find details about <Mappings> in [MS-WSSCAML]: Collaborative Application Markup Language (CAML) Structure Specification V0.1 "MAPPINGS: A set of MAPPING string elements that represents a canonical, languageagnostic identifier for a corresponding CHOICE with the value specified by the MAPPING element. The reader MUST ignore MAPPINGS if the ...


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

You can use the GetFieldValue method of the field class if you are unsure of the actual type of the underling value. For example: item["MyChoiceField"] = listIstance.Fields["MyChoiceField"].GetFieldValue("Choice1");


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

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

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

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 ...


3

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: &...


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