Special Input Types field settings in SmartSimple include configuration options organized by field type. Use these settings to look up the available options for each code set lookup, data table, dynamic control, record, map, rich text, and question set field.
Lookup - ICD Codes
Provides a searchable lookup of International Statistical Classification of Diseases and Related Health Problems (ICD) codes, the medical classification list established by the World Health Organization, currently in its tenth revision. The field stores the ICD code, such as G44.0.
ICD codes cover diseases, signs and symptoms, abnormal findings, complaints, social circumstances, and external causes of injury and disease. This field supports KML mapping and can display the code description with system variables.
Lookup - MeSH Codes
Provides a searchable lookup of Medical Subject Headings (MeSH), the controlled medical vocabulary maintained by the National Library of Medicine. Users search by code or description and select a match. The field stores the MeSH code.
Lookup - NACE 2.0 Codes
Provides a searchable lookup of Nomenclature of Economic Activities (NACE) 2.0 codes, the statistical classification of economic activities, business sectors, and industry types used in the European Union. Users search by code or description and select a match.
Additional configuration options for this field, such as region settings, mapping support, and the field type ID, are not yet documented. Confirm these details with the PE team before publishing.
Lookup - NACE 2.1 Codes
Provides a searchable lookup of Nomenclature of Economic Activities (NACE) 2.1 codes for classifying economic activities. Users search by code or description and select a match.
The distinction between this field and Lookup - NACE 2.0 Codes, along with its configuration options and field type ID, is not yet documented. Confirm these details with the PE team before publishing.
Lookup - NAIC Codes
Provides a searchable lookup of North American Industry Classification System (NAICS) codes for classifying business establishments. NAIC codes appear as a standard organizational field for a company, and the field supports KML mapping.
When you enable the field, select the region for the codes:
| Region | Description |
|---|---|
| US NAIC | Presents NAIC codes for businesses in the United States. |
| Canada NAIC, English | Presents NAIC codes in English for Canadian businesses. |
| Canada NAIC, French | Presents NAIC codes in French for Canadian businesses. |
Select One - Dynamic Dropdown List and Select One - Dynamic Radio Buttons
Dynamic control fields establish sets of fields that depend on the value a user selects. The two field types are Select One - Dynamic Dropdown List and Select One - Dynamic Radio Buttons. Sub-fields are created under each field. You can define the Parent Values that the sub-field will be exposed for.
| Setting | Description |
|---|---|
| From Custom Field(s) | The custom field or fields the dependent values are derived from. |
| To Custom Field | The custom field the values are sent to. |
Standard validation, permission, and availability settings apply to these fields as they do to other custom fields.
Special - Advanced Data Table
Creates structured worksheets and tables, such as budgets and data lists, using configurable sections, dynamic rows, and cell calculations. Data is stored in XML, and the field can display related Level 2 or Level 3 records within a parent record.
Field Options
The Advanced Data Table field includes the following configuration options:
| Setting | Description |
|---|---|
| XSL Template | Defines how the XML data displays. |
| Mapping | Maps tags for the stored XML data. |
| Custom Script Function | Enables custom validation or scripting. |
| Show View XML Button | Displays the raw XML data. |
| Show Upload Button | Allows importing XML files. |
| Show Up/Down Controls | Let users reorder rows. |
| Show Clear Button | Clears all values from the table. |
| Custom Field IDs | Reference fields directly to improve performance. |
Cell Calculations
Cells are referenced as [row,column] and combined with the operators add (+), subtract (-), multiply (*), and divide (/). For example, =[1,1]+[2,1] adds two cells.
| Operation | Symbol | Example |
|---|---|---|
| Add | + | =[row#,column#]+[row#,column#] |
| Subtract | - | =[row#,column#]-[row#,column#] |
| Divide | / | =[row#,column#]/[row#,column#] |
| Multiply | * | =[row#,column#]*[row#,column#] |
Validation
The Advanced Data Table field supports the following validation options:
| Setting | Description |
|---|---|
| Validation Script | Defines the validation logic for the field. |
| Validation Message | The error shown when validation fails. |
Validation can also be applied with SmartCheck (recommended), Submit Logic, or a Browser Script.
Displaying Data
To display table content on a record without opening the table, use the Display - Text and Variables field with the following syntax, where CustomFieldName is the field name and SectionNodeName is the section:
@xml.CustomFieldName.SectionNodeName.html@
Refer to cells in different sections using the following syntax:
[@section.sectionname.id@_rownodename_columnnodename]
If you need to display data in the header of a section (row 0) from another section, you can use the following:
@xml.customfieldname.sectionnodename.rownodename.columnnodename@
Special - Basic Data Table
Creates a straightforward data sheet that displays inline on the record and opens within the current form. It is a simplified data table built with the Section Builder.
| Setting | Description |
|---|---|
| Number of Rows | The number of rows in the table. Enter 0 to let users add rows dynamically. |
| Number of Columns | The number of columns in the table. |
| Caption | The label for a column header or row cell. |
| CSS Class | The style class applied to a cell. |
| Validation | The cell value type: text, number, comma, date, currency, or percent. Number, comma, and percent support precision settings. |
| Show Total | Adds a total row that calculates the column total. Available when Number of Rows is 0. |
| Mandatory | Requires a value in the cell. |
Special - Geo Mapping
Identifies and highlights selected geographic locations on a map.
| Setting | Description |
|---|---|
| Drawing Options | The available drawing tools for the map. |
| Fill Color | The color applied to a drawn area. |
| Stroke Color | The color of the outlines. |
| Stroke Width | The thickness of the outlines. |
Special - Linked Record List
Lets users view, select, and add related records to a Level 1 record without leaving the page. Set the List Type to Contacts, Companies, or Activity List. Each list type reveals its own options.
Contacts Options
When List Type is set to Contacts, the following options are available:
| Setting | Description |
|---|---|
| List View | A Contact list view, set in UTA/module configuration on the Level 1 settings tab under Contact Association Settings. |
| Lookup List View | Select the list view when using the Contact Lookup button. |
| Association Role Filter | Filters the list by Contact role. |
| Enable Signup Page for Creation | Adds a signup page used to create a new user. The signup page list shows entries as Associated Company - Description. The create option appears only when a search returns no match. |
Companies Options
When List Type is set to Companies, the following options are available:
| Setting | Description |
|---|---|
| List View | An Account list view, set in UTA/module configuration on the Level 1 settings tab under Account Association Settings. |
| Lookup List View | Select the list view when using the Contact Lookup button. |
| Association Role Filter | Filters the list by Account Association role, set under Account Association Settings or in Global Settings. |
| Enable Signup Page for Creation | Adds a signup page used to create a new company. |
Activity List Options
When List Type is set to Activity List, the following options are available:
| Setting | Description |
|---|---|
| Status Filter | Filters by available Level 2 status. |
| Type Filter | Filters by available Level 2 type. |
| Creation Status | The default status applied when creating a new Level 2 record from the field. |
| Creation Type | The default Level 2 type applied when creating a new Level 2 record from the field. |
| Default Country | Used as a focal point for the map. |
Special - Question Set Builder
Lets users who are not Global Administrators build their own set of questions on a record, with responses stored in child records. Individual responses are viewed from the specific activity. Setting up a question set uses two field types, and scoring adds a third.
| Field | Description |
|---|---|
| Special - Question Set Builder | The Level 1 field where questions are built. Select Enable Scoring to score responses, then set a Correct Answer and Score for each question. |
| Special - Question Set | The Level 1 or Level 2 field that displays the questions. Set its Source Field to the Question Set Builder field. |
| Special - Scoring Results | The Level 2 field that stores the calculated score. Use a Field Name with no spaces so it can be referenced in the scoring formula. |
Special - Rich Text
A text box paired with the HTML Editor. Users enter and format content with a toolbar. The field is useful for formatted content but carries the entry, export, and performance considerations described below.
Field Options
The Special - Rich Text field includes the following configuration options:
| Setting | Description |
|---|---|
| Maximum Length | The maximum length of the text entry. |
| Minimum Length | The minimum length of the text entry. |
| Show Counter | Displays a counter to the user. |
| Count Words | Counts words instead of characters, which is the default. |
| Exceeded Maximum Message | The message shown when the entry reaches the maximum length. |
Toolbar Controls
The HTML Editor toolbar provides the following controls:
- Select Font Family
- Select Font Size
- Set Line Height
- Bold
- Italic
- Underline
- Strikethrough
- Subscript
- Superscript
- Background Color
- Font Color
- Insert Ordered List
- Insert Unordered List
- Indent
- Dedent
- Align Text Left
- Center Text
- Align Text Right
- Justify Alignment
- Insert Hyperlink
- Insert Image
- Remove Hyperlink
- View HTML
- Create a Table
Considerations
Field Type IDs for Import and Export
Custom fields can be exported and imported as XML to copy them between entities or sites. Custom field IDs are unique and are reassigned on import. Use the following field type IDs when importing a code set field:
| Field Type | Field Type ID |
|---|---|
| Lookup - MeSH Codes | 81 |
| Lookup - ICD Codes | 74 |
| Lookup - NAIC Codes | 77 |
Display Code Descriptions with System Variables
A code set field stores the code itself, such as G44.0, not its description. To display the description, such as Cluster Headache Syndrome, use the following syntax in a Read Only - System Variables field, a Web Page View, or another context that supports system variables, where fieldname is the name of the code set field:
@fieldname.value@ / {{fieldname.value}}