How to add columns of static text in a matrix field?

  • Katherinedils
    Asked on June 22, 2016 at 11:01 AM

    I'm trying to make a matrix with 2 columns of information side by side. For example:

    Column 1:                      Column 2:                                       Check Box

    Medical Plan                    $150.00 per pay period   

     

    I've tried the configurable checklist and matrix widgets, with no success. 

  • Boris
    Replied on June 22, 2016 at 1:54 PM

    If I understand correctly what you are describing, each row of the table will have a different value in both column 1 and columns 2, while you would like for column 3 to be a checkbox. All rows will be created by you to display data, except for the check box column where your users would be selecting the row.

    For example, you would like your table to appear like this:

    Column 1:                      Column 2:                                       Check Box

    1st Medical plan              $150.00 per pay period                    Yes/No
    2nd Medical plan              $110.00 per pay period                    Yes/No
    3rd Medical plan              $120.00 per pay period                    Yes/No
    4th Medical plan              $130.00 per pay period                    Yes/No
    5th Medical plan              $140.00 per pay period                    Yes/No
    6th Medical plan              $150.00 per pay period                    Yes/No

    Unfortunately, we do not have a matrix field that allows for different types of fields in different columns (one column for static text and another for checkbox field), other than Configurable List widget - which is not suitable for your exact requirement.

    May I suggest using a workaround where you would display your data for both column 1 and columns 2 in the same column - the first one. For example, to display your table such as this:

    Column 1:                                                           Check Box

    1st Medical plan ($150.00 per pay period)                    Yes/No
    2nd Medical plan ($110.00 per pay period)                    Yes/No
    3rd Medical plan ($120.00 per pay period)                    Yes/No
    4th Medical plan ($130.00 per pay period)                    Yes/No
    5th Medical plan ($140.00 per pay period)                    Yes/No
    6th Medical plan ($150.00 per pay period)                    Yes/No

    You can do this by using the regular Matrix field, and entering the values for the concatenated first and second columns under "Rows":

    How to add columns of static text in a matrix field? Image 1 Screenshot 20

    Please let us know if this would work to your satisfaction. Thank you.

  • Katherinedils
    Replied on June 22, 2016 at 2:08 PM

    Is there a way to add text next to the radio or check box? I'm trying to get the values chosen into one column went submitted? 

  • Boris
    Replied on June 22, 2016 at 3:35 PM

    I am not sure whether I understand this part correctly:

    > I'm trying to get the values chosen into one column went submitted?

    1. Are you saying that each row / each selected option should go into its own column on your submissions page?

    2. Or would you like to have all of your selected options show concatenated, in a single column?

    I see that you are currently using several Grouped Values Dropdown widgets instead of any matrix field. Each widget, or each form field in general, will always send data that is selected through it to one column of your submissions. One form field per one column on submissions page.

    So if you want to have data in separate columns on your submissions page, you should use separate form fields to collect these responses. And if you want all of the selected options to appear in one column on your submissions page, you would instead need to use only one form field that allows multiple selections to be made - such as the Matrix field, or a regular Check Box field.

    If you let us know a little more on exactly how you want your submissions to display and how you would like to present this data to your users, we will be happy to look for and provide you with ways to achieve it. Thank you.