How to update a Text field with $ or %?

Hi All,

I have a picklist field "Closing Fee Values" with values Amount,Percentage. i just want to display the symbol in prefix($), suffix(%) in the value entered in the text field 'Closing Fee' (Numbers).

Ex:
Closing Fee Values - Amount
Closing Fee - 100

After saving the record field 'Closing Fee' value should display '$100'

Can this possible?

Thanks & Regards,
Karthikeyan Chandran

August 12, 2015
·
Like
0
·
Follow
1

Best Answer chosen by Karthikeyan Chandran

Karthikeyan Chandran
Hi william,

My appologise that i haven't replied back to you on this conversation,the issue got resolved by Deepak and i got answer from success community.

Here the solution -
Workflow Rule specs -

Evaluation Criteria: created and every time it's edited [2ND OPTION]
Rule Criteria: formula evaluates to true
Formula:
AND( OR( ISNEW(), ISCHANGED(Closing_Fee__c), ISCHANGED(Closing_Fee_Values__c) ), NOT(ISBLANK(Closing_Fee__c)), NOT(ISBLANK(TEXT(Closing_Fee_Values__c))) )

Field Update specs -

Formula:
IF( TEXT(Closing_Fee_Values__c) = "Amount", "$" + SUBSTITUTE( SUBSTITUTE( Closing_Fee__c, "$", "" ), "%", "" ), SUBSTITUTE( SUBSTITUTE( Closing_Fee__c, "$", "" ), "%", "" ) + "%" )

URL - https://success.salesforce.com/answers?id=90630000000wkgyAAA

Thanks & Regards,
Karthikeyan Chandran

September 30, 2015
·
Like
0
·
Dislike
0

William Tran
Are you referring to out of the box layout or VF page?

I have a picklist field "Closing Fee Values" with values Amount,Percentage? what does this mean = $100% or $100, 50% or ?

Ex:
Closing Fee Values - Amount
Closing Fee - 100

I don't under this example

thx

August 12, 2015
·
Like
0
·
Dislike
0

Browse by Topic

Welcome to Support!

Show

sorted by

How to update a Text field with $ or %?

All Answers

You need to sign in to do that.