What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Form Calculation widget: Compute a Matrix Field based on the rows setup even with "Shuffle Rows" enabled

    Asked by tiffanymerriman on September 14, 2016 at 08:30 PM

    I have organized the the questions in the matrix in groups of 5.

    Each group of 5 returns results to the proper calculation box below. IE Questions 1-5 answers are tabulated and populate the "Discovery" total. Questions 6-10 are tabulated and populate the "Startup" calculation.

    However, I need to randomize the questions, which won't work properly because the score doesn't follow the question in that case - it just tabulates the question that is occupying the cell. Is there a way to randomize the questions, but code them somehow so the numeric value populates the proper score category?

    Page URL:
    https://www.jotform.com//?formID=62515039100140

    calculations matrix form calculation widget shuffle rows
  • Profile Image
    JotForm Support

    Answered by Jim_R on September 14, 2016 at 11:00 PM

    Hello, I understand what you're trying to do but I'm afraid that's not doable at the moment.

    You are correct - The calculation widget just computes the question that currently occupies the cell in the grid. It won't follow the question if SHUFFLE ROWS is enabled.

    I fiddled around the Matrix field and the Form Calculation widget for quite some time but failed to find a workaround that will fit your requirement.

    As a resolution, I'll be marking your post as a feature request. And although I won't be able to give you any timeframe, rest assured, we'll keep you apprised on this same thread if/when there's an update.

  • Profile Image

    Answered by tiffanymerriman on September 14, 2016 at 11:45 PM
    Thank you so much for trying and posting as a feature request!
    ...
  • Profile Image
    JotForm Support

    Answered by NicholasWestley on September 16, 2016 at 05:02 AM

    Hi,

    this has now been implemented.  The calculations values will follow radio matrix value rows when they are shuffled.

    Please let us know if you have any problems or questions.

    Regards,

    Nciholas