Configurable List widget submit data to multiple columns

  • lasercorp
    Asked on January 16, 2020 at 3:55 PM

    Hi,

    I am using this widget for 3 unique fields (quantity, description and part number) and when it submits the data, the format renders the data useless as per my example below


    [{\"Qty\":\"1\",\"Descrip\":\"Separation pad - Tray 1\",\"Part#\":\"RL1-0007-OEM\"},{\"Qty\":\"1\",\"Descrip\":\"Pickup roller - Tray 1\",\"Part#\":\"RL1-0019-OEM\"},{\"Qty\":\"2\",\"Descrip\":\"Trays 1 and 2 Pickup rollers\",\"Part#\":\"RM1-0036-OEM\"}]


    Is there a way to get clean data without the [{\", even if it was more comma delimited friendly that would be helpful but \" xxx \" is not delimited friendly.

    Is there another widget that would work better?

    Thanks,

    Eric

  • Kiran Support Team Lead
    Replied on January 16, 2020 at 7:52 PM

    Please note that the configurable list widget is loaded using iFrame on the form and the data received is stored in a single column currently since the widget is being considered as a single field. 

    The input table field allows the field data to store in separate columns to achieve your requirement. You may now also use multi-type inputs for an input table field from the field properties.

    157922233220200117 062134 Screenshot 10

    However, the rows in the input table field is fixed and cannot be added dynamically as in configurable list widget.

    Please give it a try and let us know if you need any further assistance. We will be happy to help.