Live Audience Poll

Good point. I was already planning to do this, but that’s a good reminder of the importance! Thanks George!

I think a simple Form Button should be enough. All results will show up in a sheet with the details you need. Some simple formulas can be used to tabulate and summarize the data.

Yes, maybe two form buttons, one for the morning poll and one for the afternoon poll. The only thing to think about would be multiple votes. You would have a separate sheet for each pole, that is where the Form Button would point to. But the tabulation would have to use the UNIQUE() function to make sure you were not counting anyone twice.

1 Like

I did something like this with a vote/poll with forms.


Thanks for sharing this! First, I love that this app is all about the OT! What a great way to teach kids visually!
Second, I’m going to have to play around with forms cause this looks great! Are you requiring everyone to do the separate email login and pin as mentioned above?

1 Like

Well. I kinda did it on the honor system. So my students could vote all they wanted. And technically they could vote for the same person all three times. I guess with Sunday School we trust them. Ha!

Hi spencerRus, how did you do the dropdown on the Input form?

OK done :slight_smile: but how did you do current leaders?


Brilliant, would love to see the sheets

There is a lot here: I think the sheets are the VOTES and RESULTS

I did this a long time ago and am sure there is an easier way now. But here it is.

Thank you, your a star!

1 Like

spencersRus since you’re a genius here, any idea how to restrict 1 person to cast 1 :open_mouth:

Sorry, I got nothing. I have thought it out, but it was not something I was really concerned with.

Hopefully, if you are voting on a Bible app, you would be honest :slight_smile:

But, some thoughts - this would only work if you made them SIGN IN with email.

Not sure how this would work, maybe someone reading this …
But, if you could make an IMAGE that connected to the FORM then count how many times that email ‘voted’ - the made the image disappear when vote total equaled ONE. Using some formulas and an IF-THEN column.

I know there is something like that in that ‘concepts’ app.


1 Like

More info on what @spencersRus is referring to.

Conditional button based on user

You could also use an inline list of one item where you control the reference value using formulas. If a reference value is cleared out due to a formula, then the list item would not show.


I have been thinking about this and have come up with a workaround that works for ME.

I let my users vote/RSVP as MANY times as they want, but ONLY THE LAST one is counted.
Must be signed in by email.
And in the form, must have the Special component that registers the Date and Time of the submission.

Here is a sample:

Three tabs:
ALL RSVP lets you see all the times everyone has filled out the form
LATEST RSVP lets you see JUST THE LATEST. If they filled it out twice, only the last one is posted.
Then I put one for ALL YES (just so I could have a list of affirmatives.

Admission: I do NOT have any idea how the google sheet works. I just put out a request for HELP on their boards (like this one) and some kind soul fixed it for me.
Here is a link to that:

1 Like

Thanks for taking the time to do the video of your poll app. Since I have to confess that I’m not the least bit familiar with using formulas in sheets, it’s great to see you explain the basics such as sort and concatenate. Even seeing that I can present the same data in three ways on the same sheet was a big help.

I have to say though that your Google icon is far too scary for a Sunday school teacher. But maybe you have it customised to only appear when viewers require some moral scrutiny? I promise I’ll repent if you stop giving me the evil eye. Ha.

1 Like

funny @Les_Henderson I am also an elementary school teacher. That google icon was taken one day at my desk as I was playing around with a new laptop/webcam. It was meant to be more bored than scary. But with 5th graders, I will take the scary look! HAHA

1 Like

Not even going to attempt to wrap my head around that formula. It’s easier for me to understand something when I can apply it to my own situation. I just wanted to offer some additional information. Doesn’t quite apply to your situation, but it’s a good formula to keep in the back of your mind. The attached thread shows how to find the last record that matches a search term. It’s good if you just need to find that last submission for a particular user, but not as useful for a poll.

1 Like

I tried and failed to understand that sheet formula as well. I figured out pieces of it but I have no idea how it works, and that would scare me a little if I was using it.

1 Like