How to separate configurable list widgets data using Spreadsheet?

  • Profile Image
    Hangchanleakna
    Asked on September 03, 2018 at 12:09 PM

    HI , 

    here is my spreadsheet integration. i will be suffer over this integration result , 

    i used Configurable List widget. i do not expect to see such results. 

    is it possible to separate this combination  into each row on spreadsheet ? 

    that will be easier for reader and auditor. 

    for ex : products Transfer : 1067 Coke .... , QTY/Pallets : 45, QTY/Cases: 3, WH Row No. 78 , Details : NA  

    15359907141.PNG


  • Profile Image
    Richie_P
    Answered on September 03, 2018 at 12:38 PM

    Unfortunately, using configurable list widget will only render a single column in the submissions.

    If you use our Grid Report, the information will be separated by columns.



    You can use commas as a separator to make columns within Excel.

    Go to the Data tab and select text to columns under data tools then select delimiters and hit next. Then select comma as the delimiter and hit finish.




    You can check this guide for more information:https://support.office.com/en-in/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

    Hope this information helps.

    Thank you.


  • Profile Image
    Hangchanleakna
    Answered on September 03, 2018 at 10:17 PM

    HI Richie, 

    Thanks for the idea , 

    i tried Grid Report and it looks fine and perfect. 

    but the other experiment with Google Spreadsheet : Go to Data => split text to Column , it works but each text are seperated, means if i submit for 4 products in a day there will be the long extend of each products. which is not rang in order as a row. 15360274041.PNG

  • Profile Image
    Nik_C
    Answered on September 04, 2018 at 01:52 AM

    Unfortunately, when Configurable list widget is used, it is hard to export its data to Spreadsheet/Excel because it acts as one field for the form, therefore, one for the integration.

    I'm afraid that we cannot adjust that, so another alternative would be to use Input table field:

    1536040096Screen Shot 2018-09-04 at 7.47

    Or, which will work best, to have all fields created with separate basic fields:

    1536040266Screen Shot 2018-09-04 at 7.50

    Since only that will ensure that each field is exported to separate cell in Excel.

    Let us know if you have any further questions.

    Thank you!

  • Profile Image
    Hangchanleakna
    Answered on September 04, 2018 at 01:58 AM

    Hi , is the input table can be calculated ? 

    Because I will use the Qty and text And few condition also. Between text and Qty. In configurable widget I couldn’t perform calculation and condition. So it’s sad. 


  • Profile Image
    Kiran
    Answered on September 04, 2018 at 03:38 AM

    Is the input table can be calculated?

    Calculations can be performed on an input table fields. Please refer to the guide below:

    https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

    However, Input table field is limited to have only one type of field throughout the table while configurable list allows different types of fields in each row.

    Thanks!

  • Profile Image
    Hangchanleakna
    Answered on September 04, 2018 at 03:51 AM

    we also can't use the drop down box in input table. 

  • Profile Image
    Nik_C
    Answered on September 04, 2018 at 03:53 AM

    Yes, unfortunately, that is not possible.

    If you know the final number of rows that your customers will add (or if you can limit them to number of rows they can add), probably the best solution will be to create such workflow with basic fields as I advised above, since you will then have full control over calculations, conditions and exporting to Excel/Spreadsheet.

    If you need any assistance, please let us know.

    Thank you!