Changes

Custom Fields – General Information

42,718 bytes added, 12:46, 14 April 2023

no edit summary

~~__TOC__~~{{Banner-UnderConstruction}}

~~The following settings are common to almost all [[Custom Fields|Custom Field]] types:~~

~~[[Image:Cf1.png]]~~

=Overview=~~=Field Name~~ A '''Custom Field '''is the basic unit of data storage, created on an as-needed basis for your system, and ~~Field ID===~~* The field name is ~~mandatory~~associated with a [[SmartSimple]] [[entity]] such as a [[User|contact]], [[Organization|organization]], [[User Role|role]], or activity.* The name These fields can be ~~up to 255 characters long~~ accessed and ~~should not include special characters that could be misinterpreted by~~ controlled from either the [[~~Browser|browser~~Global Settings]].* The Field ID is automatically generated by area of your system, or on the ~~system as~~ Entity-based '''Settings '''page within a ~~number value and is displayed to the right~~{{UTA}}.

New custom fields are added on a regular basis - we currently have over 50 field types that can be used to capture and store data. For a full list of Custom Fields, see [[~~Image~~:~~Cf6~~Category:Custom Fields#Types of Custom Fields|Types of Custom Fields]].~~png~~You can also check the [[Upgrades]]section of our Wiki for continuous notice of the latest field types.

'''Custom Fields '''are used in addition to [[Standard Fields]], which are automatically built into your system (for example, '''Name '''or '''Address '''are typical Standard Fields). While '''Custom Fields '''can be added, removed, and customized, as a general rule Standard Fields cannot be changed, although they might be renamed or modified. All fields display data in configurable ways: for example, they can be grouped into tabs or displayed in multiple columns to avoid cluttering the page. * The maximum number of custom fields that can be displayed on a single page is 400 total. ==Accessing Custom Fields==1. Click the 9-square menu icon on the top right of your page. :: {{Icon-Menu}} 2. Under the heading '''Configuration, '''select '''Global Settings.''' The hyperlink to '''Custom Fields '''will be available under ''each ''tab. Clicking the '''Custom Fields '''link under a specific tab will bring you to the custom fields that are associated with the purpose of that tab - for example, if you click on the '''Custom Fields '''under the '''User '''tab, this will bring you to a list of all custom fields specifically associated with [[User|users]], both [[Internal|internal]] and [[External|external]]. {| class="wikitable"|-||'''System - Custom Fields'''||A list of all custom fields from ''all ''object types in the system.|-||'''Organizations - Custom Fields'''||Create and manage custom fields for '''Branch '''([[Internal]] organization on the [[Organization hierarchy|organization hierarchy]]) and '''Organization '''([[External]])|-||'''Users - Custom Fields'''||Create and manage custom fields for [[User|users]], both [[Internal]] '''Staff '''and [[External]] '''Contacts'''|-||'''Associations - Custom Fields'''||Create and manage custom fields for [[Association Settings|associations]], which can be between companies and users or company-to-company |-||'''Transactions - Custom Fields'''||Create and manage custom fields for [[:Category:Transactions|Transactions]] and [[Transaction Attribution|transactions attributions]]|}:: [[File:All custom fields.png|thumb|none|600px|border|All custom fields for system objects]]:: [[File:Organization custom fields.png|thumb|none|500px|border|Custom fields for Organizations under the Organizations tab]]When you click into a '''Custom Fields''' hyperlink from the '''Global Settings''' area, you will be brought to a [[List View Overview|list display]] of all available custom fields relating to that part of the system. In order to modify a Custom Field, you can simply select the '''pencil icon''' to the left side of the custom field name, as shown below::: [[File:Edit custom field.png|950px|border]]: :* Using the '''Search''' function on the top right, you can search through all '''Object Entities''' or through the fields of specific {{UTA}}s. Simply select or deselect to control your results.:* '''Tip: '''A Search-based strategy for troubleshooting is to clear your past search, select '''All Object Entities '''within the search bar, then click on the '''Last Modified '''field in the list view so that it is in descending [[Sort By|Sort Order]] and you can see the date that a custom field was changed, added, etc. :* You can also access all deleted fields by clicking into the second tab. There is no time limit within the system that removes deleted records; therefore, you can simply select and restore or purge these previously deleted fields.:* There should be no reason to purge as Custom Fields do not take up much space within the system.:* When you restore fields, there is no loss of data. =Configuration - Essentials=<pre>This page will serve as the main repository for setup information that is shared between most field types. To find setup options that are specific to a certain field type, look into the Wiki page for that field type itself. </pre>==Common Custom Field Functions==On the top left of the Custom Field record will be a row of buttons, each with different functions relating to the field. ::: [[File:Custom field menu buttons.png|200px|border]] The following table describes the functionality of each button from left to right: {| class="wikitable"|-||'''Custom Fields [[List View Overview|list]]'''||Clicking this '''list chart '''icon will bring you to the list of all custom fields available in this part of the system. For example, if you are on a Custom Field that is found under the '''Organizations '''tab of '''Global Settings, '''you will be brought to a comprehensive list of all custom fields relating to '''Organizations. '''|-||'''New Custom Field ''' ('''+ icon''') ||Clicking this '''plus icon '''will allow you to create a '''New Custom Field''' in this part of the system. To understand how to create a new custom field by appropriately filling out the different settings, keep on reading the sections in this page below. |-||'''[[Field Data]] ''' ('''stack of coins icon) ''' ||Clicking this will open up a page that displays all the values that have been saved to the field. Custom Field Data consists of two general types: '''text type '''fields (saved as a text string) and '''object type''' fields (consisting of any files such as documents or images).''' ''' |-||'''[[Update History]] ''' ('''reload icon''') ||Clicking this will open up a page with a [[List View Overview|list]] of all of the updates to field settings that have been made on this field. |-||'''Search Reference''' ('''magnifying glass icon''') ||Clicking this will display all of the locations where the custom field is referenced in the system. For more information, see [[Custom Fields – General Information#Custom Field References]]. Fields are fully searchable for any related application. For example, [[User Role|role]]-level fields can be searched through the '''Search People '''feature or any application that provides access to contact data. You can also search and replace these values in bulk by using the '''Field Data '''button and specifying the old and new value required. |}The following settings are common to nearly all [[Custom Fields|Custom Field]] types::* [[#General Settings|General Settings]]:* [[#Display & Formatting|Display & Formatting]]:* [[#Validation|Validation]]:* [[#Feature Options|Feature Options]]:* [[#Value Storage|Value Storage]]{{FieldOptionsINFO}}{{DisplayINFO}}{{ValidationINFO}}{{FeatureOptionsINFO}}{{ValueStorageINFO}}<!--'''Referencing Field Names and Field IDs in other Custom Field Types'''

You can reference fields by name or by ID in other fields. The following field types support this type of referencing:

* '''Special''' – Calculated Value.

The syntax for these field types varies (some are processed on the server and other in a JavaScript in the client) and is explained for the individual field type.--> ==Permissions & Availability==The second tab available when opening a '''Custom Field '''is usually the '''Permissions & Availability '''section. Although the sectioning of permissions and availability will differ depending on what type of Custom Field it is, as well as to what part of the system it is attached to, the '''Permissions & Availability '''options might look something like this:

::: [[File:Custom fields permissions and availability.png|500px|border]]

Access to a [[Custom Field|custom field]] is controlled by permissions. These can be found and set in any custom field, on the Permissions and Availability tab. You can set only certain roles to be able to see/edit a field, or you can do the same thing with statuses. An example would be denying the '''Applicant''' role permission to see the '''Decision '''custom field (as this would reveal pre-emptively whether or not their application has been approved or denied).

{| class="wikitable"

|-

||'''Role - Field Permissions'''

||

'''Allow View Field: '''Click into this text box to select which roles will have the permission to ''view ''this field. When they open up a record in the system that has this field, they will be able to see the field and any content already inputted into it.

'''Allow Modify Field: '''Click into this text box to select which roles will have the permission to ''modify ''this field. When they open up a record in the system that has this field, they will be able to see the field as well as modify any content that is inputted into it, or put content if there is nothing inputted already.

'''Deny View Field: '''Click into this text box to select which roles will be ''denied ''permission to view this field. If they open up a record in the system with this field attached, they will not be able to see it on the record details.

'''Deny Modify Field: '''Click into this text box to select which roles will be ''denied ''permission to ''modify ''this field. If they open up a record in the system with this field attached, they will be able to view this field but ''not ''have the ability to modify its content at all.

|-

||'''Organizations Status - Field Permissions'''

||

'''Allow View Field: '''Click into this text box to select which [[Status|statuses]] will have permission to ''view ''this field. In this case the status must be relating to the organization - that is, only an organization that ''is ''in the selected statuses will be able to see this field when opening a record.

'''Allow Modify Field: '''Click into this text box to select which statuses will have permission to ''modify ''this field.

'''Deny View Field: '''Click into this text box to select which statuses will be ''denied ''permission to view this field. For example, an organization that is in '''Inactive ''''''Status '''might be denied permission to view fields as there is no need for them to know that information.

'''Deny Modify Field: '''Click into this text box to select which statuses will be ''denied ''permission to ''modify ''this field.

|-

||'''Category - Field Availability'''

||

'''Include Field For: '''Click into this text box to select which [[Client Categories|organization categories]] will have permission to have this field to fill out.

'''Exclude Field For: '''Click into this text box to select which [[Client Categories|organization categories]] will not have permission to have this field to fill out.

|}

See [[Role Field Permissions]] , [[Field Permissions]], or [[Status Field Permissions]] for more information.

<!--'''Special Field Name Syntax'''

* A '''@''' sign can be used with the built-in field Location in the [[Universal Tracking Application]] to connect the field to the [[User|user’s]] selected mapping service.

-->

<!--'''Field Type'''

The field type is used to define the characteristics of the field. There are over '''50''' field types currently available.

~~===Common Custom Field Settings===~~

~~Each custom field contains a button at the top linking it to the three following settings pages:~~

* [[Field Data]] - displays all the values that have been saved to the field.

* [[Update History]] - displays all the updates to field settings.

* [[Custom Field Language Settings|Language Setting]]

===[[display order|Display Order]]===

* This setting determines the order that the field will be displayed on the page. The first field that is added to an [[Entity|entity]] will use a display order of 10.

||Categories

|-

||UTA {{ l1}} Entities

||UTA Level 1 Template Entities

|}

You should start the number sequence for these types of related fields at some higher level. For example, role 1 starts at 5000, role 2 starts at 8000.

==Common Custom Field Settings==

Each custom field contains a button at the top linking it to the three following settings pages:

* [[Field Data]] - displays all the values that have been saved to the field.

* [[Update History]] - displays all the updates to field settings.-->

<!--* Search Reference - displays all locations where the custom field is referenced in the system.

===Tab Name===

* The tab name can be any text string.

* Custom fields that are not associated with a tab will be displayed on a tab named Default.

* The Tab Name option appears once the Advanced Options are enabled, on the Classic Options tab.--><!--

====Fields with No Tab Set====

[[Image:Cf4.png]]

====Same Fields with Tab set to Creation Details====

[[Image:Cf5.png]]-->

===Visibility Condition===

~~Whether or not~~ The '''Visibility Options '''section when opening a [[Custom Field~~|custom field]]~~ is ~~visible can be controlled using conditional statements in this box~~available under the '''Permissions and Availability '''tab once the '''Advanced Options '''feature has been enabled.

~~See~~ ::: [[~~Visibility Condition~~File:Custom fields visibility.png|500px|border]] ~~for more information~~In order to enable '''Advanced Options, '''you must toggle on the feature from the top right of your page.

::: [[File:Advanced options.png|150px|border]]

Whether or not a [[Custom Field|custom field]] is visible can be controlled using conditional statements in this box. You are able to set this visibility condition for new records based on the following options: '''Always Display, Hide on New Record, '''or '''Only Show on New Record.'''

See [[Visibility Condition]] for more information.

==~~=Role Field Permissions and Status Field Permissions=~~Classic Options==~~Access to~~ The last tab available when opening a [[Custom Field~~|custom field]]~~ record is ~~controlled by permissions~~usually the '''Classic Options '''section.

~~See~~ ::: [[~~Role Field Permissions~~File:Custom fields classic options.png|750px|border]] ~~or [[Status Field Permissions]] for more information~~ {| class="wikitable"|-||'''Tab Name'''||If you add a text value to the '''Tab Name, '''this field will be displayed on that tab.

~~[[Image~~:~~Cf8~~* The tab name can be any text string.~~png]]~~:* Custom Fields that are not associated with a tab will be displayed on a tab that is labelled '''Default.''':* The '''Tab Name '''option only appears once the '''Advanced Options '''are enabled on the '''Classic Options '''tab.

|-

||'''Custom HTML Tag'''

||

Use this field for additional attributes to the field HTML tag. For example, you can add HTML such as ''style="background-color"=00ff00 ''in order to color the background for this field box.

~~~~'''~~How Field Data is Stored~~Searchable - '''~~~~

~~Custom field data consists of two general types –~~ '''~~text type~~Read Only - ''' ~~fields and '''object type''' fields.~~

* Text Types fields are stored in the database as text strings.'''Enable [[KML]] - '''

~~These fields are fully searchable to any related application. For example, [[Role|role]] level fields can be searched though the~~ '''~~Search People~~Disable Quick Edit - ''' ~~feature or any application that provides access~~ Toggling on this option will not allow the user to ~~contact data~~modify this field using the system's [[Quick Edit]] functionality.

~~You can also search and replace these values in bulk by using the~~ '''Disable Field ~~Data~~from Global Search - ''' ~~tab and specifying~~ Toggling on this option will remove this field from any results that appear with the ~~old and new value required~~system's [[Global Search]] functionality.

|}===Custom Field References===This feature is intended to help determine the impact of a custom field change by highlighting where the custom field is referenced within the system.Each Custom field has a '''Search Reference'''--this button is found in the action bar, and can be identified by the magnifying glass icon.

* '''Object Type''' fields are stored on When used, the ~~server~~ feature will search references to this custom field via variable syntax in ~~a resource folder on the server.~~various areas, including:

~~These fields can consist of files of any type such as documents or images~~:* Other custom field options/visibility condition, including [[JavaScript Validation]], [[Visibility Condition]], [[Custom Field Type: Special – Calculated Value|calculated values]], etc. ~~Document type fields are searchable provided the '''File Index''' option is selected (this option is only available for these types of fields)~~:* [[Template / Type Formula|Template formulas]]:* [[Submit buttons]]:* [[Submit Logic]]:* [[SmartCheck Validation]]:* [[Workflow Task]]:* [[Creating_a_Single_Step_Workflow#Connecting_Tasks|Workflow connectors]]:* Data class policy[[Image:SearchReference2.png|border]]

===Import and Export Custom Fields===

You can use the custom field '''Import''' and '''Export''' features to move or copy custom fields from one [[Entity|entity]] to another (or even another instance of [[SmartSimple]]). The custom fields are exported and importing by using [[XML]] format.

To export a block of custom fields, simply click the ''Export'' button at the top of a list of custom fields. A window will pop up showing the custom field settings in XML format:

[[Image:ImportExportCustomFields.png|link=|500px]]

The XML block for the entire set of custom fields in the list will be displayed. Individual custom fields are delineated by the tags. Simply copy the block of custom fields you want to copy (you can make edits, e.g. to the [[display order]] in a text editor), click on the ''Import'' button at the top of the list of custom fields where you want to place the new fields, paste the XML block into the blank text area , and confirm that you want to import the fields by clicking ''Import'' at the bottom of the Import pop-up.

The majority of field settings will be included in the copied fields. Exceptions include:

:* any [[Field Permissions]]:* any [[Field Permission Matrix]] assigned to the original custom field:* any [[Value Stores To]] setting assigned on the original custom field:* the ''Description'' setting

However, [[Field Permissions]] and [[Field Permission Matrix|Field Permission Matrices]] can be assigned to the new fields using the [[Batch Update]] feature.

Also see [[Custom Field Import Wizard]]

~~===Custom Field References===~~

~~This feature is intended to help determine the impact of a custom field change by highlighting where the custom field is referenced within the system~~

~~Each Custom field has a '''Search Reference'''~~

~~[[Image:SearchReference1.png|border]]~~

~~When used the feature will search references to this custom field via variable syntax in various areas, including:~~

* Other custom field options/visibility condition, including [[JavaScript Validation]], [[Visibility Condition]], [[Custom Field Type: Special – Calculated Value|calculated values]], etc.

* [[Template / Type Formula|Template formulas]]

* [[Submit buttons]]

* [[Submit Logic]]

* [[SmartCheck Validation]]

* [[Workflow Task]]

* [[Creating_a_Single_Step_Workflow#Connecting_Tasks|Workflow connectors]]

* Data class policy

~~[[Image:SearchReference2.png|border]]~~

===Custom Field Types===

==See Also==

:* [[Batch Update Custom Field Settings]]:* [[Reporting on Custom Fields]]

[[Category:Custom Fields]]

← Older edit

Ciaran Donnelly

Smartstaff, administrator

4,478

edits

Changes

Custom Fields – General Information

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools