How to display the donation amount in separate column of google spreadsheet?

  • Profile Image
    lenskitreasurer
    Asked on August 11, 2017 at 01:42 PM

    When I look at results downloaded to a spreadsheet, I don't have a field for dollar amounts that can be totaled.

    Thank you for your help!

    Kathy

  • Profile Image
    ashwin_d
    Answered on August 11, 2017 at 02:04 PM

    Hello Kathy,

    If I understand your question correctly, you want to show the donation amount separately in integrated google spreadsheet. Is that correct?

    Unfortunately it is currently not possible to automatically separate the donation amount. The only option is to manually separate the data in different columns of google spreadsheet. 

    Since each field display data in separate column, one way to achieve your requirement is to add a "Form Calculation" widget in your form and set the formula to read the donation amount. You can hide the form calculation widget so that its not displayed in form to your users. Please check the screenshot below:

     

    Please take a look at the following cloned form and see if it works as expected:  https://form.jotformpro.com/72225726160956

    Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!