How to split products in payment settings in google spreadsheet

  • Profile Image
    jonathan
    Asked 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.

    =SUBSTITUTE(A2,CHAR(10),"^")

    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.