Calculated fields

[david-strejc]

I've never seen such a great software as yours and I am in business for 12 years!

Great job!

Do you plan adding "calculated" fields? By this I mean having opportunity to have operators between my custom entities - for example I can design that field Cost has operator "+" to Internal Expenses.

Am I clear enough?

[yurikuzn]

Hi David,

Yes. We planned. But have not determined when we will implement it. We have a lot of work to be done in our road map.

If you have any ideas how editor should be designed in UI please share.

[david-strejc]

Do you have Roadmap accessible anywhere online?

So I won't propose any planned features.

[david-strejc]

You can start with absolutely simple design:

Int field will have option to add operator and ability to say which other int field should be operated. (Basically you will than calculate result)

In UI it should be simple:

Int Field1 "Which operator to apply" Int Field2

[yurikuzn]

Roadmap is not available.

[yurikuzn]

Planned it for 2016 Q4.

[eymen-elkum]

Hi @yurikuzn ,
I will work on a new field type named Calculated Field, and it is related to this, I can make it as PR if you want

[yurikuzn]

We already have some code written.

[yurikuzn]

In entity manager it's possible to define formula for specific entity type. This script is executed every time before record is saved.

Examples:

amount = product.listPrice - (product.listPriceConverted * discount / 100.0);
amountCurrency = 'USD';

someField = string\concatenate(firstName, " '", middleName, "' ", lastName);

ifThenElse(
  entity\isNew() && status == 'Planned' && dateStart == null,
  dateStart = datetime\addDays(datetime\now(), 10),
  ifThen(
    status == 'Held' && dateStart == null,
    dateStart = datetime\now()
  )
);

[alasdaircr]

What language is this written in?

This will be an amazing feature. Looking forward to it.

[yurikuzn]

It's a simple language designed specially for this feature.