+ Start a Discussion

add values on textfield



iam new to salesforce and i need help to add some values , which should be retrived from 3 textfields and it should be displayed in another text field.


for E.g.,


i have 3 text field


1. X-ray fees

2. E.C.G fees

3.Indoor Injection fees


I) i have to retive the values from these textboxes 

II) add these values 

III) display the added values in another txt box (Say) Total Fees


and i don't have idea how to implement this one using formulas..

Jeff MayJeff May

In a custom formula field, you can add 3 strings together, or you can add numbers and display them as strings.  Use the Advance Formula Editor to see all the available fields, and formula functions available.


To combine 3 number fields into 1 total, (replace your field names in the example below)


XRay__c + ECG__c + IIndoor

JeffM is right if you want to show them in a formula field which is read-only to the user,
And I see you are looking to put it in a text field, so I'll add to jeffM's comments with the following.

1. Have that formula field ready and
2. Create a workflow rule to update "Total Fees" when ever they are changed.
3. activate the workflow.

Janet GuoJanet Guo

I agree with both JeffM and prabha. Just have a few more comments to add.


If you want your "Total Fees" field to be editable and therefore chose prabha's suggestion, you don't actually need a formula field to add the values together before copying it the result with a workflow into the "Total Fees" text field (that's what I understood from prabha's comment, apologies if I misunderstood). You can use your workflow rule's field update to directly calculate a value from the 3 fields and put it into the "Total Fees" field. 


Also, you can use the "ISCHANGED()" function in your workflow rule. It's a very handy function.


So, something like this in your workflow rule:



Then just add a field update to it that adds the 3 field values together.