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

  • 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

  • Welvin Support Team Lead
    Replied on July 28, 2015 at 1: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.

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

    Thanks

  • hilltopkennels
    Replied on July 28, 2015 at 5: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

  • jonathan
    Replied on July 28, 2015 at 7: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.

     

  • paulneale
    Replied on October 3, 2015 at 6: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.