Hi guys,
I'm trying to build a custom function in zoho crm to determine the qualification score of my leads.
So I have a number of
picklist fields within the
contacts module:
What do you want to achieve?
How much of a priority is it?
What will happen if you do nothing?
If these fields have a value they will add to the qualification score,
If they do not have a value they won't add to the qualification score.
Different fields will have different scores.
e.g. if "
what do you want to achieve is" has a value its score is 3
But "
how much of a priority is it" only has a score of 1
These scores are then totalled within the funcion to determine the overall "lead qualification score"
My idea was to create a function like this.
If ("What do you want to achieve?" is not empty)
{
goalscore1 = 3
}
else
goalscore1 = 0
If ("How much of a priority is it?" is not empty)
{
goalscore2 = 1
}
else
goalscore2 = 0
If ("What will happen if you do nothing?" is not empty)
{
goalscore3 = 1
}
else
goalscore3 = 0
qualificationscore = goalscore1 + goalscore2 + goalscore 3
Then I take the variable qualificationscore and input its value into a field in the zoho contact record.
I know what I want to do.. I just don't know how to do it! please help!