Simple Calculation
I would like to take the values from 2 number input boxes and perform a simple multiplication and return that value in another field. With all of Bartender's capabilities, i think this should be simple but i am just not finding anything - open to suggestions.
-
You would need to make your calculation field a VB Script field and then add in some simple code to achieve this as shown below.
I would also suggest for ease of reference that you "name" the two source fields using this ringed button as you can then call these values simply in your VB
A Multi-line VB script could be used to deploy this but if the data is coming from a database or a data entry form value then making it an Event Controlled Script that performs the action OnNewRecord if they are both databased fields or OnPostPrompt if a Data Entry is used for example, may be a better way to go to make sure that the valid entered data is been used.
0 -
thank you -that was just the thing to help me along my way. Have a great day!
0 -
I tried this solution but I have a problem if number is as a decimal. For example: 0.25 / 0.5 --> gives me always error. Do You have any idea how to fix this to have possibility to count also decimal numbers?
0 -
Not sure why as it works for me okay
0
Please sign in to leave a comment.
Comments
4 comments