Good day,

This can be done by making a formula to count days between "today" and your filed "A" with a function .Days.

It should look something like the following:

([#Date value.5/31/2023#]-[#System variable.Current Date#]).Days

I will also will leave some community questions on the matter:

https://community.creatio.com/questions/auto-calculate-age-based-new-bi…

https://community.creatio.com/questions/need-use-caluculated-field-valu…

Cheers.

Artem,

I have Created A process but data is not reflecting as i want.

Screenshot of Process and records are attached 

This is my SubProcess

This is my Main Process

This is the list of Records





Here Course C is the field which displays the Days which is not Correct. 

Please Advise

Hey there,

If you are referring to the way the data is represented, it depends on the type of the column (in order to make the value not have zero after it - make the column integer)

If you want to show a checkbox that would be ticked if a certain number is reached and you do not want to use code, keep the column in which you store the number of days, and on the base of it, build a business rule that "if the number of days is reached, then make the box true"



https://academy.creatio.com/docs/user/nocode_platform/freedom_business_…

Thank you

Artem,

 Thanks for your reply.

I want the value in Field should be correct as it is 92 for all records allthough there are some records whose value should be 30 days or 60 days

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/

Hello,

These should be the crt.CreateRecordRequest request and the crt.CreateRecordHandler handler. Try those in either:

1) Page where detail is added

2) Detail schema

3) Edit page of the detail

and it should be triggered.

Oleg Drobina,

Tried these two methods. They don't seem to be called when creating and saving the records in an editable detail.

Abilash,

I tried this handler:

handlers: /**SCHEMA_HANDLERS*/[
			{
				request: "crt.CreateRecordRequest",
				handler: async (request, next) => {
					return next?.handle(request);
				}
			}
		]/**SCHEMA_HANDLERS*/,

on the schema where detail is added and it's successfully triggered:

It also depends on which handler you have specified in the "Add button" properties, you need to find it in the schema diff (in my case it was crt.CreateRecordRequest):

{
				"operation": "insert",
				"name": "GridDetailAddBtn_z5e8jja",
				"values": {
					"type": "crt.Button",
					"caption": "#ResourceString(GridDetailAddBtn_z5e8jja_caption)#",
					"icon": "add-button-icon",
					"iconPosition": "only-icon",
					"color": "default",
					"size": "medium",
					"clicked": {
						"request": "crt.CreateRecordRequest",
						"params": {
							"entityName": "Contact"
						}
					},
					"visible": true,
					"clickMode": "default"
				},
				"parentName": "FlexContainer_n5yrzkv",
				"propertyName": "items",
				"index": 0
			},

Oleg Drobina,

The detail we are working with uses an inline record to create new records which doesn't seem to be calling CreateRecordHandler or CreateRecordRequest. 











 

Hi Abilash,



As I can see on the screenshot, it's not a freedom UI section.

For the freedom UI section, you can use the Expanded list element

And you can make it editable:

Bogdan,

When I open the designer for the above page I'm getting this:



 

As you can see, I don't have the option to make it editable.

Abilash,

Is it expanded list element?

Bogdan,

I'm not sure. How do I check that?

Abilash,

Tis is not a expanded list element this is a Attachment Element

To my pleasant surprise, it appeared that that attachments component became editable since 8.0.7. If you upgrade your instance you should be able to make it editable. 

Hello,

This issue has already been resolved in version 8.0.8.

If the error persists in your version, please create a support ticket with support@creatio.com.

As a workaround, you can access the properties of the column through the page designer.

Hello,

In order to add validation to an editable detail you need to override the method save() in the detail page, for example:

define("UsrSchema1051cea3Page", [], function() {
	return {
		entitySchemaName: "UsrTestDetObj",
		attributes: {},
		modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/,
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		businessRules: /**SCHEMA_BUSINESS_RULES*/{}/**SCHEMA_BUSINESS_RULES*/,
		methods: {
			save: function() {
                    if (this.get("UsrName") == "1") {
                        this.callParent(arguments);
                    } else {
                        this.showInformationDialog("UsrName should be 1 ");
                    }
                }
		},
		dataModels: /**SCHEMA_DATA_MODELS*/{}/**SCHEMA_DATA_MODELS*/,
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/
	};
});

Hello, 

Thankyou for your response, 

But I wanted to validate columns in the detail,

I don't open the detail page and so I don't want to validate in the detail page but in the inline record.

please find attached screenshot

Hi,

This example is working on a detail itself.

With it, you cannot save the record unless the condition is met.

Considering the fact that detail fields are virtually generated, this is the best option to add validation.

Hi!

 

You can configure business rules to set a value in a specific field when a condition is met. You can find an example of how to configure it in the manual - https://academy.creatio.com/docs/user/customization_tools/ui_and_busine…

 

Regards,

Anton

Hi Anton Starikov,

Is it possible to use business rules if the value is dynamic? 

For example, when a specific requirement is met I want the field to have the previous value, which was defined by the user.

Thank in Advance.

Best Regards,

Pedro Pinheiro

Hi! Pedro Pinheiro,

 

Unfortunately, you can't do this with the standard settings. Perhaps it can be implemented by custom development.

 

Regards,

Anton

Hi

Anton Starikov,

Do you have any steps that could help us implement this custom logic? 

Thanks in Advance.

Best Regards,

Pedro Pinheiro

Hello,



There is no such option in Freedom UI now. 

We've registered it in our R&D team backlog for consideration and implementation in future application releases.

Thank you for helping us to improve our product. 

Hi Pedro,

Our R&D team has an opened task on this topic, there is a test solution, but it cannot be applied to productions. Once the task is completed we will notify all our customers and partners in the Release Notes for the app. Thank you for helping us in making the application better! 

Hey Oleg,

Any update on this? Is there a way to update a field, or save a record silently without triggering other events/handlers?

Thank you!

Chris

Chris Heyman,

This functionality has not yet been implemented, but we have already received many requests from users, so the R&D team should take this task into development. 

Hi all,

Any news on this?

April 2023 was the original request.

Almost one year in.

Thanks

Luis Tinoco Azevedo,

You can set 

request.preventCardClose = true;

in the "crt.SaveRecordRequest" request. See my post on this thread for more details: https://community.creatio.com/questions/dont-close-page-after-saving

Ryan

Hi!



Unfortunately, such an instruction is currently available only for the old UI