Hello,

 

how is it possible to get Columns selection page for the object in Freedom UI? We need to get list of selected columns and save it for further usage



 

Kind regards,

Vladimir

Like 0

Like

0 comments
Show all comments

Hello,

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.

 

Thanks in advance!

Like 0

Like

1 comments
Best reply

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!

Show all comments

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?

Like 1

Like

1 comments
Best reply

Hello,

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.

Hello,

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.

Show all comments

Hi all,

 

Currently when I setup a list, the columns are not taking the full width of the grid. 

They have a fixed size and If I resize the screen columns sizes are not chaning. 

 

Is there any way to setup columns sizes as a % of the list grid width?

Like 1

Like

2 comments

Dear Andreas,

 

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:

 

 

You can read more about the grid container set up on Creatio Academy: https://academy.creatio.com/docs/8.x/no-code-customization/customizatio…

 

You can also use a flex container for a more flexible set up: https://academy.creatio.com/docs/8.x/no-code-customization/customizatio…

 

Have a great day!

Alina Yakovlieva,

 

Hi Alina,

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:

  1. On smaller screens: The content doesn't fit the screen width, resulting in the addition of a horizontal scrollbar.
  2. 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.

Thank you!

 

 

 

 

Show all comments

Hello, 



Do you know how to bind data for column permission in package? I have to bind the highlighted records in package. 



 

Like 4

Like

1 comments

Hello,

 

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.

 

Show all comments

Hi community, 

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.

Best regards!

Like 0

Like

1 comments

Hello!

Perhaps the cache of the browser has an effect on column display.

Could you kindly verify the page in incognito mode?

Show all comments

Hi Community,

 

I would like to know how we can make a column mandatory in an attachment list (the detail here) as soon as we upload a file to the detail.

 

 

Thanks in advance!

 

Regards,

Abilash.S

Like 0

Like

1 comments

To make a column mandatory in FreedomUI, you can follow these steps:

  1. Identify the column you want to make mandatory in the detail view of your form.

  2. Open the code or configuration file associated with your FreedomUI implementation.

  3. Locate the section or code block related to the detail view of your form.

  4. Find the column you want to make mandatory within the code or configuration.

  5. Depending on the specific implementation of FreedomUI, you can typically add a validation rule or attribute to the column to make it mandatory.

  6. 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.

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



More detail : https://360degreecloud.com/

Show all comments

As the title says, I'm trying to save the column layout for a custom record section, as well as for Details on the record.

 

https://customerfx.com/article/including-the-default-column-layout-for-…

Using this resource, I haven't managed to save any that will transfer over when installing a new package.

 

I have saved bound a number of records to the SysProfileData within my package, however none of them have had the intended effect.

https://gyazo.com/9c2347d0e5a3d845888edf5c94b221ab

Like 0

Like

2 comments

Hello Oliver,

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. 

Ryan

I appreciate the confidence in your article but I have 100% done both of these, about a thousand times, in every way possible.

 

Is this the only known solution/ there are no known issues with this?

Show all comments

Hello, 

 

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?



Thank you

Like 0

Like

1 comments

Hi,

There is a script that safely removes all duplicates in the table SysProfileData, you can use it:

delete

from "SysProfileData"

where "Id" in

  (

  select uuid(min("Id"))

  from "SysProfileData" 

  where "Key"<>'' and "Key"<>'chrome'and "Key"<>'gecko'

  group by "Key","ContactId", "SysCultureId"

  having count (*) > 1

  )

Show all comments

Hello!

 

I had a column in one of my objects that was deleted. In that column I was computing a sum with the help of a business process. After the deletion, I created another column in order to store that sum, but I cannot save the process as it gives me the following error:

The "ChangeDataUserTask1" element has an invalid value for the parameter "RecordColumnValues". Internal error: "Column with identifier "5edf4d5c-5df2-4c95-b1b7-0282f271b15b" not found in the entity schema "" ("924e0729-30d4-4c7f-a6bf-f203f4b0daef")"

I have checked in the database and the deleted column does not appear anymore, but neither the new one created, even though I saved and published the changes.

1. Why don't I see my new field in the db?

2. Why does the process still look for the first column, if it is deleted now?

3. How can I solve this issue so I can save my process?

Thank you in advance,

Maria

Like 0

Like

1 comments

Hello,

 

The most likely reason for such behavior is that you need to update your database structure and re-create the original business process.

 

To update your database you need to go into the configuration settings and click on "Update database structure where needed" under the action menu.

 

By re-create we meant that, unfortunately, you will have to create a new business process because the original one might still keep looking for an already deleted column.

 

If  you are still having issues, please feel free to contact our support by writing us an email at support@creatio.com

 

Thank you.

Show all comments