Configurable List widget submit data to multiple columns

  • Profile Image
    lasercorp
    Asked on January 16, 2020 at 03: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

  • Profile Image
    Kiran
    Answered on January 16, 2020 at 07: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.png

    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.