To get familiar with the basic capabilities of the product, we recommend exploring the available training courses in the system: https://academy.creatio.com/docs/training
Yes, this is the correct way. You added the columns at the object level using the replacement schema and now they are displayed at the page level that is linked to that object.
Unfortunately, at the moment there is no custom option to call this page in the custom functionality.
We have a task in the backlog to implement this feature in future versions of the application. We have raised the priority of the task taking into account your user experience.
This would be very useful for us too - selecting columns in the UI could be very helpful for creating marketplace tools to be used by others for no code configuration of things like import/export/integration tools.
I am trying to add the a currency lookup column to the country object, as it will be very helpful a specific use case we have to be able to know which countries use which currency. I have already created a new package with a replacing object to add the column, but now whenever I try to import the list of countries I get the following error:
The same error comes up when trying to bind the data via configuration as shown below:
You can see behind this message that it correctly adds the column from the replacing object I created, but it won't allow me to save it.
Any help in understanding what I am doing wrong would be very helpful.
It turns out the problem was that I did not publish the new object before compilation. After publishing and compiling once more the lookup works correctly with the new column!
It turns out the problem was that I did not publish the new object before compilation. After publishing and compiling once more the lookup works correctly with the new column!
Hello, I have a [Object A] form page where I have an Expanded List (detail) inside it [Object B] created. In [Object B] I need to have multiple records, so now I need to make a relationship between [Object A] and [Object B], but the app doesn't show me a relationship between IDs or anything like that.
I've already tried manually creating a Lookup inside [Object B] pointing to [Object A], but I was wondering if there's a better way to do it?
You need to create one-to-many relations between these objects. To do this, you need to create a lookup column in each object that will refer to another object. After that, you will be able to use filters and relationships to display and customize the necessary lists. You can't do it using no-code elements because this connection is set up at the object level.
You need to create one-to-many relations between these objects. To do this, you need to create a lookup column in each object that will refer to another object. After that, you will be able to use filters and relationships to display and customize the necessary lists. You can't do it using no-code elements because this connection is set up at the object level.
For the grid container, the size of one column will always depend on the size of the grid. For example, you have a 100x100 px grid with 2 columns, the grid will be divided into 2, each column taking a half of the space (with spacing specified in settings). You can of course take up a whole space with the element if needed.
You can modify the column set up in the grid container with system definer sizes like "small", "medium", "large" in the column spacing for example:
To clarify, my question was related to the list component, not the layout grid.
As it stands, the list component allows me to manually set the width of each column. However, this width can only be defined using a fixed size (like pixels), not percentages. This fixed sizing leads to two main issues:
On smaller screens: The content doesn't fit the screen width, resulting in the addition of a horizontal scrollbar.
On larger screens: There's excess white space to the right of the last column, as the columns do not expand to use the available width.
My goal is to have the column widths dynamically adjust to the screen size, utilizing percentages to ensure they fill the entire width of the list component, without unnecessary scrollbars or white space.
Is there a way to make the columns within the list component responsive, so that their widths adjust in proportion to the screen size, using percentages instead of fixed sizes?
Any guidance or suggestions on how to achieve this would be greatly appreciated.
SQL scripts can be utilized to implement the transfer of organizational structure settings and access rights from one environment to another. To do this, insert queries need to be generated on the reference environment based on records from the following tables:
SysAdminUnit (Administration object: users and roles)
SysUserInRole (Direct user role assignments)
SysFuncRoleInOrgRole (Functional role assignments to organizational roles)
SysAdminOperation (System operations, if necessary)
SysAdminOperationGrantee (Access to system operations, if necessary)
SysEntitySchemaOperationRight (Access to objects)
SysEntitySchemaRecordDefRight (Access to default records)
SysEntitySchemaColumnRight (Access to object columns)
SysAdminUnitGrantedRight (Delegation)
SysWorkplace – (User workplace)
SysAdminUnitInWorkplace – (Users in the workplace)
SysModuleInWorkplace – (Module in the workplace)
You can use Microsoft SQL Server Database Publishing Wizard or similar tools to generate queries. The resulting SQL script should be attached to the package. If the transfer is happening to a production environment, we recommend making a backup of the data beforehand and primarily deploying the package to a test environment to verify the script execution results. These tasks should be performed outside of business hours.
I am having a problem with a user that when he configures a column in the Cases section he saves it and displays it correctly, but when he goes to another section and then returns to the previous one he does not see the column change applied. What could be the cause of the problem?
Thank you very much for any help/comments you can give me.
To make a column mandatory in FreedomUI, you can follow these steps:
Identify the column you want to make mandatory in the detail view of your form.
Open the code or configuration file associated with your FreedomUI implementation.
Locate the section or code block related to the detail view of your form.
Find the column you want to make mandatory within the code or configuration.
Depending on the specific implementation of FreedomUI, you can typically add a validation rule or attribute to the column to make it mandatory.
Add the necessary code or configuration to enforce the mandatory requirement for the column. This may involve setting a "required" flag, adding a validation rule, or specifying a validation message.
Save your changes and test the form to ensure that the column is now mandatory in the detail view.
It's important to note that the exact steps may vary depending on the version and customization of FreedomUI you are using. Refer to the documentation or consult with the developers or support team of FreedomUI for specific guidance on making a column mandatory in the detail view.
The method described in the article you mention does work for me (In fact, I just did this yesterday with no issues).
Make sure that you've first configured the column layout and selected the "save for all users" and that you're selecting the correct row from the SysProfileData table (the one with no user in the "Contact" column.
If it's not working for you, it's likely one of the two issues listed above.
I see there are 2 duplicated records in SysProfileData forOrderSectionV2GridSettingsGridDataView
Select * from "SysProfileData"
Where "Key" = 'OrderSectionV2GridSettingsGridDataView'
AND "ContactId" IS NULL
AND "SysCultureId"='1a778e3f-0a8e-e111-84a3-00155d054c03'
And when I save columns setup in Order section for all users the new record is added. But when this new record in bound to the package and installed on Production site, my column setup is not applied.
How safe is it to remove existing 2 records that came out of the box?