¿Cómo poner la cantidad pedida en una columna separada de la tabla?

  • euromeeting.euroforum
    Fecha de consulta 18 de diciembre de 2023, 7:01
    2- Tanto en este widget como en otras posibles opciones que lo sustituyan, la información sale toda en la misma casilla del excel una vez lo exportamos y necesitaríamos que la cantidad, el precio y el producto salgan en columnas separadas.
  • Nozomi_K Jotform Support
    Fecha de respuesta 18 de diciembre de 2023, 7:38

    Hi Euroforum,

    Thanks for reaching out to Jotform Support. Unfortunately, our Spanish Support agents are busy helping other Jotform users at the moment. I'll try to assist you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd prefer to receive support in Spanish, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, I'll help you with your question. If I understood you correctly, you want to split product sizes and quantities into separate columns when exporting. If this is the case, unfortunately, it is not possible to automatically separate the products into columns when you download the submission data as Excel or CSV.

    Please note that a column in the Jotform Table represents a single field, and since the Product List field is treated as a single field, it'll only occupy a single column in the table. As a workaround, you can manually split the values into separate columnsIf that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

    Reach out again if there’s anything else we can do for you.


  • euromeeting.euroforum
    Fecha de respuesta 20 de diciembre de 2023, 7:58

    Hola, gracias por tu respuesta, el problema está en que los widgets que estamos utilizando no separan los datos por comas, si no por espacios.

    ¿Habría alguna forma de poder separarlos o de que pudierais desarrollar dicha separación?

    Los widgets que necesitamos exportar separados son:

    Lista Configurable y Lista de productos

    La información se nos exporta sin ningún tipo de separador.

    Gracias!




  • Elbert_A Jotform Support
    Fecha de respuesta 20 de diciembre de 2023, 10:11

    Hi euromeeting.euroforum,

    Thanks for reaching out to Jotform Support. Unfortunately, our Spanish Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. At the moment, the product list and configurable list are considered one element when the data are downloaded, so basically it will only show on one column. We can open a feature request for that, however as a workaround you can change the Product List to other basic elements such as Single Choice Button and pass calculations on Payment Integration. Another possible workaround is to filter it and export data, once you export the data it will only export the data that is filtered. You can check these related thread for the same concern from other users.

    Give it a try and let us know how it goes.