This operation performs Total-Subtraction-Division-Multiplication with the fields in the form.
Mathematical Operations operation at Property Panel
Properties
Description: Description related to action is written
Heading: When added as Form Action, it specifies the name in the action list.
Linked Field: The field to write the result.
Calculate: The calculation is made in this area. (e.g. “ $PValue1$ - $PValue2$ “) ( The +, -, / and * operators can be used.)
Run Condition: If the value in the query entered in this field is “0”, the corresponding action will not run.
Request Confirmation: Select if the request confirmation will be used before running the action. If Request Confirmation is activated, the Confirmation Message feature is turned on and the message that will be displayed when requesting confirmation is written.
Example Used
For example; a few numeric boxes are in a form. Subtraction is desired with these values in the controls.
A button is added in the form and a Mathematical Operations with When clicked event is created for the button. Linked Field contains the control, that the result is written automatically with the operation. The calculation is made in the Calculate area as below.
When the values are entered in the controls and then the button is clicked, the result comes in the control named Subtraction.
Note:
In cases where the + operator is used, it will detect the values you have written in quotation marks as text and will write them side by side. You can delete the quotes of the incoming values so that the addition (+) operation can be performed.
Example Uses:
Values are written in quotation marks.
Client screen shot
Updated the Result field by concatenating the Value 1 and Value 2 fields as strings because the quotation marks were not removed.
Removed quotation marks from values for the same example.
Screenshot of client after removing quotes