Trailhead Challenges | Salesforce Trailblazer Community

2013년 11월 7일 오후 7:58

Capitalize First letter of text in a field

Hi All,

Is it possible to capitalize the first letter in a field? The field is First Name. I don't want to enforce this, but rather upon tabbing off the field, capitalize the first letter. Similar to the Phone # fields, which automatically format.

Possible? Thanks!

답변 25개

Deepak K Anand (‎‎‎‎‎‎Zoom)
2013년 11월 7일 오후 8:20
Hey Steve,

With the assumption that you have Workflow Rules on your edition(with ref. to old questions), here you go:

Setup | Create | Workflows & Approvals | Workflow Rules.
New Rule.
Select the Object.
Evaluation Criteria : created and every time it's edited.
Rule Criteria : formula evaluates to true.
Formula :
AND(

    NOT(ISBLANK( FirstName )),

    OR(

        ISNEW(),

        ISCHANGED( FirstName )

    ),

    LEFT( FirstName , 1) <> UPPER(LEFT( FirstName , 1))

)
Save & Next.
From under Immediate Workflow Actions , click Add Workflow Action to select Field Update.
Select the Field to Update : FirstName.
Select User a Formula to Set the new Value.
Click Show Formula Editor.
Formula :
UPPER(LEFT( FirstName , 1)) &

MID( FirstName , 2, LEN( FirstName ))
Save
Done
Activate
Best,

Deepak

답변을 작성하세요...

0/9000

3월 5일 오전 1:08

Add and Map a Formula Field Is Used Based

I am on this challenge and unable to move forward. I have corrected mapped the formula field Is US Based to the corresponding in Lead but it somehow doesn't save the mapping. Attached is the screen recording.

https://trailhead.salesforce.com/content/learn/projects/create-a-data-stream-in-data-cloud/add-and-map-a-formula-field?trail_id=unlock-your-data-with-data-cloud

#Trailhead Challenges

Recording_Video.mp4

답변을 작성하세요...

0/9000

2월 28일 오전 12:04

Field 'Region__c' does not exist

I create the Region/Zone field but when I enter the formula, it says it doesn't exist. What do I do?

#Trailhead Challenges

답변을 작성하세요...

0/9000

3월 4일 오후 6:23

Work with Salesforce Records in Flows training - Hands-on Challenge - bullet 3

Hello, I'm working on Flows Training - Hands-on Challenge - bullet 3 (Add an Update Records element....) In my Playground - Flow Builder - , there is no such field as "Id", as per the instruction. Add an Update Records element....

Filter Account Records:
- Field: Id
- Operator: Equals
- Value: accountID

답변 1개

Mykhailo Vdovychenko (IBVCLOUD OÜ)
3월 4일 오후 9:33
Hi, @Ellen Venkitaswaran

1. Create an Autolaunched Flow2. Click toolbox icon and create New Resource:
3. Create a resource:

Resource Type: Variable
API Name: accountID
Data Type: Text
Available for input: checked
Resource Type: Formula
API Name: WeekFromToday
Data Type: Date
Formula: TODAY() + 7
Final view of your Resources list:
4. Add an Update Records element:
click on the "+" icon in your flow palette and select Update Records:

Label: Set Type to Customer
API Name: Set_Type_to_Customer
How to Find Records to Update and Set Their Values: Specify conditions to identify records, and set fields individually
Object: Account
Filter Account Records:
Field: Id
Operator: Equals
Value: accountID
Set Field Values (remove any fields not mentioned here):
Field: Type
Value: Customer - Direct

Sincerely,
Mykhailo Vdovychenko
Bringing Cloud Excellence with IBVCLOUD OÜ

답변을 작성하세요...

0/9000

3월 3일 오후 10:48

Validation Rule for Implement Best Practices

I can't figure out the hands-on task for trailhead Implement Best Practices. "Determine the formula that requires either the email or phone field to be populated when a lead is created or when it is edited and either the email or phone field has been changed. Hint: use the ISNEW, ISCHANGED, and ISBLANK functions." and( OR( ISNEW(), ISCHANGED(Email) ), ISNEW(), ISCHANGED(Phone) )

returns challenge check error "We were able to create a new lead without an Email or Phone populated."

답변 1개

Eric Burté (DEVOTEAM) Forum Ambassador
3월 3일 오후 11:32
Hello @Erin Granados
have a look at similar threads
https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007LUUazSAH

https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007ZC4jkSAD

Eric

답변을 작성하세요...

0/9000

2024년 3월 4일 오후 12:35

I am getting this message error, "We can't find the expected formula on the Commission field from the Opportunity object." But I have checked all my formulas and name field and fiels label and cannot see anything wrong with it.

#Trailhead Challenges

formula 1.PNG

formula 2.PNG

NAME FORMULAS.PNG

답변 13개

Antoni Morali (OfficialApkSites)
2024년 3월 11일 오전 10:32
Thank you for reaching out. I apologize for any inconvenience regarding the access issue. I'll ensure to look into it promptly. Rest assured, I'll utilize the provided system admin access to investigate the matter further. Should I require any additional information, I'll be sure to reach out to you. Thanks again for your cooperation and patience.

Best regards,

답변을 작성하세요...

0/9000

2020년 3월 8일 오후 8:28

trailhead formula

Under: Advanced Formulas (Badge)

Level Up with Advanced Formulas

YOUR CHALLENGE

Create a formula that shows where an Opportunity is in the pipeline.

Create a formula field that classifies an Opportunity as either “Early”, “Middle”, or “Late”. This formula field should use TODAY() to calculate what percentage of the time between an opportunity’s CreatedDate and CloseDate has passed, and label the opportunity accordingly.

This formula should be on the Opportunity object
This formula should be named 'Opportunity Progress' with the resulting API name Opportunity_Progress__c
This formula should return 'Early' if less than or equal to 25% of an opportunity has passed
This formula should return 'Middle' if between 25% and 75% of an opportunity has passed
This formula should return 'Late' if more than 75% of an opportunity has passed
This formula should reference a helper formula field, also on the Opportunity Object, with the type Percent and the name Percent Completed
Percent Completed should return the percentage of the time that has passed between an opportunity’s CreatedDate and CloseDate

Challenge not yet complete in My Trailhead Playground 5

The 'Opportunity_Progress__c' formula field does not exist or is not of type 'Number'

Helper formula I used for: Percent Completed: “It works!”

((TODAY() - DATEVALUE(CreatedDate))

/((TODAY() - DATEVALUE(CreatedDate)) + ( CloseDate - TODAY())))

Problem they want the formula behind the “Opportunity Progress” field to have a Number as the data type, but it returns TEXT: “Early”, “Middle”, and “Late”.

This formula is the one I changed to, so I could use the data type – Number, but I still get the error message above.

IF(Percent_Completed__c <= 0.25, 1,

IF(Percent_Completed__c >= 0.75, 3,

2) )

I changed the return data type to Text, so it would the return the “Early”, “Middle”, and “Late” that they requested, but I still get the error, which makes some sense, since I don’t have a number being returned?

답변을 작성하세요...

0/9000

2월 26일 오후 9:14

I am trying to build a formula field on the case object that counts the quotes on a related opportunity.

The case is related to an opportunity which has quotes attached. I am struggling to build the formula because you can't use a roll-up on a cases because they are a child object

#Trailhead Challenges

답변 3개

Ajaypreet Singh Saini (Grantbook) Forum Ambassador
2월 26일 오후 10:10
Hey @melissa vaughn, try creating a rollup field on Opportunity first to count the quotes attached to the opportunity.
As you have, in your org relationship of a case to an opportunity, create a formula field on Case to pull this rollup count value of quotes from related opportunity record

답변을 작성하세요...

0/9000

2월 25일 오후 9:20

Erreur de formule

ALL the code:

AND (

AND(

ProductCode__c = "CA-38",

SUM (Amount__c) > 0

)

AND(

ProductCode__c = "AD-Y-11",

ProductCode__c = "AD-Y-12",

ProductCode__c = "AD-Y-13",

ProductCode__c = "AD-Y-14" ,

NOT ( SUM (Amount__c) > 0 )

)

Erreur de formule

Hi team,

Someone to help me.

I want a rule that prevents the sum of specific products from being equal to zero.

#Trailhead Challenges

답변 10개

Mufaddal Ferozporwala (PairClouds Consulting)
2월 26일 오후 9:49
@Ohou Jean-Luc Soboh You'll need to create a Flow to accomplish this, as a formula or validation rule alone can't retrieve specific product records and sum their amounts. In the Flow, use the **Get Records** element to fetch the amounts for multiple products, aggregate them, and check if the total exceeds zero.

답변을 작성하세요...

0/9000

2020년 5월 24일 오전 11:20

The validation rule does not reference the account Shipping Postal Code field (ShippingPostalCode)

Hi, When i am trying to complete my validation for the challenge getting error as :

The validation rule does not reference the account Shipping Postal Code field .

I have created the validation rule on my contact object and using the formulae as AND(

NOT(ISBLANK(AccountID)),

MailingPostalCode != Account.ShippingPostalCode

)

Challenge :

To complete this challenge, add a validation rule which will block the saving of a new or updated contact if the contact is related to an account and has a mailing postal code (which has the API Name MailingPostalCode) different from the account's shipping postal code (which has the API Name ShippingPostalCode).

Name the validation rule Contact must be in Account ZIP Code

A contact with a MailingPostalCode that has an account and does not match the associated Account ShippingPostalCode should return with a validation error and not be saved

The validation rule should ONLY apply to contact records with an associated account. Contact records with no associated parent account can be added with any MailingPostalCode value. (Hint: you can use the ISBLANK function for this check)

답변을 작성하세요...

0/9000

#Trailhead Challenges토론 중인 항목 2,490개

Salesforce 추천 주제

관련 학습