In google sheets all purchase order details are being sent to the same table block

  • Profile Image
    sklayman
    Asked on June 04, 2020 at 08:08 PM
    When using a google doc integration, all purchase order details are being sent to the same table block (item name/quantity/total order amount) which makes it impossible to sum the total ordered per each item from all orders, the total value from all orders etc. Is it possible to send those to different doc columns?
  • Profile Image
    jonathan
    Answered on June 04, 2020 at 08:25 PM

    Currently this is how the Purchase Order data behaves in the submission results (in spreadsheets, submission page, google sheets, Excel, etc..)

    It was because the Purchase Order field or any of the payment field, even though it has multiple entries i.e. multiple products/items, the field is still one field only. All the entries were attributed only to that one field.

    This is similar to other fields that have multiple entries like the Checkboxes, Dropdowns, Radio options, configurable list widget.. so on.

    If you need to parse the data in the google sheets to split the data into separate multiple entries/columns/cells, you will have to do it manually. 

    You can use the internal function in google sheets called Text-to-Column

    I recommend doing it on separate Sheets and do not modify/alter the current google sheet being used by the form integration.

    Modifying the actual google sheets used in the integration can break the integration.

    Please let us know if you need further assistance.