Stick with me because I have no coding experience, but I've made up most of my site copying and pasting code from different forums and wix websites. I haven't been able to find a code or solution to this yet and was wondering if someone would be able to write this code for me:
I’m looking for a code which will be set to a dynamic page and will multiply two separate elements from two separate datasets, one of which is inputted by the user and the other is inputted by the site owner.
Users currently input their Weights into 4 different data sets including InputBenchPress, InputBarbellSquat, InputDeadlift, and InputPowerClean. Each a separate weight, displayed as a number (i.e., 300, 400, 500, 600)
On my dynamic page, which includes data collection, SUMMERSWOLE_WK1_UPPER, I offer exercises with the name of the exercise, the amount of sets and reps performed, and the weight. I’ve included the element ‘weight’, titled WEIGHT, which displays a number (i.e., 0.6, .09, 1.1), which is just a percentage of the Input Weights. I’ve also added a secondary dataset to this page titled PowerSETS, which goes into more detail on the sets for certain exercises and includes weights for each set. This includes the element ‘pwrStWt’, titled PwrSt-WT, which should serve the same function as said-'weight' (the power sets are only displayed on certain exercises and are triggered when the user clicks a drop down arrow which is already set up).
The function is that I would like to multiply the users input (i.e., 300) with both the SUMMERSWOLE_WK1_UPPER weight (i.e., 0.6) and then do the same with PowerSETS.
For instance, could I connect the specific InputBenchPress to the workout by using a Reference, then use code to multiply it by the 'weight' for said-exercise and display the solution on the dynamic page (i.e., 300 * 0.6 = 180). The dynamic page displays multiple exercises, each including its own weight.
Here's the real ticker, once I have the solution, I want to round each number up to the nearest multiple of 5. For instance, if the solution is '17.5', I would like to round it up to '20', and '10.125' would round up to '15'.
Would someone be able to take a closer look at this with me and help me write this code, offer any suggestions, etc.? Again, sorry if I'm not great with the coding lingo.
If you would like to contact me directly, my email is email@example.com