Making certain columns of Configurable List widget required if other columns are populated

  • Profile Image
    Enstrom
    Asked on November 02, 2021 at 06:35 PM

    I have some Configurable List widgets in my form, and I would like to put some conditions on them that require certain fields to be populated if certain other fields are populated. For instance, in the widget displayed below, if the applicant puts something in the First and Last Name column, then the Age and Relationship columns also need to be populated. But if there is no name in the First and Last Name column, then the other columns can be blank as well. Is this possible?

    1635892355_6181bc8392eaf_

  • Profile Image
    Sonnyfer
    Answered on November 02, 2021 at 10:20 PM

    Hi there - Thanks for reaching out.

    Unfortunately, it isn't possible to conditionally require a column in the Configurable List widget. You may consider using a multi-type column in Input Table instead.

    1635905954_6181f1a249927_

    Complete Guide: Input-tables-new-type-multi-type-columns/

  • Profile Image
    Enstrom
    Answered on November 03, 2021 at 11:02 AM

    Unfortunately, that will not work for me because the user needs to be able to add rows as necessary. So a parent might have no other children, in which case the grid can be left completely blank, or a parent might have ten other children, in which case the parent needs to complete ten rows of information.

    I'm guessing there is not a way to accomplish what I am trying to do in that case. Thanks, anyway!

    Marilyn

  • Profile Image
    gerardw
    Answered on November 03, 2021 at 01:48 PM

    There is another workaround though by using multiple short text fields, aligning them side by side and then you can use conditions to require certain fields based on the value on another short text field.

    You can also let the user control the number of entries they require to add, but in that case, you need to add a number of short text fields on the form and conditionally show them as the user requires.

  • Profile Image
    Enstrom
    Answered on November 10, 2021 at 06:33 PM

    Gerard,

    I would like to try your workaround. Can you elaborate on how I would do what you suggest (add a number of short text fields on the form and conditionally show them as the user requires)?

    Thanks,

    Marilyn

  • Profile Image
    Sonnyfer
    Answered on November 10, 2021 at 08:23 PM

    Hello Maryln - You can add Short Text fields like these. Shrinking them will make them display on your form side by side. If your maximum number of guest is say 5, then you would need 5 pairs of the below Short Text fields.

    1636593554_618c6f92e1d9e_

    Next, create a dropdown to ask your users the number of guests to be added.

    1636593704_618c7028cc4f9_

    Finally, create a condition to show the Short Text fields based on the number of guests selected. Example:

    1636593792_618c70804f60e_

    Give it a try and let us know if you need further assistance.