Installation guide
SharePoint Column type Description
Number The user can enter only numeric characters. A percentage sign is added to the
right of the field if the SharePoint server is configured to show a percentage.
Yes/No The user can select either Yes or No as a value for the field.
Currency The user can enter a currency amount. The connector does not validate the
information.
Date and Time The connector validates the values entered by the user against the values
configured in the Administration Console Columns tab.
Hyperlink or Picture The user must enter the Hyperlink type and the Hyperlink description type. The
Hyperlink type defaults to http:// if no the SharePoint server does not provide a
default value.
Managed metadata You can enter multiple values separated by ;. The search while typing feature is
used, and the search is performed on the label of the terms and on the label of the
synonyms of the terms. You cannot enter a value not existing in the term set of
the column except when the column is the Enterprise Keywords column. In this
case the value you entered is automatically created storing the document on the
SharePoint server
Person or Group Allows the user to choose a group or person associated with the site the user is
storing a document to. Only a single selection is allowed. The server
configuration of a ‘Person or Group’ column allows various options such as
showing only people or people and groups. This release of the connector does
not support this option.
37.2.3 - Editing value of a date/time column
The value of date/time column is displayed in the same format specified in SharePoint. The column is set to
editing mode by clicking on its value cell. In the value cell you can navigate with the horizontal arrow keys
between parts of the date/time value (year, month, day, hour, minute, second) and value of a part is modified
similarly using the vertical arrow keys. A value part can be also specified by typing itself but in the following
way:
n to define a one-digit value click the digit once (for example, type 2 to set the value to 2)
n to define a two-digit value click the first digit twice and then the second digit (for example, type
twice 1 and once 2 to set the value to 12 or three times 2 (twice 2 and once 2) to set the value to 22)
To define the value of the year part by typing you can define only the last two digits of the year in the same
way mentioned above and the century is automatically filled.
The date part of the value can also be specified selecting a date from the calendar. This calendar can be
opened by clicking on the down array at the right side of the cell where year, month and day can be selected.