About the Multi Select Text and Multi Select SQL Field Types

Aptify release 7.1 introduces two form components namely, Text Multi Select and Text Multi Select SQL, in Aptify Web. These components support only text (nvarchar) fields. Users can manually add these components to any form template via Smart Client. When added to a form, the components allow users to select multiple options from a drop-down list. 

Creating fields for the new form components

This section provides an overview of the necessary configuration settings required to ensure that the new field on a generated entity form is configured as a text field type. For each field type, follow the steps in General Steps for Creating a Field and modify the fields record as described in each section below.

• Text Multi Select SQL

• Text Multi Select

Text Multi-Select SQL

Text Multi Select SQL form component uses the same approach as the Data Combo drop-down list. In this approach, the field displays a list of records from another table in the database. You should use this control if you want to provide users with a drop-down list of pre-populated items from another table. By specifying a SQL statement, you define the drop-down's list contents, and you can display more than one column from the corresponding table.

Use the following settings to create a Text Multi Select SQL form component:

1. Log in to Aptify Smart Client.
2. Create a new entity under the desired application and create records for the entity. For example purpose, an entity named Interest is created under Customer Management.
3. Go to the entity where you want to configure the text multi select SQL field.  Create a new field for example, Interest field.
4. In the General tab, configure the following:
   SQLData Type: Enter value as nvarchar
   SQLField Size: Enter the size for this field.
   

5. In the Values tab configure the following:

   GUIType Single Select: Select Not Supported
   GUIType Multi Select: Select Supported - Standard
   Value List Type: Select Static List.
   

6. After creating the field, save and close the entity.
7. Configure Design in Place Edit on the entity record.  Refer About the Visual Designer Data Combo Box to know about the Input Properties. 
   
   Note: The control appears in desktop as a dropdown and not as a multi-select combo box. This control is built to work ONLY in Aptify Web.
8. Run the Metadata Process Flows (for both the entities) so that the components are visible in Aptify Web.
9. Reset the IIS and clear the browser cache.
10. Log in to Aptify Web and navigate to the form where you have added the Text Multi Select SQL form component.
11. Click combo box against the field and select multiple options from the list, the options are selected and arranged alphabetically. 
    
    
12. To remove a value, click the X icon on that particular value.
    
    
13. To remove all the selected values, click the generic X icon on the combo box as shown in below screenshot.
    
    
14. Click Save.

Text Multi Select

Text Multi Select combo box uses the same approach as the regular combo drop-down list, it pulls the values from the field value list.

Use the following settings to create a Text Multi-Select combo box. 

1. Log in to Aptify Smart Client.
2. Go to the entity where you want to configure the Text Multi Select field. Create a new field for example, Education field.
3. In the General tab, configure the following:
   • SQLData Type: Enter value as nvarchar
   • SQLField Size: Enter the size for this field.
     
4. In the Values tab configure the following:
   
   • GUIType Single Select: Select Not Supported.
   • GUIType Multi Select: Select Supported - Standard
   • Value List Type: Select Static List.
   • Create new records that need to populate under the combo box. 
     
5. Configure Design in Place Edit on the entity record. Refer About the Visual Designer Combo Box to know about the Input Properties. 
   
   
6. Run the Metadata Process Flows so that the components are visible in Aptify Web.
7. Reset the IIS and clear the browser cache.
8. Log in to Aptify Web and navigate to the form where you have added the Text Multi Select form component.
9. Click combo box against the field and select the multiple values from the list, the values are selected and arranged alphabetically. 
   
   
10. To remove a value, click the X icon on that particular value.
    
    
11. To remove all the selected values, click the generic X icon on the combo box as shown in below screenshot.
    
    
12. Click Save. 

⚠ Note

If you create a view, the values in the text multi select field appear as sorted, comma-separated values of selections.

The new form components support the contains clause while creating views with filters. 

Below screen shot shows the results of the view with contains clause.

 

Related Topics

Using Forms and Records

Using the Find Dialog

Using the Form Command Buttons

Working with Record Attachments