Form keeps crashing when making calculations using Matrix Dynamique.

  • Profile Image
    bomboniere
    Asked on September 05, 2016 at 11:54 PM
    the second is that I also found a workaround that worked great on a test form to make calculation using the matrix dynamique, and I used it to build a form, spent countless hours on it but it would crash and not run.  

    I settled and remade it again without the formulas, though I should not have had to I think.

  • Profile Image
    EltonCris
    Answered on September 06, 2016 at 01:16 AM

    The calculation you made was probably looping or having a conflict that's why it is not working.

    Example:

    If "Field1" is filled, insert "Field1" to "Field1"

    If you are using the same field on IF statement, on the formula and on the result field, they would most likely loop and might affect the browser performance.

    I suggest to please review your calculation and as much as possible, use a different field for the output.

    If you need further assistance, do let us know.

  • Profile Image
    bomboniere
    Answered on September 06, 2016 at 01:46 AM
    Yeap I get that, though I think that the example you wrote does not represent a loop unless you misspelled "Field." Anyway that's not quite it. I used substrings of the calculation field and added them. It causes a huge lag, and I actually thought it could possibly do that. But it works really well on my test form, With no lag at all. Hmm I wonder if I added in the opposite direction on the main form, I will check and I will send you some screen shots/ vids tomorrow.
    Thanks for getting back to me, I think with help from you guys It will all work (hopefully anyway)
    ...
  • Profile Image
    EltonCris
    Answered on September 06, 2016 at 02:16 AM

    My apologies for the typo, I've corrected it now. :)

    Anyway, yes, the image and the video would definitely be of help so we can check the problem in depth if you still have not sorted it out.

    We'll look forward to your reply.