You need to sign in to do that
Don't have an account?
Mrithula
add values on textfield
hi,
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..
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
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.
HTH
Prabhan
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.