Is it possible to populate the row and column headings in a matrix field from values entered in another field?

  • Profile Image
    hilltopkennels
    Asked on July 28, 2015 at 10:35 AM

    A user would enter the names of their dogs.

    They would enter the number of kennel runs they need.

    If the number of kennel runs is less than the number of dogs then some dogs need to share.

    If it's possible a matrix field would be shown with 1 row for each kennel and 1 column for each dog.

    They would then click in the matrix field to choose where the dogs are to be located.

     

                         Rufus         Fido          Spot        Beethoven         

    Kennel1             x                               x   

    Kennel2                             x                                  x

     

    How would I do that?

    Many thanks,

    Simon

  • Profile Image
    Welvin
    Answered on July 28, 2015 at 01:24 PM

    Hi Simon,

    You can do that with update a field conditional logic. Here's a guide: 

    https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Caculation-into-a-field-using-a-Condition

    In the output field, you have the option to choose the matrix field. The input boxes are presented in a radio button. It is straightforward, just select what input will be filled when the logic is meet.

    Thanks

  • Profile Image
    hilltopkennels
    Answered on July 28, 2015 at 05:14 PM

    That isn't what I needed, I need to be able to put the use the value entered to define the column heading of the matrix field, not one of the cells below the column heading

  • Profile Image
    jonathan
    Answered on July 28, 2015 at 07:11 PM

    Unfortunately there is no such option or function within the Form Builder that will allow you to dynamically change the Matrix field column/header names.

    It can probably be achieved by using the form's source code, and then inject your own script that will modify the Matrix text column name base on a condition. Please take note that this will require separate programming to come up with the needed function code.

    Thanks.

     

  • Profile Image
    paulneale
    Answered on October 03, 2015 at 06:06 PM

    Is it really possible to set the 'output to field' as a matrix field (as per the screenshot above from jotform support staff  Welvin on July 28, 2015?

    I have tried this using the 'Update a Form Field Value' condition wizard, but I am unable to choose a matrix field to update to.