Feature Request: Calculating Fields Similar to a Spreadsheet

  • Profile Image
    NACUMS_org
    Asked on February 19, 2013 at 05:05 PM

    I've been asked to create a form with fields that total amounts entered by the user.  I see that questions similar to this have been asked and it sounds like you are working on a solution.  This isn't a rush and I don't want to learn or even really need to buy another form package (like ElbowSpace) just to produce one form.

    I can hold off on this for a while, if you are working on a solution.  Please, will you have something in the next few months?  If you say no, I'll understand.  I love JotForm and will keep using it for everything else.

  • Profile Image
    EduardoMendez
    Answered on February 19, 2013 at 05:24 PM

    Hi there, 

    Thanks for the kind words! :)

    Unfortunately, we do not have an ETA on this ticket.  However, the more votes for a request the higher it goes in priority.

    I have submitted your request to our dev team so that it counts as a vote for this feature.  They will update this thread as soon as they have any news on the feature,

    Thanks for your feedback and also for your patience!

  • Profile Image
    EduardoMendez
    Answered on February 19, 2013 at 05:34 PM

    Meanwhile, 

    Would integrating to Google Spreadsheet and doing the calculations on the sheet be a workaround?

    Also, we have a "Purchase Product" field under the "Payment Tools" tab which acts as a payment tool but has no integration to process the payment.

    Can that be a workaround as well? Please let us know!

  • Profile Image
    NACUMS_org
    Answered on February 19, 2013 at 06:18 PM

    I would need to see how Google Spreadsheets link to your forms.  Do you have instructions for this?

    The Purchase Product function won't work because the amounts will be entered by the users and will vary.  The form would need to show the individual amounts entered with the accumulated total, similar to an expense sheet.

  • Profile Image
    ardy0689
    Answered on February 19, 2013 at 07:08 PM

    You can refer to this guide on how to integrate on Google Docs and using Google Spreadsheet to receive your submissions. This is probably what Eduardo meant. You will need to receive your submissions from Jotform containing the values that need to be calculated and it will be automatically go to their corresponding column in Google Spreadsheet. You can use a 3rd column and set a formula to automatically calculate their values.

     

    Please let us know if it worked for you thanks!

  • Profile Image
    jonathan
    Answered on February 19, 2013 at 07:08 PM

    @ NACUMS_org

    Hi, please review this article -Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-  . This will help you integrate your form to google docs spreadsheet.

    ---

    The Purchase Product function won't work because the amounts will be entered by the users and will vary.  The form would need to show the individual amounts entered with the accumulated total, similar to an expense sheet.

    This is on the feature request list already submitted to our dev team. You will be inform immediately when update on its progress is available.

    Hope this help.

    Thanks.