Separate Payment submision info into different columns

  • Profile Image
    Asked on October 10, 2019 at 11:44 AM

     I am building a form for use with a website we are developing. I am using a few form companies to see which most closely matches our needs.

    I noticed that submission data gets saved to a sheet but not all data seems to be saved. For instance I need to save the COUPON CODE in a separate field as well as the amount paid by SUBTOTAL, and TAX for my records.

    I see this information is all provided in the download XLS option but it is not in a usable format. Is there a way to make them separate columns? Otherwise someone would have to go through by hand and copy and paste info. Why would Jotform provide information like this?

    Is there a fix or a workaround?

  • Profile Image
    Answered on October 10, 2019 at 12:58 PM

    Unfortunately, the resulting data in Payment submissions are contained on single-cell only because it was using the Payment tool's API and not just the interface in Jotform side alone. 

    So there must be a limitation on what the developer can achieve if the API (of payment tool) has restrictions and limitations as well.

    One workaround is to download a copy of the submissions into an Excel file and use the Text-to-Columns feature. It might be a little tedious though.

    Another workaround is to create the products outside the payment field and use traditional dropdown and checkboxes then do the calculation in a Form Calculation widget.

    As soon as the value is calculated, you may pass the value to the user-defined amount in the Payment field.

    Please refer to this guide on How-to-Pass-a-Calculation-to-a-Payment-Field.