1

I get the following error when trying to write my field update value. How do I fix it?

Error

Error: Formula result is data type (Boolean), incompatible with expected data type (Text).

Formula

NOT(ISNULL(Customer_ID__c)) && NOT(ISBLANK(Customer_Id__c))

Screenshot

Current Field Update Formula

  • What is the field value that you want to display from the formula? – Dave Humm Apr 4 '17 at 10:37
  • 1
    your formula field type is text so you must return a text if your condition matches. – Safiya PV Apr 4 '17 at 10:53
  • I want the phone Number field in INVOICE object to be automatically field when I place an id in Customers ID field which shoud be same as Customer ID in Customers object. – bob Apr 4 '17 at 11:13
  • Why do you want to populate the field? You can have it as a formula field Customer_Lookup_Field__r.Phone_Number_field__c – o-lexi Apr 4 '17 at 15:27
1

here is an example to update contact phone number when you assign the account to a contact.

Step1: create Workflow on contact.Add condition to execute the workflow. if account is not null. enter image description here

step 2: Update contact Phone as Account phone. enter image description here

0

As per Documentation,

Use ISBLANK instead of ISNULL in new formulas. ISBLANK has the same functionality as ISNULL, but also supports text fields. Salesforce will continue to support ISNULL, so you do not need to change any existing formulas.

So instead just use

NOT(ISBLANK(Customer_ID__c))

This should work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.