-
digi73295Asked 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? -
John Support Team LeadReplied 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.