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

  • 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.

  • Ahmed_S
    Replied 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.