¿Cómo hacer que los datos del widget Lista configurable se separen en columnas?

Hello,

I have several questions, see if you can help me.

I'm trying to create a form to collect:

• by date, medication and the number of tablets a patient takes

In the initial option that I have created, it looks visually clean and easy, but when extrapolating it to an Excel table, all that data appears together in the same column, so it is not useful for later working with that data.

• How can I record this in the simplest way, so that when dumped into Excel tables each piece of data appears in different columns?

You have to record this for 1 month.

• Is there a way for them to close the app or form, and when they reopen it they continue where they were? Or every time they open it and enter data, will it be a new record?

• If each patient has an ID number already defined (external to jotform), is there a way to send the form with that ID embedded for each one?

Hi Ainhoa,

Thanks for reaching out to Jotform Support. Our Spanish Support agents are busy helping other Jotform users right now, so 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, it might take a while until they're available again.

Now, coming back to your question, unfortunately, when using the Configurable List widget, all the data will be stored in one column because the Configurable List widget is considered one element. Right now, Jotform tables cannot automatically separate them, aside from you doing it manually. A possible workaround would be to export the submissions into Excel and use the Text-to-Columns function there.  Additionally, you can try to create a Grid Listing report to separate the Configurable list widget data into separate table columns. You can then copy the report data into an Excel file. Let me show you how:

1. On the My Forms page, check the form to select it.
2. Click the Reports button at the top.

3. From the Reports menu, click the Add New Report button.

5. Next, will be the Grid Listing report setup page, which is divided into three sections, then click the Create button at the bottom to finish the setup.

6. After clicking the Create button, you will be prompted that the Grid Listing Report is ready. On the same pop-up, you will see the link to the Grid Listing Report that you created and a button to copy that link.

You might want to check out this guide How to Create a Grid Listing Report for more information.

As for your other questions, I've moved them to a new thread. You can check that out below:

•  Is there a way to send the form with that ID embedded for each one?
• Is there a way for them to close the app or form, and when they reopen it they continue where they were?

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