Google Sheet Integration: Option to split the values of the product list field into different cells

Buenos días!

Tengo un problema con la forma en que uso la integración de google sheets y les pido me ayuden.

Uso el componente de categorías, porque encuentro que es el mejor para mi forma de vender online: https://form.jotform.com/231664780220654

Las ventas realizadas se depositan en una base de datos integrada en google sheets

Mi problema es que necesitaría que en vez de pasarme todo junto me lo desglose en columnas tipo: Producto, color, precio, cantidad, etc.

Entiendo que yo podría hacer mi formulario acorde a esta necesidad sin usar ese componente de categorías, pero mi cliente, en tal caso, debería hacer un gran recorrido entre tantos productos para poder realizar una compra. En definitiva, si bien el componente de categorías y productos me beneficia a la hora de tener una interfaz más dinámica y menos voluminosa, me complica cuando necesito desglosar cada elemento que compone una venta para poderlo ver reflejado y ordenado en columnas individuales en google sheets.

Espero puedan ayudarme, muchas gracias

Hi Carlos,

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'll have to wait until they're available again.

Now, let me help you with your question. Currently, we have no control over how the data is exported to Google Sheets, and it's not possible to separate the value into different columns sent to Google Sheets. Also, the Product List is treated as a single field. This is the reason why its content or products are placed in only one cell. But if you want to divide the data into different columns, I recommend looking into Google Sheets' Text to Columns feature. You can check out this guide.

By the way, I would recommend doing this on a different sheet and not with the spreadsheet that is integrated into your form because any alterations on the integrated sheet will break the integration.

Also, I've gone ahead and escalated this as a feature 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.

Reach out again if you have any other questions.