Calculate between two given fields (distance for km registration)

[scdzaak]

Is their a way to calculate between two given fields with km (car tracking) information.

I mean:

Field one: The start of the Km clock in your car.
Field two: The km given after custom visit when you arrived at the office again.

Field1 = 23456 ( km)
Field2 = 23512 ( km)
Field3 = The result from 2 minus 1

Regards,

Eric

[yuri]

No such ability.

[scdzaak]

If I want to make an extra source code change for the question above.
In which file I can do that the best .. ( Json code - php or combination )
Of course the updates of espocrm will not 'see' this so you have pay attention for that !

[yuri]

json, php, javascript
Create your php in custom

[buratz]

Scdzaak did you find a solution for this? I have a similar requirement and am looking for some guidance.

[yuri]

Create custom/Espo/Custom/Repositories/{EntityName}.php

<?php
namespace Espo\Custom\Repositories;

use Espo\ORM\Entity;

class YourEntityName extends (extend from existing repository of your entity)
{
     protected function beforeSave(Entity $entity)
     {
          parent::beforeSave($entity);
          $distance = .....;
          $entity->set('yourNewFieldForDistance', $distance);
     }

}

[scdzaak]

Many thanks I have to find out how to place the code in the running application ..

[espcrm]

Wow this is an old thread. Not sure what 2015 was like, but this Field2-Field1 is easily accomplish with Formula now-a-day isn't it? Or you want this to be Live and always active.