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
Please sign in to leave a comment.