Configurable List Widget excel display

  • Profile Image
    ARCORACI
    Asked on January 17, 2018 at 09:16 AM

    I want to be able to add labels for each sub category for this widget so I can upload it into filemaker database.  However, when I download the info into a worksheet the sub categories are merely separated by commas.  I would need to go through the extra step of separating the text to columns and then adding the headings which is something I don't want to do.  Is there a way I can customize or use a different widget that would allow me to do this?

    1516198394Screen Shot 2018-01-17 at 9.09

  • Profile Image
    Marvih
    Answered on January 17, 2018 at 10:57 AM

    The workaround for this since we cannot modify how it displays on Excel is by using a Grid Listing report so that you configurable list will formatted with a better look.

    1516204430516.png

    Or download it via PDF.

    1516204503517.png

    And the one you mentioned which is via CSV and format it manually via Text to Column.


    Hope this works for you.

  • Profile Image
    ARCORACI
    Answered on January 17, 2018 at 01:43 PM
    I really need to edit this so the columns are labeled because I upload into a filemaker database.
    Is there another table type of widget that would give me the functionality I need? I know I can create separate fields but it will not look as nice I was hoping to create something that looked like the configurable list widget but will allow me to download into labeled columns.
    ...
  • Profile Image
    Marvih
    Answered on January 17, 2018 at 02:20 PM

    Unfortunately Jotform is built using one column per Widget/Field during submission, so you will need to create it using multiple fields.