Recurring Giving Widget
=======================
The Recurring Giving Forecast widget displays a pie chart that shows the percent of the annual budget
for the designated fund as projected to be met by recurring giving based on the current giving schedules.

The widget utilizes an HTML file, SQL script and Python script as shown below. Since the giving forecast
is the same for all users, Caching should be set to **all users**.

To adjust the information for your church, you will need to make a few changes in the Python script.
Modify line 1 with the ID of the desired fund, line 2 with the Name of the desired fund, and line 3
with the annual budget for the fund you are using.

Video
-----
Below is a short video demonstrating some of the features of this widget.

.. raw:: html

    <iframe width="560" height="275" src="https://www.youtube.com/embed/4Ty_fXPWPyM?rel=0"
    frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

|

HTML Code
---------
Below is the HTML code for the Recurring Giving Forecast widget. As supplied by TouchPoint, the file name is
**WidgetGivingForecastHTML**.

.. literalinclude:: Files/WidgetGivingForecast.html
    :linenos:

SQL Script
----------
The SQL script to use depends on whether your church is still using the legacy giving system or has migrated
to the new Giving Pages.

Below is the SQL script for the Recurring Giving Forecast widget *if your church uses the legacy giving system.*
As supplied by TouchPoint, the file name is **WidgetGivingForecastSQL**.

.. literalinclude:: Files/WidgetGivingForecast.sql
    :linenos:

Below is the SQL script for the Recurring Giving Forecast widget *if your church has migrated to the new Giving
Pages.* As supplied by TouchPoint, the file name is **WidgetGivingForecastSQL**.

.. literalinclude:: Files/WidgetGivingForecast2.sql
    :linenos:

Python Script
-------------
Below is the Python script for the Recurring Giving Forecast widget. As supplied by TouchPoint, the file name is
**WidgetGivingForecastPython**.

.. literalinclude:: Files/WidgetGivingForecast.py
    :linenos:

|
|

+--------------------+------------------+
| **Latest Update**  | **11/05/2020**   |
+--------------------+------------------+

Provided updated SQL script for church that have migrated to the new Giving Pages.