You need to sign in to do that
Don't have an account?
Real time calculation of field value based in visual force page
Hi,
I have a requirement where in I have table with 6 fields. The first 5 fields are picklist and sixth one is Number field.
Now ,the user can select any values from each of the picklists and based on the selection of values from the picklist , I will need to perform some numeric calculation and display the numerica value in the 6th field on the fly.
Currently my sixth field is a formula field , but the issue is , that formula field calculates and displays only after clicking on the save; Whereas my requirement is that the user can see the change in the value of the 6th field on the fly as and when the user selects or changes the value in any of the first 5 fields.
Please help!
Hi,
Instead of using the 6th field as formula field, you can maybe try the following:
- you can use actionsupport component on each of the 5 fields.
- create a method in the controller to calculate the value of the 6th field depending on the values of the picklist and return the value in the 6th field.
Can you please share a sample code , as this would be really helpful for me as I am new to SF. Thanks!
Thank you! Can you please share a sample code which uses javascript?
VF -----------------------
<!-- individual fields -->
<apex:inputField id="fld1_id" value="{!fld1}" >
<apex:actionSupport event="onchange" action="{!calculateFinalValue}" rerender="totalvalue_id"/>
</apex:inputField>
<apex:inputField id="fld2_id" value="{!fld2}" >
<apex:actionSupport event="onchange" action="{!calculateFinalValue}" rerender="totalvalue_id"/>
</apex:inputField>
<apex:inputField id="fld3_id" value="{!fld3}" >
<apex:actionSupport event="onchange" action="{!calculateFinalValue}" rerender="totalvalue_id"/>
</apex:inputField>
<!-- final value -->
<apex:outputText id="totalvalue_id" value="{!totalvalue}" />
Apex -------------------
Code a method calculateFinalValue to populate the final value in the totalvalue field
Hi,
I tried but this does not work.
Can you please provide the complete sample code as I am newbie. Thanks!
http://sriramrajesh58.blogspot.in/2014/11/sample-calculator-using-salesforce-site.html.