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

  • Profile Image
    Asked 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?

  • Profile Image
    Answered 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 on September 14, 2016 at 11:45 PM
    Thank you so much for trying and posting as a feature request!
  • Profile Image
    Answered on September 16, 2016 at 05:02 AM


    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.