Hello,



Unfortunately, there is no opportunity to select a few records on the Auto-Generated page. If you need to add a selection of records to the system, you need to specify some filtering conditions by which the Add data element will work.



We have registered your request for our R&D team to include such functionality in one of the upcoming releases. 



Best regards,

Bogdan

Thanks Bogdan, 

If that is the case, I will switch to a multi select lookup detail. Can you please tell me how to filter a multiselect lookup detail?

Dear Shivani,

 

There was a similar question here about the detail filter.

Bogdan,

Thanks Bogdan, I was looking for something different. I need to get the filter id through sandbox

Hello Davey,

If you mean that you would like to create some kind of form validation that prevents from sending the form when there are empty fields, you could add some conditions to the function.

For example you can get the fields from the form by their Id document.getElementById() , and then verify whether their value is null or undefined. If it is, you can just put a return; statement before the createObject(); function, this way the function won't be executed if the conditions are not met.

So it would look somethig like this:

jQuery(document).ready(initLanding);

$( "#gform_15" ).submit(function( event ) {

//get the elements 

document.getElementById()

if(element1 === undefined || element2 === undefined) {

//write something on screen to inform that it needs to be filled

return;

} else {

createObject();

}

}

At the moment we do not have a ready example of this functionality, but you are welcome to try your own implementation and share with us the results.

Best regards,

Dariy

Dariy Pavlyk,

Thank you for the quick comment.



It's not that I need to check the form, but it's more like:

A user doesn't fill in the required fields, but clicks on 'Submit'

Then the default form will give an error: There was a problem with your submission. Please review the fields below.

But the script is triggered already and data goes to Creatio.

So what I need is that the script is triggered when the form is actually being submitted (like a validation).

Example for contact form 7 that works

document.addEventListener( 'wpcf7submit', function( event ) {

    createObject();

}, false );

And I know it's not Creatio, but Gravity forms, so I'll keep searching unless someone has an answer.

And I'll definitely look into your code example too.

Hello Davey,

The example that I provided would solve this issue, as if there is any required field that is not filled, the  createObject(); function will not be triggered.

if(requiredElement1 === undefined || requiredElement2 === undefined) {

return;

-- This return stops the function here, it won't go down 

} else {

createObject();

}

This "return" will stop the function, it won't go further, so the function won't execute the other function called "createObject();". So no request will be sent to Creatio.

Best regards,

Dariy

Dariy Pavlyk,

Thank you Dairy,

I really appreciate it.

 

I'll test it and give some feedback

Davey Daemen,

I hope you got it working.
I have a simple checkRequired JS function I created for this scenario.
 

function checkRequired() {
    var valid = true;
    jQuery('[aria-required="true"]').each(
        function () {
            if ((jQuery(this).is(':invalid') || !jQuery(this).val()) && !jQuery(this).is(':hidden')) {
                console.log(jQuery(this));
                valid = false;
            }
        });
    if (!valid) console.log("error please fill all fields!");
    else console.log('valid');
    return valid;
}

Hello Andrew, 

SessionEndMethod column values:

Not closed - 0

The session was closed as a result of the user logging out. - 1

The session was closed by a timeout on the server side. - 2

The session closed forcibly. - 3

Thank you, 

Igor

Ihor Skohariev,

Thank you Igor!

Hi Shivani,

Thank you for your question!

Regarding the mentioned error in the console, it indicates that the column was either removed from the corresponding object or renamed. We do not recommend deleting any fields, columns or objects as it may lead to unpredictable issues. If some fields are not needed anymore, you can simply change their usage mode to "none". It's hard to identify which column exactly was removed/renamed without accessing the website. Please, contact us at support@creatio.com. We will check the configuration and will try to find out the reason for this issue.

Best regards,

Anastasiia

Anastasiia Lazurenko,

I got the attachment detail working. I noticed if you name the attachment detail as <SectionName>File it works eg : CustomFile for section named Custom, UsrProofFile for section named UsrProof

Shivani Lakshman,

Hi Shivani, I have a quite similar request as yours. I need to customize the default attachment detail of Order page by adding a lookup field into the attachment detail page.

Since the Order's attachment has its own object OrderFile, I created a replacing object of OrderFile and added a new lookup column, say UsrAttachmentType, in the OrderFile object. Then I used this new OrderFile to create a detail through detail wizard and put Name, Description, and UsrAttachmentType columns in the detail page. Then I changed the parent object of the detail with FileDetailV2 and saved the detail.

After the above steps, I could use the new attachment detail to upload files as original attachment detail; but when I double click the attachment record in the detail list, it opened with the old attachment detail page with only Name and Description fields, not the new detail page I setup as above, with additional lookup field UsrAttachmentType.

Please advise what I shuld do? Thank you!

Hi, Mark

You can use a macro for these fields in your printable. For example: ColumnName[#NumberDigit|,#] 

More information at the link: https://academy.creatio.com/docs/developer/application_components/repor…

Unfortunately, there are no basic application tools to add commas between the digits. It can only be done with the help of the development process. In this community thread, you can find the example of such implementation https://community.creatio.com/questions/how-set-comma-separator-money-f….

Hi Shivani,

To filter your lookup you need to add this attribute in the application page :

attributes: {
    "Owner": {
        "dataValueType": Terrasoft.DataValueType.LOOKUP,
        "lookupListConfig": {
            "filters": [function() {
                var filters = Ext.create("Terrasoft.FilterGroup");
                filters.add("WorkInThisCompany", 
                    Terrasoft.createColumnFilterWithParameter(
                        Terrasoft.ComparisonType.EQUAL,
                        "[Workers:Worker].Company.Id",
                        this.get("Company").value
                    )
                );
                return filters;
            }]
        }
    }
}

Replace "Workers" by the object code of the workers detail.

FYI :

here is the filter breakdown :

"[WorkerObjectCode:WorkerFieldCodeInWorkers].CompanyFieldInWorkers.Id"

Watch out that all the codes correspond to your environment, for example, the workers object code can be "UsrWorkers" or whatever you defined it. Check it out in the advanced settings.

Kind regards,

Julien

Julien Gunther,

Thank you for your response. I tried your code but received the error 

Collection item with name [UsrWorkers not found.

 request data: {"rootSchemaName":"Contact","operationType":0,"includeProcessExecutionData":true,"filters":{"items":{"searchFilter":{"items":{"1f59bb71-8f5d-45ed-b4eb...

Looks like the system is trying to reach UsrWorkers from Contact table. This is the case with my requirement. There is no direct relation between the 2 tables. Would appreciate any suggestion!

Here is the code I used

"UsrOwner": {
        "dataValueType": Terrasoft.DataValueType.LOOKUP,
        "lookupListConfig": {
            "filters": [function() {
                var filters = Ext.create("Terrasoft.FilterGroup");
                filters.add("WorkInThisCompany", 
                    Terrasoft.createColumnFilterWithParameter(
                        Terrasoft.ComparisonType.EQUAL,
                        "[UsrWorkers.UsrWorker].UsrAccount.Id",
                        this.get("UsrAccount").value
                    )
                );
                return filters;
            }]
        }

Shivani Lakshman,

Change the filter from "[UsrWorkers.UsrWorker].UsrAccount.Id" to "[UsrWorkers:UsrWorker].UsrAccount.Id"

My bad, I forgot that in reverse join it work using ":", for example :

[EntityCode:FieldCode]

and not [EntityCode.FieldCode]

regards,

Julien

Hi Julien,

Yes, the filter from folders will get appended to the filters you set for the section. You just need to add your filters in a filter group so they are properly applied as a whole, in addition to the folder filters - rather than just add the filters individually to the filters returned from callParent. For example:

getFilters: function() {
    var filters = this.callParent(arguments);
 
    // now create a filter group for your filters
    var customFilters = Ext.create("Terrasoft.FilterGroup");
    customFilters.logicalOperation = Terrasoft.LogicalOperatorType.AND;
    customFilters.add("ActiveFilter", 
        Terrasoft.createColumnFilterWithParameter(
            Terrasoft.ComparisonType.EQUAL, "Active", true
        )
    );
    customFilters.add("NoWidgetFilter", 
        Terrasoft.createColumnFilterWithParameter(
            Terrasoft.ComparisonType.NOT_EQUAL, "Type.Name", "Widget"
        )
    );
 
    // now add your filter group to the filters that get returned
    filters.add(customFilters);
    return filters;
}

It does work without a filter group if you're just adding a single condition, however, in your code you're "OR"ing all your new conditions together with the folder conditions. Using a separate group keeps it all grouped with the same conditions and will work as expected.

Ryan

Thank you Ryan !

When you use a callback with ProcessModuleUtilities, you're responsible for clearing the mask in the callback function.  Add MaskHelper module to the top of the code (like you did with ProcessModuleUtilities) and then call this in the callback function:

MaskHelper.HideBodyMask();

Ryan

Ryan Farley,

Thank you Ryan, I forgot this detail.

Julien

Hello, 



Please contact our support team (support@creatio.com) for further investigation. 



Best regards,

Bogdan

 

Bogdan,

Hello Bogdan,

I allready open several tickets without any solution.

I would like to know if other users of Creatio encounter or have encountered this problem.

I will open a ticket today with the timestamp of the problem.

Thank you,

Nicolas