I am trying to build a form that will calculate the amount of leads that i enter

  • Profile Image
    RpoFarmers
    Asked on December 28, 2020 at 10:08 PM

    I have 9 lead providers that I would like to track the daily leads incoming. An at the end of the month see the total. Then I would like to compare that to the sold and get the closing ratio. I have tried the form calculator and this does not work. I have tried the input table as well. I can not get multiple lines to add up. Plus how can I track the month if I input daily? Please advise.

  • Profile Image
    Ahmed_S
    Answered on December 28, 2020 at 10:41 PM

    You can integrate your form with Google Sheets, so you can push your daily collected data from you from into a sheet and apply any calculations and formulas to that sheet to get any indicators on these timescales data.

    Please check this guide for how to integrate your form with Google sheets

    https://www.jotform.com/help/228-how-to-integrate-forms-with-google-sheets

    You can also integrate your form with other services like SalesForce, Zoho and other CRM related services.

    Please give it a try and let us if you need any further assistance.