Configurable List widget submit data to multiple columns

  • Profile Image
    Asked on January 16, 2020 at 03:55 PM


    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?



  • Profile Image
    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.


    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.