AnsweredAssumed Answered

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

Question asked by Punit Desai on Feb 7, 2020
Latest reply on Mar 2, 2020 by Punit Desai

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

Outcomes