I am importing data through Excel into my custom section and attempting to auto-calculate a field based on two other fields in the UI. However, since the user won't be opening the form page, the business rules and JavaScript code I've written aren't being triggered .
I also wrote an" Oninserting" entity event layer code, the same is not getting triggered as well,however the entity event layer code is getting triggered on click of the new button. How do i approach this?
Please describe in more detail what code you wrote (if possible, provide an example), what it is for, and how it's connected to business rule and import.
We need to import lookup values in more than a language from an Excel file.
We have an Excel with two columns: Name (italian) and Name (english).
When we import from Excel the Name column goes into the "current language" lookup name but we want to import the names in two different languages (both active in Creatio) without duplicating them.
You need to import values into two different objects. Let's take [Lookup] for example.
When you import the values for the English culture, you can import directly into [ObjectName] (Lookup in our case) and can only have two columns: Id of the record and the actual Value.
When you import the values for Italian Culture you need to import into Sys[ObjectName]Lcz ( SysLookupLcz in our case) and you need 3 columns: Id of the record - mapped to RecordId, CultureId and the Actual Value.
So the idea is if I import a contact with name Dean, the existing contact with the name Dean will be updated with data from file and no duplicates will be created.
