- lenskitreasurerAsked 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!
- JotForm Supportashwin_dAnswered on August 11, 2017 at 02:04 PM
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.