# Need help - voting on holiday lights contest **URL:** \ **Category:** Ask for Help\ **Created:** [November 30, 2020, 2:07am UTC](https://community.glideapps.com/t/need-help-voting-on-holiday-lights-contest/19126 "2020-11-30T02:07:09Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Joe\_Groh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_groh/32/16414_2.png) [@Joe\_Groh](https://community.glideapps.com/u/Joe_Groh)\ **Post date:** [November 30, 2020, 2:07am UTC](https://community.glideapps.com/t/need-help-voting-on-holiday-lights-contest/19126/1 "2020-11-30T02:07:09Z")
Hello all, fairly new to Glide, appreciate all the great help, video and resources here. I’m building an app for our local community for a Holiday Lights contest - [https://lightupoakley.glideapp.io/](https://lightupoakley.glideapp.io/) - and I’ve built the piece for residents to sign up, nominate their home. Now I need to built function for any user to vote on the nominations. Will have categories for both Residential (Best Traditional, Best Themed, Griswold) and Business (Best Window Display, Best Outdoor Display). I’m confused on how to start to build the Vote function ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 30, 2020, 2:13am UTC](https://community.glideapps.com/t/need-help-voting-on-holiday-lights-contest/19126/2 "2020-11-30T02:13:54Z")
Have a number column for “Global vote” which will count all votes and a user-specifc number column for “Single vote”, which will act as a mean to stop people from voting multiple times. You should create a button, which will have two actions to increment both the single vote and the global vote by 1. Hide the button when the single vote is 1. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 30, 2020, 2:17am UTC](https://community.glideapps.com/t/need-help-voting-on-holiday-lights-contest/19126/3 "2020-11-30T02:17:10Z")
> [@Joe\_Groh](#): > > Will have categories for both Residential (Best Traditional, Best Themed, Griswold) and Business (Best Window Display, Best Outdoor Display). Regarding this, I might have a custom ranking formula in the Sheets for you, which would act on the Global Voting score I mentioned above. Not sure how you’re structuring the data though. ---
**Author:** ![Joe\_Groh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_groh/32/16414_2.png) [@Joe\_Groh](https://community.glideapps.com/u/Joe_Groh)\ **Post date:** [November 30, 2020, 2:30am UTC](https://community.glideapps.com/t/need-help-voting-on-holiday-lights-contest/19126/4 "2020-11-30T02:30:51Z")
I’m open to structuring the data in whatever fashion is best. Currently I have columns on a lookup sheet - one for “Res Vote Category” and one for “Bus Vote Category” ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 30, 2020, 2:32am UTC](https://community.glideapps.com/t/need-help-voting-on-holiday-lights-contest/19126/5 "2020-11-30T02:32:37Z")
> [@Joe\_Groh](#): > > Best Traditional, Best Themed, Griswold So for example are these categories consuming 3 different columns? ---
**Author:** ![Joe\_Groh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_groh/32/16414_2.png) [@Joe\_Groh](https://community.glideapps.com/u/Joe_Groh)\ **Post date:** [November 30, 2020, 2:36am UTC](https://community.glideapps.com/t/need-help-voting-on-holiday-lights-contest/19126/6 "2020-11-30T02:36:40Z")
![app](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9a77edc5b714f09b6d99afaad8b06912bf0e6b4b.jpeg) But i’m open to suggestions for best way to handle ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 30, 2020, 3:19am UTC](https://community.glideapps.com/t/need-help-voting-on-holiday-lights-contest/19126/7 "2020-11-30T03:19:13Z")
Would people have to vote 5 times if they believe an item deserves all these awards? ---
**Author:** ![Joe\_Groh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_groh/32/16414_2.png) [@Joe\_Groh](https://community.glideapps.com/u/Joe_Groh)\ **Post date:** [November 30, 2020, 3:24am UTC](https://community.glideapps.com/t/need-help-voting-on-holiday-lights-contest/19126/8 "2020-11-30T03:24:09Z")
up to 3 times if residential, up to 2 times if a business ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 30, 2020, 3:27am UTC](https://community.glideapps.com/t/need-help-voting-on-holiday-lights-contest/19126/9 "2020-11-30T03:27:56Z")
Right, so what I would do is to have a pair of column for each sub-category as stated above. So for example: Best Traditional Global & Best Traditional User. Then set the action as I stated above to prevent multiple votes. Then you can use those numbers to rank at the end of contest.