- JotForm SupportjonathanAsked on December 28, 2017 at 03:24 PM
there is no option within the for or within the integration that allows splitting of products of the payment field in the form on Google Spreadsheet.
As a workaround in the Google Spreadsheet, change the character that separates each product in the payment field column. And since the selected products in the payment field is/are separated by a new line — char(10) in Google Spreadsheet, we will change that into a different character that is accepted by the "Split Text to Column" using the SUBSTITUTE function — https://support.google.com/docs/answer/3094215?hl=en
Once the products are already separated using a different character, use the "Split Text to Column" to split the products into separate columns.
We do not encourage altering the main sheet integrated with the form as it may cause the integration to break. We suggest you import it on a different sheet first using the IMPORTRANGE function before performing the workaround above.