Create a Custom Formula Field or Workflow to Calculate field value?

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hi There,

I was wondering if there’s a way to create a custom formula field in a module? For example, I would like to create a field in the quote that calculate commission based on the grand total automatically upon the grand total change.
If it can’t be done via module builder or studio, can this be done by workflow?

Cheers,
Kent

2

Hi there,

What you require is something like Calculated Fields, which is in the paid for versions of SugarCRM but is not in SugarCRM CE/SuiteCRM.

Thanks,

Will.

3

How would one display the total closed sales that a campaign has generated?

4

Hi John,

It may be possible to run a report on Campaign to output that data.

Thanks,

Will.

5

I actually need to display it on the campaign detail view screen. I was able to generate a field populated by a custom function and formula. Is there any way to create an array or object on page load with all the calculated data that I need and use that in my custom functions?