Sign Up ›
  • Ryan Frazee
  • NEWBIE
  • 25 Points
  • Member since 2016
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 3
    Replies
SOLVED
3 replies

Error: Challenge requirement is not accepted by SalesForce Instance - Formulas & Validations / Using Formula Fields

Problem:  The challenge requires an API name of 'Days_Since_Last_Update__c' but my salesforce instance doesn't allow that name and delivers the following Error:
The custom field name you provided Days_Since_Last_Update__c on object Case can only contain alphanumeric characters, must begin with a letter, cannot end with an underscore or contain two consecutive underscore characters, and must be unique across all Case fields.

So, in effect, my interpretation is the challenge requires something that my salesforce instance doesn't allow, so I don't know how to get around it.  

I am sure the error is mine, but I would really appreciate some guidance on how to resolve.

Notes:
1)  I did mention this in another thread https://developer.salesforce.com/forums/ForumsMain?id=906F0000000BMfxIAG
2)  Here are a few screen shots for reference:
User-added image
User-added image
 
SOLVED
3 replies

Error: Challenge requirement is not accepted by SalesForce Instance - Formulas & Validations / Using Formula Fields

Problem:  The challenge requires an API name of 'Days_Since_Last_Update__c' but my salesforce instance doesn't allow that name and delivers the following Error:
The custom field name you provided Days_Since_Last_Update__c on object Case can only contain alphanumeric characters, must begin with a letter, cannot end with an underscore or contain two consecutive underscore characters, and must be unique across all Case fields.

So, in effect, my interpretation is the challenge requires something that my salesforce instance doesn't allow, so I don't know how to get around it.  

I am sure the error is mine, but I would really appreciate some guidance on how to resolve.

Notes:
1)  I did mention this in another thread https://developer.salesforce.com/forums/ForumsMain?id=906F0000000BMfxIAG
2)  Here are a few screen shots for reference:
User-added image
User-added image
 
74 replies

The formula should return the number of days between the account’s Last Activity Date and today

Trailhead Module 3:  Create a formula field that determines the number of days between today and the last activity date for a case's account.
Your support team has asked for improved visibility on account activity level at the time they’re helping with customer issues. Specifically, when they’re looking at a case, they’d like to see an at-a-glance view of the number of days since the case’s related account was last active. Create the formula using these requirements.The formula should be on the Case object.
The formula should be of return type Number.
The formula should be named 'Days Since Last Update' and have a resulting API Name of 'Days_Since_Last_Update__c'.
The formula should return the number of days between the account’s Last Activity Date and today.

I created the following:

I created a new custom formula field with return type number and called Days Since Last Update.
I created this formula: Account.LastActivityDate - TODAY()

I get this error message:

Challenge not yet complete... here's what's wrong: 
The 'Days_Since_Last_Update__c' formula field did not return the correct number of days between an Account’s Last Activity Date and today

Can you please assist what I did wrong?  I'm not sure if my formula is even correct with the challenge.  Please help!

Thank you.