i am using 8.2.2

i am trying to set the value of a number field called Lama Bekerja based on the months inputted in Mulai Bekerja accounting the year aswell, i know that using business rules where you can use set value = formula like so...

now when i open it, it doesn't let me do the calculations

can someone explain a method on how to implement this in creatio 8.2.2?

Like 1

Like

3 comments
Best reply

Hello,

As far as we understand,  you are referring to the fact that the "Mulai Bekerja" field is not available for selection in the formula...MoreLess

Show all comments (2)

Hi All, 

I would like to sum the values of two fields, for example: Field A + Field B = Field C.
How do I configure Field C to perform this calculation?
 

Thanks

Like 0

Like

5 comments

It depends on what exactly you need. If you want to take a value from one field, perform an arithmetic operation with field B, and store th...MoreLess

Show all comments (4)

Hey Community,

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?

Like 0

Like

1 comments

Hello,

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.

Show all comments

In the spirit of minimising code/making more of the config declarative rather than telling the system exactly how it should be doing things step by step, it would be very useful to be able to have calculated fields on entities in Creatio. Currently this needs to be done in business processes, which...MoreLess

1 comments

+1

Show all comments

Hi Team,



In the "Order" section there is a multicurrency field 'Total' and the values get auto-calculated/updated when a detail (OrderProduct) record is added/modified/deleted.



As this is a two different tables & modules, a sandbox should be used for the communication. Could you please assist...MoreLess

Like 0

Like

3 comments

Team,



Any insight on this?





Regards,

Bhoobalan Palanivelu.

Show all comments (2)

Im trying to create a calculated field to show a total of all records from a detail on a record, ive looked into using sql views, however I'm not sure if that would work as you cant filter by the record I don't think, are there any code solutions or anything similar?

Like 0

Like

1 comments

Hello,

You can try creating an integer column in the page (and in the object that this page represents) and create a business process that...MoreLess

Show all comments

I'm looking to add a calculated field to a detail on a Section Edit page. I can find plenty of articles describing how calculated fields on section edit pages are implemented, but I'm not able to find any for a detail.

How I'm imagining this working is a trigger from the detail on load to calculate...MoreLess

Like 0

Like

2 comments

Hi Morgan,



Indeed, there are no articles about calculated fields on a detail.



When a detail is created, there are two schemas created: detail...MoreLess

Show all comments (1)

I am following the documentation about adding a calculated field you can find here.

I am following it piece by piece, and am doing everything exactly as it says but every time I try to view the calculated field in the edit orders page it says "Invalid column name UsrBalance". I've logged out and back...MoreLess

Like 0

Like

1 comments

Please check if you have the value of system setting called "Prefix for object name" set as Usr and if it is not - you need to change it to...MoreLess

Show all comments

Hi,

Have two date fields for which I need to calculate the difference in days, i.e. UsrEndDate- UsrStartDate = UsrDayDifference

I have implemented the following code so far:

define("AccountPageV2", [], function() {

return {

entitySchemaName: "Account",

details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/...MoreLess

Like 0

Like

1 comments

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545}
span.Apple-tab-span {white-space:pre}

You can use this...MoreLess

Show all comments