You need to sign in to do that
Don't have an account?
Karthikeyan Chandran
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
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
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
All Answers
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
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