Dear,

On a lookup, i would like to filter the contacts having the account in job experience (ContactCareer). this is in the case of secondary job.

Currently filter show only account's contacts

i tryed in the orderpageV2:

            "UsrResponsableFacturation": {

                "dataValueType": Terrasoft.DataValueType.LOOKUP,

                "lookupListConfig": {

                    "filters": [function() {

                        var filters = Ext.create("Terrasoft.FilterGroup");

                        var accountId = this.get("Account");

                        filters.add("JobExperienceFilter", 

                            Terrasoft.createColumnFilterWithParameter(

                                Terrasoft.ComparisonType.EQUAL, 

                                "[Order:Account].ContactCareer.account.contact.name", 

                                accountId

                            )

                        );

                        return filters;

                    }]

                }

            }    

But it did not works.

 

I think the problem come from:

Terrasoft.createColumnFilterWithParameter(

                                Terrasoft.ComparisonType.EQUAL, 

                                "[Order:Account].ContactCareer.account.contact.name", 

                                accountId

                            )

I don't really understand how to access order's linked tables.

 

 

 

Does anybody can help me to solve this issue ?

Next i will only retrieve the contact with active job experience.

thank you

Nicolas

Like 0

Like

1 comments

Hi,

 

Please check your filter, it should be like '[ContactCareer:Contact].Account.Id'.

And also the second part on the screenshot, it should be 'this.get("Account").value'.

Show all comments

How to integrate facebook lead generation page with creatio? I tried to check in academy; couldn't find the relevant documentation.

Like 0

Like

1 comments

Hello!

 

The integration with Facebook lead generation forms has been added to the [Landing and Web Forms] section. Please note, this functionality requires the Identity Server system setting to be filled in (the required value can be requested from the Support team). 

 

You need to specify the domain of the Creatio website in a Facebook interface to start working with Facebook lead generation option.

 

To start the process of leads creation you should:

1) Authorize the Creatio application on Facebook side and delegate the application's rights to work with Facebook business pages.

2) Set up the correspondence of the landing page in Creatio application with the form on Facebook side for receiving leads.

 

All data filled in Facebook landing form will be sent to Creatio as leads records within 1-2 minutes.

 

Furthermore, you can:

1) Disable the process of leads registration for the landing page.

2) Remove social media pages and Creatio authorization from Creatio application.

 

Please, let us know in case any further information is required. 

 

Best regards, 

Olga. 

Show all comments

We are developing an external application to Creatio with integration via oData.

We need to know how to obtain with odata the required fields of a schema, for example contact and the data type of each field.

 

Thank you!

Regards

Like 0

Like

3 comments
Best reply

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

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?

Show all comments

Hi- 

How would I go about creating a business rule that does not allow users to save a certain email domain as an email address for a contact? 

For example- I don't want any emails that are for domain "ABC.com" 

Can I make a business rule that will not let them save that?

Like 0

Like

1 comments

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

Show all comments

Hi,

I am wanting to achieve the following:

1. Activity Status = Completed AND Category = To Do

2. Upon save, field validation occurs to display a pop-up (or similar) asking user to set a correct Category value

 

This is to improve data analytics for the category data, as currently my users are not changing this value when an activity is completed. A category of To Do, does not make sense if the activity is now complete you see.

I found this post - https://community.creatio.com/questions/messagebox-display-popup-box-requesting-user-confirm-some-situation, but I do not know how to complete this for the correct actions i.e. Only when the above condition is in place and click Yes means continue and submit the form or No means close window and allow user to change Category value.

Thanks for any help.

 

Like 0

Like

2 comments
Best reply

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

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 &&

Show all comments

Hello community!



The following article describes how to send a message from the Creatio server to the client via the WebSocket established out-of-the-box. Can we use the same WebSocket to send back messages to the server from the client?? If Yes, How?

Like 0

Like

1 comments

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

Show all comments

Hello community,



I have a few questions reg the out of the box time zones lookup. I looked up the Creatio academy and it does not have answers to my questions. 



1. Is the column 'American code' used anywhere? If Yes, why is it blank in the out-of-the-box time zone look up? What is this column meant for?

2. Is the time zone offset column used anywhere? I tried the following - 

Using data import, I changed the offset value of Alaska to 'GMT+5.30'. I then went to a system user contact whose time zone is set to Alaska. I still see the time as per Alaska and not as per GMT+5.30. From where does Creatio retrieve offset values to show local time in a contact's time zone?

3. Similar to #2, I renamed the 'Code' column for Alaska to Gibberish. Now the System does not show any local time in the contact profile.



I infer that, Creatio reads the 'Code' value and fetches the offset from Windows server settings? Can you also confirm that Creatio does not use the 'Offset' column given in the lookup?

Like 0

Like

3 comments

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

Show all comments

Hello community,



We are using Creatio 7.16.3 Service enterprise on-premises (Infra on AWS cloud). We have a use case where certain fields on the Creatio GUI need to send and receive real time updates for a specific user across multiple browser client instances that s/he might be using.



We have zero-ed in on Firebase real time database to maintain state on the server side. We plan to establish Creatio client - Firebase interaction via the Firebase JS SDK to send and receive real time updates. Few clarifications below - 

 

1. Have there been known instances of Creatio successfully integrating with Firebase real time database in the past? If Yes, any available material/documentation around the same would help. 

2. Are there any gotchas or limitations we need to keep in mind from an implementation, security and performance perspectives specific to the Creatio product while integrating with Firebase real time database? Eg with Service workers. 

3. Firebase provides for including the JS SDK via a CDN link. I went through this article on how to include external JS libraries- https://community.creatio.com/questions/how-include-external-js-library-bpmonline. The answer provided seems incomplete/inconclusive. Would appreciate if someone could respond to my query. 

4. Is there a way to directly inject a CDN link globally on Creatio without having to physically include the contents of the file as suggested in the above link?



Thanks in advance!

Shrikanth

Like 0

Like

1 comments

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

Show all comments

Hello community!



I have a use case where I need to send a reminder email to all users of a certain organization role at 9 AM their morning as per the timezone they have chosen.

 

I cannot use the Start timer element in the business process as it only lets you choose one timezone and not the user's timezone. 

Like 0

Like

3 comments

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

Show all comments

I only have one option to add a date to my section. 

 

The problem is that it shows the date AND the time-

 

I just need the DATE.

 

How do I get just the Date?

 

Thanks for your help!

Heather

 

 

Like 0

Like

2 comments

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!!!!!

Show all comments