Hello,

We already have a support case on this matter. The solution has been already provided. 

Hello,

"Other phone" and "Extension phone" are communication types only, not objects and their values are stored in the "ContactCommunication" table (actual number is stored in the "Number" column) with the correspondent "CommunicationTypeId" (Id correspondent values can be reviewed in the "CommunicationType" table). Also these communication types have no correspondent columns on the "Contact" enity side.

Oleg Drobina,

Thank you for your answer! Do you know what I can do to create a validation for these two? I created 2 fields in the Contact object and now I want to somehow connect them to the ones from Comunications.

Ghiu Diana Stefania,

In this case you need to create a logic similar to the one that is triggered when new communication option is added to the ContactCommunication object (see the logic in the SynchronizeCommunicationWithEntity method from the CommunicationSynchronizer source code). Alternatively you can try creating a custom business process that will update a main contact record in case new value was added to contact communication option.

Dear Kevin,

Here is the example:

You can add the "order" attribute for every field that you need to sort to the edit page schema where the field is located.

In the following example we created the integer "UsrSorting" field in the lookup UsrTestLookup1 and copied the values from the "Name" field there. 

https://prnt.sc/kg623a

attributes: {

            "UsrTestLookup1": {

                lookupListConfig: {

                    orders: [

                        {

                            columnPath: "UsrSorting",

                            direction: Terrasoft.OrderDirection.ASC

                        }

                    ]

                }

            }

        },

The result - https://prnt.sc/kg62ci

You can try to implement the same logic to the 'Communication option types by communication type' lookup.

Regards,

Dean

That is great and I've seen that use before. However, I cannot find the correct name in order to reference the communication type lookup.

Dear Kevin,

In order to sort the communications options please do the following:

1. Create a replacing client module for the “ContactCommunicationDetail” schema.

2. Add the following code to the schema:

define("ContactCommunicationDetail", [], function(){

    return{

        methods: {

            initCommunicationTypes: function(callback){

                var esq = this.Ext.create("Terrasoft.EntitySchemaQuery", {

                        rootSchemaName: "CommunicationType",

                        isDistinct: true

                    });

                esq.addMacrosColumn(this.Terrasoft.QueryMacrosType.PRIMARY_COLUMN, "Id");

                var nameColumn = esq.addMacrosColumn(this.Terrasoft.QueryMacrosType.PRIMARY_DISPLAY_COLUMN, "Name");

                nameColumn.orderDirection = Terrasoft.OrderDirection.ASC;

                esq.addColumn("[ComTypebyCommunication:CommunicationType:Id].Communication", "CommunicationId");

                this.initCommunicationTypesFilters(esq);

                esq.getEntityCollection(function(response) {

                    if (response.success) {

                        var entityCollection = response.collection;

                        this.set("CommunicationTypes", entityCollection);

                    }

                    callback.call(this);

                }, this);

            }

        }    

    };    

});

Best regards,

Norton

Dear Kevin,

In order to group emails please open the “Communication option types” lookup https://prnt.sc/rha66n , click on the record and choose the following option https://prnt.sc/rha708 . In the opened page, please add records to the “Communication types” detail https://prnt.sc/rha8s0 . As a result, the option will be grouped https://prnt.sc/rha9p6  

Best regards,

Norton