Hi!

I'd like to add many-to-many relationship between Account and Contact. I've created an object "Account - Contact" and added some records to it.

Now I'd like to add a folder on Contacts list for displaying those contacts, who are related with "Our company" Account. Unfortunately, the list of columns for "Account - Contact" does not contain neither relationship-related lookup fields (like Contact, Account) nor any additional columns, stored in this object. There are only Quantity and some date fields.

 

 

I've tried to debug it and I realized that JSONs for DataService, which are generated by filter designer, try to use some aggregation function. Is there any way to solve my problem? The solution doesn't have to be simple and possible to do it by GUI :) I can modify the JSON, but so far I couldn't do it correctly in this case.

 

Is is technically possible for DataService, to use simple comparison in lookup for backward related objects, like "Account - Contact", or I'm restricted to use some kind of aggregation?

 

 

 

Like 0

Like

0 comments
Show all comments

Hi Community,

 

We have this business requirement where we need to add duplicated communication options. For example, we can have two records for the same phone number.

 

When we try to add the same number, we receive the following error:

 

How can we turn off this validation/constraint? 

 

Thank you in advance.

Best Regards,

Pedro Pinheiro

Like 0

Like

0 comments
Show all comments

As the title says, we sometimes need to disable buttons while still showing them - something which was easy to do in Classic UI. Is there any way of doing so in Freedom UI? I can't see any examples in OOTB Freedom UI areas, anywhere that does have disabled buttons OOTB are in Classic UI sections (e.g. the "Finish session" button on the System User page on the Access Rules tab when no record is selected).

Like 0

Like

4 comments
Best reply

Classic UI buttons have a property 'enabled'
Freedom UI buttons have a property 'disabled'

Hi Harvey, 

Does it not work to bind an attribute to the enabled property of a button and set as true/false? I've not tried that, but I assume it would work? Have you already tried that?

Ryan

Classic UI buttons have a property 'enabled'
Freedom UI buttons have a property 'disabled'

Huh, not sure how I missed that, could've sworn I tried doing that! Thanks both.

As a note, the only way I could find to put some kind of hint/tooltip on the button when it's disabled is by using the "title" property, which gives you a standard browser tooltip display when hovering the mouse over the button. And binding that to an attribute that you change to be blank when the button is enabled.

Show all comments

Is it possible to set the value of a System setting which has the "Save value for current user" setting enabled for a specified user from C# code, e.g. from a script task? I've found the below code for setting a System setting, but presume that if the checkbox for the above is selected, then it will only set the value for the current user (or the System User if running in the system context):

var settingCode = Get<string>("UsrSystemSettingCode");
var value = Get<string>("UsrSettingValue");
Terrasoft.Core.Configuration.SysSettings.SetValue(UserConnection, settingCode, value);
return true;

 

We need to be able to set the per-user system setting for a specific user (determined by data in the BP in our case) but looking at the (always hard to find) API documentation, it doesn't seem like there's an overloaded version of SetValue that allows you to do so as a specified user - except possibly one that is marked as being deprecated in a much older version:

 

Like 0

Like

2 comments

Anybody have any info on this?

Does anyone have any other methods for managing per-user system settings in Creatio? It seems like there aren't a lot of options besides setting them in JS code when a user does a given action, but then that feels like it defeats some of the purpose of system settings being that the value doesn't have to be calculated every time a user does something, and also means it can't reliably be used for tasks like setting a default field value on an entity.

Show all comments

Is it possible to create an entity based on a view (so with the "Represents Structure of Database View" checkbox checked, and with the view created using a SQL script) that inherits its record permissions from a "real" entity? I tried to do so by simply checking the record permissions checkbox and specifying the parent object in the "Object to inherit access permissions from" field of the entity, but this doesn't seem to work.

 

My setup is that we have the OOTB Leads entity, and then I've created a view over the top of it taking all columns but with a filter condition, to be used for reporting over Leads while filtering out certain Leads that should never be included in reporting so we have a more consistent reporting basis and don't have to make sure to include those filters in every widget. I added 2 columns to the view based on the Id and LeadName columns called UsrBaseLeadId and UsrBaseLeadName, which then have a lookup column UsrBaseLead added over them in the view-based entity. This lookup is then used as the "Object to inherit access permissions from" for the view-based entity.

 

There aren't any errors thrown in the logs when trying to do this, but non-super-users just can't see any of the records. When I tried to check a record in the view's permissions, I could see that the SysRights table for the view entity doesn't exist, so I tried creating that rights "table" as a view in the database that took its data from the Rights Table of the real entity, but while that seemed to work inasmuch as I could check a record's access rights and see that the correct rights were there and was even able to modify those rights, it didn't make it visible to a non-super-user.

Like 0

Like

3 comments
Best reply

It would be great to have the view be able to inherit permissions from some object that the view has as a lookup column. However, I don't believe that is possible. What I typically do is this:

  1. Create a view and include as a column some other object that has permissions (for example, if the view includes an Opportunity lookup column and the account has permissions)
  2. Anywhere the view is used, include a filter condition that some column on that related object is not null (that would never be null). Plus it cannot be the Id or the column used as the display value. Example, if my view has a lookup for Opportunity, I could use Opportunity.Stage is filled in.
  3. Using this approach, the user will only see the rows corresponding to the related record that they have access to, since if they cannot view the related opp the Stage will return a null value. 

It's not ideal and definitely not secure, but it does limit the view rows to what the user can see on the related object.

Ryan

Anybody have any experience of working with such a setup?

It would be great to have the view be able to inherit permissions from some object that the view has as a lookup column. However, I don't believe that is possible. What I typically do is this:

  1. Create a view and include as a column some other object that has permissions (for example, if the view includes an Opportunity lookup column and the account has permissions)
  2. Anywhere the view is used, include a filter condition that some column on that related object is not null (that would never be null). Plus it cannot be the Id or the column used as the display value. Example, if my view has a lookup for Opportunity, I could use Opportunity.Stage is filled in.
  3. Using this approach, the user will only see the rows corresponding to the related record that they have access to, since if they cannot view the related opp the Stage will return a null value. 

It's not ideal and definitely not secure, but it does limit the view rows to what the user can see on the related object.

Ryan

Yeah that's a clever workaround, many thanks Ryan! Agreed about the security aspect, but for the the cases where it's just about having those record permissions used to define non-security visibility as I currently have for the base entity it will work for now.

 

It would definitely be good for the view entities to be able to inherit permissions from lookup columns though, and feels like it would be a relatively quick win for Creatio to add, as most of the functionality around that would already exist. It could even be done in a no-code way by enabling the creation of these view-based entities directly in the config, effectively adding a logical layer to the platform which would be great for filtered views into the data and adding virtual calculated fields. A man can dream.

Show all comments

Hello everyone!

The issue i'm facing is that tasks synced from Google Calendar that are meetings and include Google Meet links are not displaying a "Join" button within Creatio. This makes it difficult for users to easily join these meetings directly from Creatio.

Here's how it should look like:

but this is how it is currently looking like:

this meeting already has a google meet link attached to it, as you can see in the next screenshot:

 

Here are some additional details about the issue:

  • -The tasks in question are synced from Google Calendar.
  • -The tasks are identified as meetings within Google Calendar and have associated Google Meet links.
  • -Despite being meetings with links, there is no "Join" button available within the task view in Creatio.
     

I would appreciate if anyone has faced this issue in the past, and how to solve it :)

Thanks in advance!

 

Like 0

Like

2 comments

Hello Mirla,

 
Thank you for reaching out. We've thoroughly examined your issue. Unfortunately, there is currently no automatic addition of a meeting button for Google Meets sync activity.   

Let me explain the logic of this functionality in more detail. When you add a meeting link to the activity “notes” field with a meeting link, this button is automatically displayed. 

 



As a workaround, when you create an appointment in Google Calendar, you can add a link to the description in the meeting details. And in this case, during synchronization, this data will automatically be transferred to the "Notes" field in Creatio and the Join button will appear automatically.

   chrome_Xp60WiFJb2.gif


Additionally, we offer a connector on the Creatio Marketplace that may address your business needs: https://marketplace.creatio.com/app/google-meet-connector-creatio .

However, we understand that this solution may not be ideal for you. Rest assured, we have already registered an idea for the development department to create this functionality.

Thanks for making Creatio better! 

Halyna Parkhomenko,

I see! thank you for the workaround and all the info! 

Show all comments

Is it possible to specify the default values that will be populated in fields on new records created via the "Quick add menu" in Creatio, similar to how you can do when adding a record from a button on a page:

 

I have seen that if you have multiple pages set up for an entity that the Quick add menu will create a sub-menu for each of the types which will mean that if you click on the specific sub-menu then that field will be defaulted to the value it should be, but we require that other fields are also defaulted to specific values depending on the type selected. Therefore blanket values being set as the default value on the entity won't satisfy the requirement, and the business rules are very limited around setting default values.

 

I can't see anything of much use in the "Quick add records menu" lookup used to configure the quick add menu.

Like 0

Like

0 comments
Show all comments

Is it possible to pass attributes from a page into a validator as a parameter for use in its logic? I'm trying to pass the Id of the record into an async validator which should then query the database for the record to check whether it is in a valid state to be saved, but I don't seem to be able to pass the attribute in as a parameter and it isn't available by default in the validator. I've tried the below:

					"LookupAttribute_sttlz00": {
						"modelConfig": {
							"path": "PDS.QualifyStatus"
						},
						"validators": {
							"LeadSoldValidator": {
								"type": "Usr.LeadSoldValidator",
								"params": {
									"leadId": "$Id"
								}
							}
						},
					},

But it just passes in the literal string "$Id" instead of the value of Id. I don't see anything about passing dynamic values into validators in the documentation.

Like 0

Like

0 comments
Show all comments

Hello,

I have been asked to help with an environment built within the default package of "Custom."

It seems that the previous user did not create a new prefix or package to build out their new objects and fields but rather kept the default prefix of "Usr" and package of, "Custom."

 

As far as I know, they have kept all newly added elements in the environment without external factors for additional dependent packages.

I have attempted to transfer the elements in the configuration section and have accomplished that, but of course, I will run into compilation errors and dependency issues.

My end goal is to upload this project environment to the marketplace safely. So my question is this:

How can I safely transfer the elements of the default "Custom" Package to a new package that can ultimately be exported for the marketplace?

Thank you in advance for any help someone can provide.

Like 2

Like

1 comments

Hello,
 

By default, the "Custom" package is the highest in the package hierarchy and depends on all packages below it. If you want to transfer all schemas from the Custom package to another package, you need to make sure that the new package has dependencies on the required packages.
If the new package has the necessary dependencies, you will be able to successfully transfer the schemas and avoid compilation errors.
The problem is that such a package will likely have many dependencies on other packages (depending on which type of Creatio product it was developed on (for example, Studio has fewer packages, so there will be less dependencies on packages that may not be present in other Creatio environments)). If you want to publish this as an app on the Creatio Marketplace, we recommend following the guidelines described in the Creatio Academy article.
 

Thank you.

Show all comments

Hello!

I am experiencing an issue regarding the synchronization between Creatio and Google Calendar. My Creatio Version: 8.1.1.3635

 

I have set up the synchronization between the two platforms, but I am encountering the following problem:

  • Changes made to activities in Creatio are not reflected in Google Calendar. Neither the other way around.

 

I have already tried the following troubleshooting steps:

Despite these efforts, the issue persists.

I would be grateful if you could provide any guidance or solutions to resolve this synchronization problem. Please let me know if you require any further information from me :)



Thanks!

Like 2

Like

2 comments

Hello,

 

We see that you also registered a case directly for our Support team regarding this problem and therefore we will work on it in that case.

Mira Dmitruk,

wonderful, thanks!

Show all comments