Documentation

User Property Column

User Property column is a custom SharePoint field that is capable of importing information regarding the current user either from SharePoint user profiles and/or from Active Directory.

Office 365 version is provided as part of Ultimate Forms app and is not available as a stand-alone app. The app version can only import data from the SharePoint user profile and not directly from Active Directory.

Managers decide what fields to import by creating a template similar to the calculated field template, which includes field token[s] and arbitrary text and punctuation. Column value can either be locked or editable by the end user.

 

Usage

The following instruction guides you step-by-step through the process of setting up a sample Infowise User Property Field implementation. Your real-life settings procedure is very similar.

NOTE: this example assumes you manage additional user properties in the Active Directory and/or SharePoint profiles. In this case we assume that the Manager field is filled.

  1. From the list menu/ribbon choose to add a new column. In the app version, go to the columns section.
  2. Enter column name “Manager”.
  3. Under the field type select User property
  4. In the list of available properties locate the Manager field.
  5. Move the Manager field to the Formula box by double-clicking or clicking Add to formula.
  6. Save settings.
  7. Open the New dialog. You should be able to see your manager’s name under the Manager column.

NOTE: when using manager property from Active Directory, you can optionally specify the property to display, such as mail to display manager’s email address. The display property should be added into the manager tag in the format [manager|property_name], e.g. [manager|mail].

 

Field Settings

field properties

The following settings are available to customize your field behavior:

  1. Enable field editing – allow users change the default value of the field. By default the field formula is calculated for the current user only.
  2. Allow manual retrieval – allow users to type in name or email of any user and click on aCheck Name  icon. If the user is found, the formula is calculated for that user. This setting requires field editing to be enabled.
  3. Preload current user - specify whether the field will automatically load the property value of the current user in list forms.
  4. Parent column – select another User Property column in the same list set for manual retrieval. Whenever that column retrieves data, it fills the current column with the relevant data as well. This setting requires field editing to be enabled and manual retrieval to be disabled.
    In the app version the parent column has to be a Person or group column. Only the first entered person is used, groups cannot be used.

 

Note: if the property you need is not found in the list, just type it in. You need to use the internal name of the property, not the display name. If it's a SharePoint Profile property, you can see its internal name when you go to the profile property management page in Central Administration.
Last modified: 1/29/2020 8:35 PM
Loading...

Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.