How to display order total in separate column of excel report?

  • Profile Image
    jsr
    Asked on April 08, 2017 at 08:22 AM

    Hi guys, I have created a report in excel but its not quite what I'm after, wanting to know if there is away to do this;

    - Payment Amount is in a column on its on (currently it has a column which has "Total Amount (Amount: 400.00 AUD)

    Total: 400.00") Id like it to just have "$400"

     

    - Is there away to get a report that is for a specific date range. For example Id just like the report for the current month. At the moment it just downloads every submission.

     

    Reason for this is i have a database I would like to import this into and the current formatting won't work for me

     

    cheers

     

    Jordan

  • Profile Image
    ashwin_d
    Answered on April 08, 2017 at 03:06 PM

    Hello Jordan,

    Do you mean to say that you want to display the order total in a separate column of excel report? 

    Unfortunately it is currently not possible to display products and order total in separate column of excel report. Please note that the product selection, order total and payment information are displayed together in one single column of submission & excel file. 

    Please confirm if this is what you want to achieve, we will create a feature request ticket and forward it to our backend team.

    I have moved your second question to a new thread so that we can address it separately. You will be answered in the following thread:  https://www.jotform.com/answers/1114752

    Thank you!

  • Profile Image
    jsr
    Answered on April 10, 2017 at 12:01 AM

    Hi Ashwin, yes this is correct. It means I can import a batch of orders into a system we are using. Currently we are having to enter them manually which is quite time consuming.

    Thanks :)

  • Profile Image
    jsr
    Answered on April 10, 2017 at 12:08 AM

    I have just created another hidden field on my form that contains the same payment value as the actual payment field. This will come out on its own column in excel.

    Problem solved :)

    Jordan