Single Status Update
Hi May Music,
I have 20 similar fields on a caspio form, which contain numbers (including decimal fractions). I need to carry out a multiplication and an addition (values for each are different in virtual fields on the same form) and then place the resulting values into an array and sort them according to their numerical value and then they need to be placed back into the original fields from highest to lowest. This process should occur every time the value of these 20 fields is changed. There should also be a trigger for the same action to take place if any of a number of "modifier"fields are altered.
I am afraid that I can not get close to getting this done. While I know VBA, i have no Java background. I would really appreciate any help and I appreciate your time and effort for reading this.