You need to sign in to do that
Don't have an account?
Shephali Swarnkar
how to count description field in contact object
Hi All,
I actually want to use count() on description object so that i can count the number of records in description field of contact object but its not working as it does not support for long text area data type.so i tried it using "Field Updates" in workflow rule.
I have a custom field Notes__c(Data type:text area)
formula given is: LEFT (Description, FIND(" ", Description))
but it is not working.Please help so that i can count on description field.
Thanks
I actually want to use count() on description object so that i can count the number of records in description field of contact object but its not working as it does not support for long text area data type.so i tried it using "Field Updates" in workflow rule.
I have a custom field Notes__c(Data type:text area)
formula given is: LEFT (Description, FIND(" ", Description))
but it is not working.Please help so that i can count on description field.
Thanks
Thanks
Thanks for reply.
Actually i want to count the number of records in description field(my actual requirement). but somehow Count() is not supporting for "long text Area" data type. Thats why m looking for another way to achieve it.
here i want to filter it for null records also
list<contact> desc=[select Description from contact where owner.name='ABC' and description!='NULL'];
here too m geeting error:
Compile Error: field 'description' can not be filtered in query call at line 17...
Question:how to count the number of records for perticular user where description field should not be 'NULL'