Product Field: Split each product into a separate rows in Jotform Table

  • TRADE_EVENTOS_trade360
    Perguntado em 24 de julho de 2024 às 12:05

    Olá, gostaria de separar a resposta do formulario por linha, no campo selecionar quantidade de produto, pois quando exporto as respostas o mesmo vem em uma unica linha no excel, preciso que para o mesmo usuario que responde seja separado por produtos.

    Jotform Thread 17227143 Screenshot
  • Camila Jotform Support
    Respondido em 24 de julho de 2024 às 14:17

    Hi TRADE_EVENTOS_trade360,

    I just wanted to remind you that I'll be helping you in English using Google Translate because our Portuguese Support agents are busy helping other Jotform users right now, and you can reply in whichever language you feel comfortable using. But, if you'd rather have support in Portuguese, let us know and we can have them do that. But, it might take a while until they're available again.

    Now, coming back to your question, the product list is a single element and, unfortunately, there's no way to separate the columns if multiple products are selected at this moment. But, you can download the submission data as Excel and utilize the split to column feature for Excel. Let me show you how to download submissions:

    • On your My Tables page, next to the form with the submissions you want to see, click on View Table.
    • Hover your mouse over the Download All button on the right side of the page. 
    • Now, choose CSV, Excel, or PDF format and download your data.

    Product Field: Split each product into a separate rows in Jotform Table Image 1 Screenshot 20

    While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. I've gone ahead and escalated your request to our Developers. When or if it's implemented depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know. 

    Let us know if you need any other help.