Skip to main content
Question

Collecting a total from multiple days of responses

  • May 4, 2021
  • 3 replies
  • 20 views

Hello!

I am running a fitness challenge with Jotform. 

Participants get a specific number of points for different activities completed.   The first person to reach 100 points win.

 

The Jotform will tally the points for each participant entry, but will not total them up from day to day.

 

I need to be able to add a link or button into my jot form that will show them the their total from all of their submissions.  

Any ideas?  

Thank you for your help!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • May 4, 2021

Hi @nbonafede 

I suggest using Airtable to collect and organize the data, otherwise you’ll need to use formulas in GSheets.


nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • May 7, 2021

Hi @nbonafede!

You could also look into Glide, which can be powered by Google Sheets and then provides an app interface that your users could access. I believe that in order to limit a person to only seeing their own info, you’d have to upgrade, but I wanted to mention it anyway since I just find Glide so cool :)


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • June 25, 2021

Hey @nbonafede!

Just checking in to see how you got on with this. Were you able to solve it using Glide, or a spreadsheet app like Airtable or Google Sheets perhaps?

Or did you find another way? Please do let us know! :)