Dear community,

I need to add a lot of custom fields (40 and more fields) to account section

I would prefer to create a custom section (named administration) with all these fields.

The relationship between one account record and the administration data is 1:1.

How can I show the "administration data section" in the account page?

I can link administration section as a detail, but I don't know how can I hide the action add when a record exists in the administration section

Like 0

Like

2 comments

It is better to add this record automaticaly in a Process when new Account is added, so user will be able only to edit it.



And then you can add methods to the detail schema:



 

getDataImportMenuItemVisible: function() {
				return false;
},
getDeleteRecordMenuItem: function() {
				return false;
},
getCopyRecordMenuItem: function() {
				return false;
},
getAddRecordButtonVisible: function(){
				return false;
}

 

thank you very much Vladimir

Show all comments

I've just started getting a 404 error, is there anyone that can help?

I was using the site then just went down.

 

The site is https://rdrive.creatio.com/

Like 0

Like

4 comments

Back up now

Dear Nicola,



If the issue occurs again, please, contact our support team so we can investigate the case.



Thank you.



Best Regards,

Ivanna

Hi

 

How do I contact the support team, please?

Dear Nicola,



Please, send an email to support@creatio.com and describe the issue.



Best Regards,

Ivanna

Show all comments

Hi Community,

 

We are trying to add send email in a case for each stage but after adding the "Record for macros” with the “[#Main record.id#] for one send email and for another stage when we create the same and add it the previous "Record for macros” value also is not available and the present one also.

 

Question : We are creating a case and it has many stages and in each stage we are trying to send email to the owner on the status . So we have added the “Send Email” and provided "Record for macros” with the “[#Main record.id#] and the same was added to the next stage also. but when we reopen the “Send email” the entered value for “"Record for macros” is not saved and while saving the case also it asks us to add it once again though we add and save it. The value doesn’t get saved and it is empty.

Like 0

Like

1 comments

Hello Amritha!

 

Thank you for your question!

 

Please be advised that in order for the Macros to be executed as intended you may try adding a custom Macro to the HTML code of the [ HTML ] element of the Email template. You may find more information on it here: 

https://academy.creatio.com/docs/user/marketing_tools/email_marketing/e…

 

In addition, I would recommend checking if the Macros was set up accordingly to these Academy Articles below:

1. https://academy.creatio.com/docs/user/marketing_tools/email_marketing/e…

2.

https://academy.creatio.com/docs/user/bpm_tools/process_elements_refere…

3.

https://academy.creatio.com/docs/user/bpm_tools/business_process_setup/…

 

In case you would want to add a Macro Handler you may find information on this subject here:

https://academy.creatio.com/docs/developer/front-end_development/creati…

 

Hope this would be useful!

 

Please do not hesitate to contact the Creatio Support team in case you have additional questions!

 

Regards,

Danyil

 

Show all comments

Hi Team,

 

Have a query regarding widget we design in the dashboard can be read filter from the dashboard to modify our output on the widget.

If it is possible please share a scenario with implementation 

This will be really useful to meet some business requirement 

 

Thank You in Advance 

Like 1

Like

4 comments

Hello Braj,

 

Unfortunately, I was not able to find an example you requested but you can always check all the needed parameters in the Academy Article that is related to Dashboard widgets and their customizations.

 

Best regards,

Bogdan S.

Hi Bogdan,

 

we need to calculate the loss ratio from some data sets 

 

ex. we have 100 records out of which 70 has profit field filled and 30 has loss field filled.

Based on filtration we performed on the dashboard/pivot report we get  records (N can be  10,20,30 or any number 

 

Now I want a loss ratio (loss/profit) of those N records only.

 

in this case loss ratio = sum of loss from filtered records /sum of profits from filtered records.

 

Hope you got the requirement if case any query please contact me.

 

Thank You

Braj Raj singh Kushwaha,

 

Your business task is quite clear but still, there is no existing example of code that you can use. Please, check the article that I sent before and do all the required development.

 

Best regards,

Bogdan S.

Bogdan Spasibov,

Thank You so much 

 

your article was very useful It helped me to do some other requirement.

Even fund some app that was free to use and my task was completed using them.

 

Once again thank you so much

Show all comments

Hi Team

 

I need to perform some calculations based on data in the dashboard we did some implementation in the pivot table. we are able to get sum 2 fields based on all filter but further using that calculation to display the ratio of that 2 calculation is where I am stuck.

 

I am using https://academy.creatio.com/documents/technic-sdk/7-16/adding-custom-da…

To come up with some approach but didn't succeed anyone please suggest a solution to this requirement

Any workaround will be appreciated

 

 

Thank You 

 

Like 0

Like

3 comments

Hello Braj,

 

Can you please provide more information on what task do you want to cover? We need some practical examples to think about the solution.

 

Also have you tried to use this marketplace addon and does it fit your business task?

 

Best regards,

Oscar

Hi Oscar ,

 

we need to calculate loss ratio from some data sets 

 

ex. we have 100 records out of which 70 has profit field filled and 30 has loss field filled .

Based on filtration we performed on dashboard/pivot report we gets  records (N can be  10,20,30 or any number 

 

Now I want an loss ratio (loss/profit) of those N records only .

innthis case loss ratio = sum of loss from filtered records /sum of profits from filtered records

 

Hope you got the requirement if case any query please contact.

 

Thank You

Braj Raj singh Kushwaha,

 

Hello,

 

Unfortunately it's not quite clear what task do you want to achieve. Can you please add some screenshots of what is the desired result? Also can you please specify why the formula column type is not an option in our case?

 

Thank you in advance!

 

Best regards,

Oscar

Show all comments

Hi Community,

 

How can I override the Portal Case Page Actions and hide the oob/existing Actions (Cancel Case/Close Case/Reopen Case).

 

 

Like 0

Like

3 comments

Hello Fulgen,

 

Please install this package to the system http://ftp.creatio.com/support/downloads/0968497/Portal_2021-02-23_14.0… and disable the "PortalUserAction" feature in the database by executing this query:

 

update "AdminUnitFeatureState" set "FeatureState" = 0 where "FeatureId" in (select "Id" from "Feature" where "Code" = 'PortalUserAction')

And relogin to the application under the portal user. Once done the "Actions" button will be removed.

 

Best regards,

Oscar

Oscar Dylan,

Hi Oscar,

Is it correct override on PortalCasePage client schema the method  getActions() for hide some action?

getActions: function() {
	var actionMenuItems = this.Ext.create("Terrasoft.BaseViewModelCollection");
    actionMenuItems.addItem(this.getButtonMenuItem({
		"Caption": {"bindTo": "Resources.Strings.CancelCaseActionCaption"},
		"Tag": "cancelCase",
		"Enabled": {"bindTo": "EnableCancelAction"}
	}));
 	actionMenuItems.addItem(this.getButtonMenuItem({
		"Caption": {"bindTo": "Resources.Strings.CloseCaseActionCaption"},
		"Tag": "closeCase",
		"Enabled": {"bindTo": "EnableCancelAction"}
	}));
	actionMenuItems.addItem(this.getButtonMenuItem({
		"Caption": {"bindTo": "Resources.Strings.ReopenCaseActionCaption"},
		"Tag": "reopenCase",
		"Enabled": {"bindTo": "EnableReopenAction"}
	}));
	return actionMenuItems;
}

 

Stefano Bassoli,

 

Hi,

 

Yes, that's correct. You can either copy this code to the replaced PortalCasePage and remove items that should not be present in the page actions (don't declare them) or you can call parent method and then remove items from the items array returned in the collection of the actionMenuItems object.

 

Best regards,

Oscar

Show all comments

Hi Community,

 

We are have given read only option to all the fields in a detail and on certain status change, have written a business rule to edit few fields and the rest of the fields remaining locked. Post another status change, previously editable field is locked and the other fields are editable. 

 

Question : During a creation of the detail in the first status, certain fields are locked and the fields which can be editable are editable but when the status is changed based on the rule it has to lock the fields which was edited previously and remaining fields to be editable but all the fields are locked. until in the new status we try to add a new detail then the business rule works and the field which needs to be edited is editable but not to the already created detail.

Like 0

Like

3 comments

Dear Amritha,

 

For such a task, you may create a business rule for each field and each stage - then when the stage is changed new set of rules will start working. Otherwise, you can add business rules to the source code for each field: https://academy.creatio.com/docs/developer/front-end_development/creati…

 

Best regards,

Angela

Dear Angela,

 

While creating the fields have given only read access to all the fields. Later in the business rule for a stage, where the fields needs to be edited have given editable option via business rule. But there is no option that for other fields to give  uneditable option in business rule, we havent given that instead provided read only option.

 

But still, in the initial stage based on the rule few fields are editable and when the stage changes. When we create a new detail then that stage business rules gets applied but to already created detail the business rule for that stage is not getting applied, that is our concern

 

Amritha Mayan Gorky,

So you mean when detail is moved to another stage old records are still read-only and new records are edible while in fact, all records should be editable? 

Show all comments

Hi,

 

I know there is a way to visualize the database structure (tables and relationships) but I cannot seem to find it.

 

Thank you for your help.

Like 0

Like

10 comments

Dear Frederic,

 

In SSMS you can easily create diagrams showing the relationships between tables. The basic steps are:

  1. Connect to the database server
  2. Expand the Databases folder
  3. Expand the folder for the database you're investigating.
  4. Right click on the Database Diagrams folder.

    a. Select Install Diagram Support if needed

  5. Select New Database Diagram
  6. In the wizard add any tables you're interested in.

Best regards,

Angela

Thank you.

 

There is also a marketplace add-on that will provide a process you can run to generate an Excel file of the table structures in the system (I don't believe it includes views). Just wanted to mention this since it's nice for cloud systems when you don't have a local database: https://marketplace.creatio.com/app/object-structure-export-creatio

Ryan

Ryan Farley,

Thank you very much Ryan. I will try.

Hi, I succesfully instaled the Object Structure Export tool, but when I run it, there is a file download initiated, but I get a error message "Fail - Problem with the server".  I do not see a trace in the process log.  Any idea what is wrong?

Hi Frédéric,

 

We have successfully exported the object structure at CRM Creatio 7.17.1. After the business process starts, click the 'Open DB structure page' link and wait until the XLSX file is generated.

 

 

Please specify your Creatio product and version so that we can try to reproduce the issue.

Hi, It now works perfectly. Thank you. We are using Sales 7.17.2.1728

Hi Angela,

 

Is there a way to create diagrams showing the relationships between tables with PgAdmin?

 

Best Regards

 

Stefano

Hi Angela,

 

Is there a way to do the same (create diagrams showing the relationships between tables) with PgAdmin?

 

Best Regards

 

Stefano

STEFANO FERRARI,

 

Hello,

 

If pgAdmin documentation doesn't provide this information then this is impossible. On the other hand DBeaver states that it's possible to view such diagrams (see https://dbeaver.com/docs/dbeaver/Database-Structure-Diagrams/). You can try using it as well.

Show all comments

Dear team

I installed multichoice field addin and It works fine

How can export the data save in the way?

Like 0

Like

4 comments

Dear Stephane,

 

It depends on the column you have added as a multi-choice field. It can be exported from lookups or from the detail itself if this is a detail. 

 

Best regards,

Angela

Angela Reyes,

Thank you Angela.

 

The contact type field is available in the contact section, but I need to assign one or more contact types to a contact.

I installed the multiple choice fields add-on e. I created a many to many related entity with contact entity and contact type lookup, everything works fine.

The question Is it possible to export the contact types assigned from the contact section for each contact?

Stefano Bassoli,

If the detail was not registered we recommend installing the app https://marketplace.creatio.com/app/excel-reports-builder-creatio. You can use it to set up a report for the object where information is stored in many to many related entity.

 

Best regards,

Angela

Thank you Angela!

Show all comments

I need to show a detail inside a section page with a "treeview-like" (or hierarchic)  list.

I don't need to show a a "parent-child" relationship but I need to show a "group-by" view.

My real case need is that I need to show the Contacts detail inside the Opportunity (I guess it's the OpportunityContactDetailV2 client module) grouped by Role: I would like to see all the contacts with the same role as children of the Role.

The detail should report the different roles and when the user expands a role with the "plus icon", the page must show the contacts with that role.

How can it be done?

Thank you

Like 0

Like

4 comments

Perhaps this marketplace add-on would provide the functionality you're after? It allows you to define a detail and then have it group by a column, providing an hierarchical view of the rows. https://marketplace.creatio.com/app/hierarchy-list-view-creatio

Ryan

Ryan Farley,

Thanks Ryan

I tried the add-on but it raises some javascript run-time errors and doesn't allow me to select the column to group by.

By the way, I'm interesterd on doing it with JS code in a section page detail creating: I need to know how to implement it.

Thanks

Massimiliano

I tried following the instructions dounf on this post https://community.creatio.com/articles/displaying-detail-data-hierarchi…

but it doesn't work: any suggestions?

Dear Massimiliano Mazzacurati,



The answer will be published in this Creatio Community post.



Best regards,

Bogdan

Show all comments