Hello Uriel,

Once authenticated normally, you can do a POST to the following (it's DataService, but when you authenticate for OData it will also work for DataService, even if you're using OData for the other requests):

/0/DataService/json/SyncReply/RuntimeEntitySchemaRequest

Include the following payload in the request:

{"uId":"25d7c1ab-1de0-4501-b402-02e0e5a72d6e"}

Where the uId included is the UId for the entity (you can get this from SysSchema or VwSysSchemaInWorkspace where ExtendParent = false). You'll get back a json payload with details for all columns, including the "isRequired" value for the column.

Ryan

Ryan Farley,

Thank you! Have a nice weekend.

Ryan Farley,

Hello,

I need to update, using odata, a record in Creatio, but there are one or more fields that are required to be completed, on the Creatio side (Form_Page) that are not completed and I get error when updating those records using odata.

Is there any way to skip the required field rules (fields not related to the integration) and get the object update using odata?

Dear Heather,

To set up validation for email you can use Email address mask system setting - feel free to adjust the RegExp upon your needs.

Best regards,

Angela

Hello Mark, 



Please refer to the following code in order to add the functionality requested:

 

define("ActivityPageV2", [], function() {
    return {
        entitySchemaName: "Activity",
        messages: {
        },
        methods: {
            save: function() {
                var IsToDoCategory = this.get("ActivityCategory") && 
                    this.get("ActivityCategory").value === "f51c4643-58e6-df11-971b-001d60e938c6";
                var IsCompletedStatus = this.get("Status") && 
                    this.get("Status").value === "4bdbb88f-58e6-df11-971b-001d60e938c6";
                if (IsCompletedStatus && IsToDoCategory) {
                    this.showConfirmationDialog("Please, set proper category!");
                } else {
                    this.callParent(arguments);
                }
            }
        },
        details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
        diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/
    };

Kind regards,

Roman

Thanks for your reply Roman, this worked beautifully.

I am interested in the GUID values you have in the code, is there any meaning to these values?

Note for others, the code above needs the && replaced with &&

Hello,

We don't have a possibility to send the Websocket message from the client to server since there is nothing to handle this message on the server. In this case you can create your custom configuration service and send requests via this service - here is an example of such a service https://academy.creatio.com/documents/technic-sdk/7-16/creating-configuration-service-0

Best regards,

Oscar

Hello Shrikanth,

Hope you're doing well.

The time which is displayed in the system is based on the server time + value of the user profile offset column. If you are using the OOB columns, you need to check the server time by running the next query:

SELECT GETUTCDATE()

The result of this query will show the current UTC server time. After that, you can compare these data with your user's time zones settings.

As I can understand, you have changed the "Code" and "Time zone offset" column via DB, as far as the lookup "Time zones" is a system lookup that is locked for editing (except of the "Name" column). Blocked values are needed for login in the system. After editing or adding a new value users with this time zone sometimes can have troubles with the login process, so this is why those columns are locked. Also, need to pay attention to the address of the contact, because the city/state can have the time zone which is different from the default time zone for that country.

Best regards,

Roman

Roman Rak,

Hi Roman. Thanks for your response. Yes, I did check the address' city/state and ensured that they are valid for my use case.



#2 - I changed the offset column value and still no change happened (I logged out/logged in, refreshed page, cleared Redis cache etc).

I even changed the offset to 'UTC+5:30', It still showed Alaska time. This is noteworthy because, all the default offsets are in GMT. I changed it to UTC and expected the system to break. It didn't. It still showed me Alaska time. This makes me doubt if this column is being used at all.



#1 - What about 'American code' column?

Hello Shrikanth,

Thank you for your questions.

About the 'American code' column: at the moment this column is out of use and doesn't affect any functionality. If you want us to delete this column (or add/edit any other system columns/settings/values), please inform the Creatio support team.

At the moment there is no possibility to change the records for 'Time zone offset' and 'Code' columns via standard system tools because they are related to system settings and have unique values in the DB. Also during the populating the "Time zones" lookup developers added all actual timezones at the moment. We really appreciate your idea and have created the feature request for providing the possibility of adding/changing  "Time zones" lookup records in the future releases of the Creatio application.

Best regards,

Roman

Hello Shrikanth,

Please find my answers bellow:

1. We have checked the existing case history but unfortunately didn't find any request related to integration with Firebase service, sorry.

2. Unfortunately, we don't have any specific best practices for integrations. It is necessary to use generally accepted engineering practices and instructions but we will happy to assist with any difficulties you may have.

3. This question was already answered in the mentioned community post. Duplicating the answer here:

"Please call jQuery.getScript function in the console and review the sources tab as I recommended and use it as an example to add your own jQuery to the system"

4. As of now, there is no way to use CDN link in the Creatio application. If it will be available in future releases, you will be able to find this information in the Creatio release notes.

Please let us know if you have any other questions.

Best regards,

Roman

Dear Shrikanth,

If for example organization role contains 50 users and each user has different timezone (not all of them have the same timezone) you will need to start the process 50 times and distinct "processed" users from "unprocessed". Since the amount of timezones is limited it will be easier for you to tag users who should receive an email by some role or other method and create a separate process for sending emails for each time zone instead of each user. 

Best regards,

Angela

Angela Reyes,

Hi Angela. Users can belong to any time zone (There are 110 in total) and new users will get added dynamically with maybe new time zones. Also, the time zone's of users can change depending on the user's global travel. 



Adding one BP per time zone is not maintainable down the line. Can I have one BP which will send Emails as per the time zone of the user?

Is there a way we can write code or use the Quartz.Net scheduler to achieve this?

M Shrikanth,

Usually, it is achievable by timer event but since you have many emails that can be sent in 1 day this cannot be done via one process - only several, according to main time zones (for example). Main timezones are 

From east to west they are Atlantic Standard Time (AST), Eastern Standard Time (EST), Central Standard Time (CST), Mountain Standard Time (MST), Pacific Standard Time (PST), Alaskan Standard Time (AKST), Hawaii-Aleutian Standard Time (HST), Samoa standard time (UTC-11) and Chamorro Standard Time (UTC+10). 

If you want to create task in quartz for each timezone it will greatly impact system performance due to the huge amount of data. 

Best regards,

Angela

Hello Heather,

Please go to configurations and find the object that represents the section where the date\time field was added. Open this object and find your date\field column there, click on it and select displaying all column properties:

Once done please change the data type to "Date":

and save and publish the object once it is done. As a result you will see only dates in this column.

Best regards,

Oscar

Thank You!!!!!

Hello Marcin, 

Unfortunately, there is no basic option to "freeze" the information in the CRM system for further comparison. 

We recommend using the Change Log functionality to view the changes made to your website's data. 

Best regards, 

Olga. 

Dear Glenn,

Unfortunately, there is no documentation for Terrasoft.sdk.RecordPage. However, it is possible to create a multiline text field in a mobile application in the same way as it was shown in Terrasoft.sdk.GridPage documentation.

Please find an example of how to add the multiline “Name” field to an edit-page below:

Terrasoft.sdk.RecordPage.addColumn('Contact', {

    name: 'Name',

    position: 0,

    isMultiline: true,

    label: 'CustomContactRecordPage_primaryColumnset_Name_label'

});

Best regards,

Norton

Norton Lingard,

That seems the same as what I tried in a modified version of the mobile detail example, which did not work for me.

Terrasoft.sdk.GridPage.setPrimaryColumn("ContactCareer", "Description");

// Adding the [description] column to the primary column collection.

Terrasoft.sdk.RecordPage.addColumn("ContactCareer", {

        name: "Description",

        isMultiline: true,

        position: 1

    }, "primaryColumnSet");

// Delete the [Contact] previous primary column  from the primary column collection.

Terrasoft.sdk.RecordPage.removeColumn("ContactCareer", "Contact", "primaryColumnSet");

Norton Lingard,

Additional update.  It shows about 45 characters on one line followed by ...   If I click again on that text it shows the full multiline text.  Is that expected behavior?

Glenn Smith,

Please see a multiline text field on Account edit page, it is the “Name” field. This field is configured in the “MobileAccountModuleConfig” module from the “Mobile” package.

Best regards,

Norton

Norton Lingard,

attached are 3 screenshots.  first is the list view with Job Experience detail at the bottom.  Next is after clicking Job Experience detail.  Note that it only shows one line of text.  Third is after I click on the single line text, it shows full multi-line text

Norton Lingard,

second image

Norton Lingard,

third image

Glenn Smith,

Yes, it is an expected behavior of the application.

Best regards,

Norton

Thanks