How to create calculated field by using a field from another module.

Hello,

I am trying to implement a calculated field in the Meetings module which has the sole purpose to show a 'Score' i.e. 1,2,3,4 etc... 

The calculation behind this field derives from the number of employees for an organisation in our Accounts module. 

So in more simpler terms;

If an Account has less than 500 employees, then the 'Score' field in the meetings module has to have a value of '1'. If an Account has between 501-1000 employees, then the 'Score' field in the meetings module has to have a value of '2'.

... and so on.

I hope this makes sense and would appreciate some feedback on this. 

Thanks.

Regards,

Punit Desai.

sugar 9.0.2

calculated field

Parents Reply Children