{"id":119,"date":"2020-02-17T16:19:14","date_gmt":"2020-02-17T15:19:14","guid":{"rendered":"https:\/\/help.metashare.com\/metashare-help-admin-manual-metashares-supported-site-columns\/"},"modified":"2024-05-30T16:52:07","modified_gmt":"2024-05-30T14:52:07","slug":"metashares-supported-site-columns","status":"publish","type":"page","link":"https:\/\/staging-help.metashare.com\/en\/metashare\/get-started\/metadata\/metashares-supported-site-columns\/","title":{"rendered":"MetaShare&#8217;s supported site columns"},"content":{"rendered":"\n<p>There are many different types of site columns in SharePoint but in MetaShare these are the only ones that we currently support:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/staging-help.metashare.com\/en\/adminmanual\/metashares-supported-site-columns\/#managed-metadata-column\">Managed Metadata columns<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/staging-help.metashare.com\/en\/adminmanual\/metashares-supported-site-columns\/#person-or-group-column\">Person or Group columns<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/staging-help.metashare.com\/en\/adminmanual\/metashares-supported-site-columns\/#date-and-time-column\">Date columns<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/staging-help.metashare.com\/en\/adminmanual\/metashares-supported-site-columns\/#yes-no-check-box-columns\">Yes\/No (check box) columns<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/staging-help.metashare.com\/en\/adminmanual\/metashares-supported-site-columns\/#single-line-of-text-column\">Single line of text columns<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/staging-help.metashare.com\/en\/adminmanual\/metashares-supported-site-columns\/#multiple-lines-of-text-column\">Multiple lines of text columns<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/staging-help.metashare.com\/en\/get-started\/metashares-supported-site-columns\/#number-column\">Number columns<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/staging-help.metashare.com\/en\/adminmanual\/metashares-supported-site-columns\/#choice-column\">Choice (radio buttons) columns<\/a><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Managed Metadata&nbsp;column<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This field displays values that correspond to\u00a0<a href=\"https:\/\/staging-help.metashare.com\/en\/adminmanual\/how-to-manage-terms\">terms<\/a>\u00a0in a\u00a0<a href=\"https:\/\/staging-help.metashare.com\/en\/adminmanual\/how-to-manage-term-sets\">term set<\/a>, that the column is linked to.<br>If it has less than 150 terms, if you click on the field, its terms are shown under it and you can scroll through the list:<br><img loading=\"lazy\" decoding=\"async\" width=\"414\" height=\"286\" class=\"alignnone size-full wp-image-3438\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1067.png\" alt=\"A managed metadata column shown as drop down\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1067.png 414w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1067-300x207.png 300w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><br>If you start typing only the terms that\u00a0<strong>contain<\/strong>\u00a0the typed phrase will be shown in the drop-down:<br><img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"141\" class=\"alignnone size-full wp-image-3436\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1066.png\" alt=\"A managed metadata column showing items matching a query\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1066.png 419w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1066-300x101.png 300w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><br>If it has 150 terms or more, the drop-down is not shown when you click on the field. If you however start typing the terms that <strong>start<\/strong>\u00a0with the typed phrase will be shown in the drop-down:<br><img loading=\"lazy\" decoding=\"async\" width=\"418\" height=\"138\" class=\"alignnone size-full wp-image-3440\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1068.png\" alt=\"A managed metadata column showing items that start with the query\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1068.png 418w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1068-300x99.png 300w\" sizes=\"auto, (max-width: 418px) 100vw, 418px\" \/><br>But if a term has other labels, like in this case where we have added &#8220;SharePoint&#8221; as an alternative label to the &#8220;Microsoft SharePoint&#8221; label:<br><img loading=\"lazy\" decoding=\"async\" width=\"677\" height=\"137\" class=\"alignnone size-full wp-image-3442\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1069.png\" alt=\"The terms default label and other labels\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1069.png 677w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1069-300x61.png 300w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><br>Then &#8220;Microsoft SharePoint&#8221; will also be shown in the list of available terms when searching for &#8220;Share&#8221;:<br><img loading=\"lazy\" decoding=\"async\" width=\"416\" height=\"163\" class=\"alignnone size-full wp-image-3444\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1070.png\" alt=\"A managed metadata column showing items matching a query\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1070.png 416w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1070-300x118.png 300w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/li>\n\n\n\n<li>Managed metadata are by default restricted to only allow single values but can also be configured to allow multiple values:<br><img loading=\"lazy\" decoding=\"async\" width=\"257\" height=\"117\" class=\"alignnone size-full wp-image-3458\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-240-1.png\" alt=\"A multiple values managed metadata column\"><\/li>\n\n\n\n<li>Managed metadata columns can either be closed (only administrators can define the selectable values, by\u00a0<a href=\"https:\/\/staging-help.metashare.com\/en\/adminmanual\/how-to-manage-terms\" rel=\" noopener\">managing the column&#8217;s terms<\/a>\u00a0in the corresponding term set) or open (the end-users are able to add new values to it). If the column is open, this is the behavior of these fields:\n<ul class=\"wp-block-list\">\n<li>When adding a new value &#8220;(new)&#8221; is shown after the term&#8217;s name. You can select the new value by clicking on the new value or by pressing the &#8220;Enter key&#8221; on your keyboard:<br><img loading=\"lazy\" decoding=\"async\" width=\"416\" height=\"86\" class=\"alignnone size-full wp-image-3446\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1071.png\" alt=\"An open managed metadata column, allowing you to create new terms\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1071.png 416w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1071-300x62.png 300w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><br>After selecting a new value, the user will get a confirmation that the value will be added to:<br><img loading=\"lazy\" decoding=\"async\" width=\"416\" height=\"122\" class=\"alignnone size-full wp-image-3448\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1072.png\" alt=\"An indication is shown that the term will be added to the term set\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1072.png 416w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1072-300x88.png 300w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><br>Note that terms that are created by end-users, from the document&#8217;s property form, are created in a flat structure, i.e. users will not be able to define if a term should be a child of another term.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If a tag is a child of another tag (the tags are organized in a hierarchical structure), we show the tag\u2019s parent in the in the document property form. We do this to be able to differentiate terms, if they have the same name but are located under different parents:<br><img loading=\"lazy\" decoding=\"async\" width=\"441\" height=\"147\" class=\"alignnone size-full wp-image-4325\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-tag\u2019s-parent-shown-in-the-document-property-form.jpg\" alt=\"A tag\u2019s parent shown in the document property form\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-tag\u2019s-parent-shown-in-the-document-property-form.jpg 441w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-tag\u2019s-parent-shown-in-the-document-property-form-300x100.jpg 300w\" sizes=\"auto, (max-width: 441px) 100vw, 441px\" \/><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Person or Group&nbsp;column<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In this field a user can search for an individual or a group in Microsoft Entra ID.\u00a0You need to type at least 3 characters before you see a list of available users\/groups to select from. The user&#8217;s\/groups are shown in two lines, their display names in the first line and their login names (e-mail addresses) in the second line:<br><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"132\" class=\"wp-image-8548\" style=\"width: px\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-Person-or-Group-column.jpg\" alt=\"A Person or Group column\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-Person-or-Group-column.jpg 420w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-Person-or-Group-column-300x94.jpg 300w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/li>\n\n\n\n<li>By default, the column only allows single selection but it can be configured\u00a0to\u00a0allow multiple selections:<br><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"49\" class=\"wp-image-8551\" style=\"width: px\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Allow-multiple-selections-1.jpg\" alt=\"Allow multiple selections\"><\/li>\n\n\n\n<li>By default, the column only allows selection from individual users but it can be configured\u00a0to\u00a0also allow groups:<br><img loading=\"lazy\" decoding=\"async\" width=\"248\" height=\"49\" class=\"wp-image-8553\" style=\"width: px\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Allow-selection-of-people-only-or-also-groups.jpg\" alt=\"Allow selection of people only or also groups\"><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Date and Time column<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The column setting &#8220;Date and Time Format&#8221; needs to be set to &#8220;Date only&#8221;:<br><img loading=\"lazy\" decoding=\"async\" width=\"205\" height=\"46\" class=\"alignnone size-full wp-image-4282\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Date-and-Time-Format.jpg\" alt=\"Date and Time Format\"><\/li>\n\n\n\n<li>In this field a user can select a date from a date-picker. In order to more quickly find the current date, it is highlighted:<br><img loading=\"lazy\" decoding=\"async\" width=\"266\" height=\"288\" class=\"alignnone size-full wp-image-3460\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-770-2.png\" alt=\"A date column\"><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Yes\/No (check box) columns<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This is a check box field, that can have &#8220;Yes&#8221; or &#8220;No&#8221; as a default value:<br><img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"38\" class=\"alignnone size-full wp-image-5479\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Boolean-column-1.jpg\" alt=\"A Yes\/No (checkbox) column\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Boolean-column-1.jpg 419w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Boolean-column-1-300x27.jpg 300w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Single line of text&nbsp;column<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This is a free-text field, displayed on one line, with a maximum of 256 characters:<br><img loading=\"lazy\" decoding=\"async\" width=\"422\" height=\"60\" class=\"alignnone size-full wp-image-5483\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-signle-line-of-text-column.jpg\" alt=\"A single line of text column\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-signle-line-of-text-column.jpg 422w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-signle-line-of-text-column-300x43.jpg 300w\" sizes=\"auto, (max-width: 422px) 100vw, 422px\" \/><\/li>\n\n\n\n<li>The column could be configured to have lower maximum number of characters, when exceeding this length you will get a warning:<br><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"57\" class=\"alignnone size-full wp-image-3452\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1085.png\" alt=\"A single line of text column with a length restriction\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1085.png 435w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-1085-300x39.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/li>\n\n\n\n<li>If the column is defined to have a default value, it will be shown in the document property form, when creating or uploading documents.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Multiple lines of text column<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This is a free-text field, displayed in multiple lines:<br><img loading=\"lazy\" decoding=\"async\" width=\"431\" height=\"104\" class=\"alignnone size-full wp-image-5481\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Multiple-lines-of-text-column-1.jpg\" alt=\"A Multiple lines of text column\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Multiple-lines-of-text-column-1.jpg 431w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Multiple-lines-of-text-column-1-300x72.jpg 300w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><\/li>\n\n\n\n<li>If a multiple line of text column is shown in a document view, the values in the list will be shown in multiple lines:<br><img loading=\"lazy\" decoding=\"async\" width=\"918\" height=\"109\" class=\"wp-image-8545\" style=\"width: px\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-document-view-with-a-notes-and-a-boolean-column.jpg\" alt=\"A document view with a multiple lines of text column\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-document-view-with-a-notes-and-a-boolean-column.jpg 918w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-document-view-with-a-notes-and-a-boolean-column-300x36.jpg 300w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-document-view-with-a-notes-and-a-boolean-column-768x91.jpg 768w\" sizes=\"auto, (max-width: 918px) 100vw, 918px\" \/><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Number column<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This is a field that only permits numeric characters:<br><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"57\" class=\"wp-image-9503\" style=\"width: px\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-field-of-type-number.jpg\" alt=\"A field of type number\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-field-of-type-number.jpg 420w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/A-field-of-type-number-300x41.jpg 300w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/li>\n\n\n\n<li>You can use your keyboard&#8217;s up\/down buttons or click on the up\/down arrows to increase or decrease the number.<\/li>\n\n\n\n<li>If needed you can define a minimum and a maximum value to allow in the field:<br><img loading=\"lazy\" decoding=\"async\" width=\"340\" height=\"54\" class=\"wp-image-9505\" style=\"width: px\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Minimum-and-maximum-values.jpg\" alt=\"Minimum and maximum values\" srcset=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Minimum-and-maximum-values.jpg 340w, https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Minimum-and-maximum-values-300x48.jpg 300w\" sizes=\"auto, (max-width: 340px) 100vw, 340px\" \/><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Choice column<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The column setting &#8220;Display choices using&#8221; needs to be set to &#8220;Radio Buttons&#8221;:<br><img loading=\"lazy\" decoding=\"async\" width=\"271\" height=\"96\" class=\"alignnone size-full wp-image-4284\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/Display-choices-using.jpg\" alt=\"Display choices using\"><\/li>\n\n\n\n<li>In fields of these types a user can only select one of the values defined for the column, by clicking on the radio button next to the value. This field type is only recommended for values that do not change over time and that do not have more than 3 values:<br><img loading=\"lazy\" decoding=\"async\" width=\"145\" height=\"72\" class=\"alignnone wp-image-3454\" src=\"https:\/\/staging-help.metashare.com\/wp-content\/uploads\/image-219-1.png\" alt=\"A choice column\"><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>There are many different types of site columns in SharePoint but in MetaShare these are the only ones that we currently support: Managed Metadata&nbsp;column Person or Group&nbsp;column Date and Time column Yes\/No (check box) columns &#8230; <a title=\"MetaShare&#8217;s supported site columns\" class=\"read-more\" href=\"https:\/\/staging-help.metashare.com\/en\/metashare\/get-started\/metadata\/metashares-supported-site-columns\/\" aria-label=\"Read more about MetaShare&#8217;s supported site columns\">Read more<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"parent":10709,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":{"0":"post-119","1":"page","2":"type-page","3":"status-publish","5":"no-featured-image-padding"},"_links":{"self":[{"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/comments?post=119"}],"version-history":[{"count":25,"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/119\/revisions"}],"predecessor-version":[{"id":11243,"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/119\/revisions\/11243"}],"up":[{"embeddable":true,"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/pages\/10709"}],"wp:attachment":[{"href":"https:\/\/staging-help.metashare.com\/en\/wp-json\/wp\/v2\/media?parent=119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}