Donation progress bar

Site URL: https://www.gerafoundation.com

Dear Forum

Our website is a non-profit aimed at fundraising toward astronomy projects. We have set projects with set funding goals and are already making progress with fundraising. I would like to be able to show a progress bar of which shows the target, and current fundraising progress. We take donations directly thought the SquareSpace platform so if this can be updated automatically using info from my SquareSpace site that would be a bonus.

Then we also take donations directly from partnerships which do not go through the website. 

My ideal would be a progress bar which shows the donations through the Squarespace website in one colour (lets say orange) which updates automatically, and then manually add on to that the donations we get from other sources in another colour (lets say green). 

If the ideal progress bar is possible it would be wonderful but if such an idea is possible I will be happy with something less sophisticated too.

Regardless of the design, I would need a separate progress bar for each project:

https://www.gerafoundation.com/kilimanjaro-millimeter-telescope

https://www.gerafoundation.com/university-of-nigeria

https://www.gerafoundation.com/nobeyama-observations

This adds a complexity in that any automated updating progress bar would need to be able to track the donations made to each of the individual projects. Im wondering if this can be done by tracking which of the project pages' donate buttons were pressed.

Thanks in advance to anyone reading this and considering any ideas or advice on any of the above. Any help is deeply appreciated.

Kind regards
Ross

6 minutes ago, RossBurns said:

Site URL: https://www.gerafoundation.com

Dear Forum

Our website is a non-profit aimed at fundraising toward astronomy projects. We have set projects with set funding goals and are already making progress with fundraising. I would like to be able to show a progress bar of which shows the target, and current fundraising progress. We take donations directly thought the SquareSpace platform so if this can be updated automatically using info from my SquareSpace site that would be a bonus.

Then we also take donations directly from partnerships which do not go through the website. 

My ideal would be a progress bar which shows the donations through the Squarespace website in one colour (lets say orange) which updates automatically, and then manually add on to that the donations we get from other sources in another colour (lets say green). 

If the ideal progress bar is possible it would be wonderful but if such an idea is possible I will be happy with something less sophisticated too.

Regardless of the design, I would need a separate progress bar for each project:

https://www.gerafoundation.com/kilimanjaro-millimeter-telescope

https://www.gerafoundation.com/university-of-nigeria

https://www.gerafoundation.com/nobeyama-observations

This adds a complexity in that any automated updating progress bar would need to be able to track the donations made to each of the individual projects. Im wondering if this can be done by tracking which of the project pages' donate buttons were pressed.

Thanks in advance to anyone reading this and considering any ideas or advice on any of the above. Any help is deeply appreciated.

Kind regards
Ross

For my past project I tracked the donation using API and log the transaction in a Google Spreadsheet then using javascript to display the value on the site, I think this technique can be similar to your progress bar request

On 10/30/2021 at 8:11 PM, Beyondspace said:

For my past project I tracked the donation using API and log the transaction in a Google Spreadsheet then using javascript to display the value on the site, I think this technique can be similar to your progress bar request

Hey could you share more details about your solution to this? I'm trying to do the same for my Squarespace site. How did you track using API and javascript to display?

Any insight would be very helpful.

Thanks

Yes, this is possible and not too difficult assuming you have a little bit of a coding background. I just wrote up a detailed solution on Stack Overflow:

https://stackoverflow.com/questions/70988857/is-it-possible-to-use-the-information-from-a-single-cell-in-google-sheets-to-aut/78336076#78336076