Время создания
Filters
AI
CreateChart
Sales_Creatio
8.0

Hi,

I have hit this so many times now, so it is time to post and get someone to guide me on how I can get the Creatio AI to actually create the charts I want.

I post my request in this way:

Add a chart to this dashboard which shows the Sum of the Product Total, where the Product is in the Product Family lookup 'ITSM'

Use the 'Order' data source and correlate the 'Products in Order' data source to the 'Products', which then contains the field for Product Family

This is what I always seem to get back:

I’m having difficulty identifying the correct data source for "Product Total" and "Product Family" in your system. Could you clarify the name of the section or entity where the product totals and product families are stored? For example, is it “Product”, “Order Products”, “Opportunity Products”, or something similar? 

Once you provide this information, I’ll be able to create the chart widget exactly as you need.

Multiple passes at providing the same information in different ways, does not get me to the point of the AI adding the chart. Please help, as AI is not.

 

Like 0

Like

0 comments
Show all comments
Hubspot
synchronization

Hi,

I'm working on an integration between Creatio and HubSpot, and I noticed that we already have a package in Creatio called “HubSpotSync” that includes several business processes, objects, and other components.

However, I can’t find any information about it in Creatio documentation or here in the community.

Does anyone know anything about this package?

  • Is it an official Creatio app or a custom implementation?
  • Is there any documentation on its capabilities and intended use?
  • Has anyone worked with it before?

Any information would be very helpful. Thanks!

Like 0

Like

0 comments
Show all comments

Hi Team,

Is there a way to change the default calendar view so that the week starts on Monday instead of Sunday?

We tried changing the Workweek settings in the calendar, but it did not change the start day of the week.

Our current Creatio version is 8.3.3.3193. Could you please confirm if this change is possible in this version?

Thanks.

Tanu Shree

Like 0

Like

2 comments

Tanu Shree,

You can go to user profile and update the "First day of the weelk"
User profile

To automate it: Crete SQL script - Trigger


-- PART 1: GLOBAL UPDATE FOR EXISTING USERS
-- Applies the default TimeZone (MST) and DateTimeFormat (English - Canada) to all current users with a Contact.

UPDATE "SysAdminUnit" 
SET "DateTimeFormatId" = '6ebc31fa-ee6c-48e9-81bf-8003ac03b019'::uuid, 
    "WeekFirstDayId" = 'b42f7658-b2a1-4139-8595-1ee319cbfb8a'::uuid,
    "TimeZoneId" = 'Mountain Standard Time' 
WHERE "ContactId" IS NOT NULL;

CREATE OR REPLACE FUNCTION fn_sysadminunit_set_defaults()
RETURNS TRIGGER AS $$
BEGIN
   -- Only apply to actual user records (which have a ContactId), ignoring roles/groups.
   IF NEW."ContactId" IS NOT NULL THEN
       NEW."DateTimeFormatId" := '6ebc31fa-ee6c-48e9-81bf-8003ac03b019'::uuid;
        --NEW."LanguageId" = '41c3fb27-9e5a-4a17-a0d7-f8fb7e00bab1'::uuid;
        NEW."WeekFirstDayId" = 'b42f7658-b2a1-4139-8595-1ee319cbfb8a'::uuid;
       NEW."TimeZoneId" := 'Mountain Standard Time';
   END IF;
   
   RETURN NEW;
END;
$$ LANGUAGE plpgsql;


DROP TRIGGER IF EXISTS trg_sysadminunit_set_defaults ON "SysAdminUnit";
CREATE TRIGGER trg_sysadminunit_set_defaults
BEFORE INSERT ON "SysAdminUnit"
FOR EACH ROW
EXECUTE FUNCTION fn_sysadminunit_set_defaults();

Thank You Bhoobalan Palanivelu for the response it worked.

Show all comments
tags
Lead
Sales_Creatio
8.0

Hi Community,

I am facing an issue while trying to add Tags on the Lead section in Creatio.

I checked multiple objects and configurations, including:

  • Lead section record tag
  • Lead record tag
  • Tag
  • Tag in Schema
  • Tag in record

However, users are still unable to add tags on Lead records.

I would like to understand:

  1. Which object is actually responsible for storing and enabling tags for Leads?
  2. Which relationship/object should be used specifically for the Lead section?
  3. Are there any mandatory filters or lookup configurations required to make tags visible and selectable on Leads?

Could someone please guide me on:

  • The correct object mapping for Lead tags

     

Thanks in advance.

Like 0

Like

1 comments

Hello Nikita,

We noticed that you have also submitted a support case. We will continue our communication there.

Have a great day!

Show all comments
dashboards
cases
Grouping
analytics
Service_Creatio
8.0

Hi Community,

I'm working on a Cases opened/closed by Assigned Team (monthly) dashboard widget and have run into a limitation I'm hoping someone can help with.

Requirement: Our Head of Department wants to view cases grouped by both Assigned Team and Category as columns in the same chart widget — for a quick breakdown at a glance.

Problem: Out of the box, the widget only allows a single "Group by" field. When I set it to "Assigned Team", I lose the Category breakdown — and vice versa. There's no built-in option to add a second grouping column.

widget setup showing only one Group By option available

What I'm looking for: A way to group by both Assigned Team and Category in one widget — any workaround, configuration tip, or recommended approach would be greatly appreciated.

Like 0

Like

0 comments
Show all comments