Hello and thank you for your reply. Forgive me but I am going to ask more questions to understand how to do it.
1). try configuring the form to evaluate the equations only in the onchange events.
How do I do this? It already has the circle filled that says “Eval the equations in the onchange events” It also has the box ticked for “Eval dynamically the equations associated to the calculated fields” so do I untick those?
2). How do I find the fields that are being used but no longer exist? do I need to go through them all individually and figure it out? or is there a tool I can use to help me with that?
3). would merging the different fields change the end result of the equations? and do you mean like physically merge (as in join two fields together)? is there an option for that? or do you mean I should retype the equations in to just one field?
Forgive my ignorance I am genuinely trying my best to understand the form and how to make it function in the best possible way. Your input and advice is genuinely appreciated.