# Like counter

**URL:** https://community.glideapps.com/t/like-counter/7094
**Category:** Ask for Help
**Created:** [April 15, 2020, 1:45pm UTC](https://community.glideapps.com/t/like-counter/7094 "2020-04-15T13:45:11Z")
**Posts on this page:** 20
**Page:** 2

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [May 4, 2020, 9:19pm UTC](https://community.glideapps.com/t/like-counter/7094/21 "2020-05-04T21:19:46Z")

</div>

> [@User Specific Columns + User Profiles Demo](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097):
>
> call_me_hand Hey all! Wanted to create a quick and very rough demo of Glide’s two newest features: User Specific Columns and User Profiles. The video covers the process from sheet creation to feature implementation. Hope this helps until an official video comes out! [[Glide: User Specific Columns and User Profiles Demo] ](https://www.youtube.com/watch?v=9LLur9db8NM)

---

<div class="post-metadata">

### Author: ![Wendy\_Longo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wendy_longo/32/6498_2.png) [@Wendy\_Longo](https://community.glideapps.com/u/Wendy_Longo)
#### Post date: [May 4, 2020, 9:31pm UTC](https://community.glideapps.com/t/like-counter/7094/22 "2020-05-04T21:31:44Z")

</div>

AWESOME !!! you saved the day with this video !!! finally  
I didnt realized the spreadsheet seen with the " DATA " feature views it differently then the spreadsheet itself and has all those features and formulas

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [May 4, 2020, 9:37pm UTC](https://community.glideapps.com/t/like-counter/7094/23 "2020-05-04T21:37:38Z")

</div>

Yes! The data editor in Glide, while more limited than a spreadsheet regarding the AMOUNT of formulas available, is MUCH MORE convenient (and instantaneous) than spreadsheets.

---

<div class="post-metadata">

### Author: ![Jim\_Parish](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jim_parish/32/7653_2.png) [@Jim\_Parish](https://community.glideapps.com/u/Jim_Parish)
#### Post date: [May 20, 2020, 4:09pm UTC](https://community.glideapps.com/t/like-counter/7094/24 "2020-05-20T16:09:17Z")

</div>

How did you manage to use the like/dislike button for each user?  
I only manage to make each user write a text or a rate, but like/dislike button.

Then, can you see (in a sheet, or in data) the different comments (text, rate, like…)?

---

<div class="post-metadata">

### Author: ![Wendy\_Longo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wendy_longo/32/6498_2.png) [@Wendy\_Longo](https://community.glideapps.com/u/Wendy_Longo)
#### Post date: [May 20, 2020, 8:52pm UTC](https://community.glideapps.com/t/like-counter/7094/25 "2020-05-20T20:52:06Z")

</div>

![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/224a1fee066718707d6cc164966f6cd16f6cb25b.jpeg)

so for all my FRUIT ITEMS i created a boolean function so signed in users can save favorites etc …  
and then i created a checkbox function so they can click like or dislike  
hope this helps

---

<div class="post-metadata">

### Author: ![Jim\_Parish](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jim_parish/32/7653_2.png) [@Jim\_Parish](https://community.glideapps.com/u/Jim_Parish)
#### Post date: [May 26, 2020, 1:07pm UTC](https://community.glideapps.com/t/like-counter/7094/26 "2020-05-26T13:07:40Z")

</div>

How did you manage to do this counting? it’s not possible to add the likes, isn’t it?

---

<div class="post-metadata">

### Author: ![Jim\_Parish](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jim_parish/32/7653_2.png) [@Jim\_Parish](https://community.glideapps.com/u/Jim_Parish)
#### Post date: [May 26, 2020, 1:43pm UTC](https://community.glideapps.com/t/like-counter/7094/28 "2020-05-26T13:43:39Z")

</div>

Thanks  
But do you manage to count the number of likes and dislikes?

---

<div class="post-metadata">

### Author: ![Wendy\_Longo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wendy_longo/32/6498_2.png) [@Wendy\_Longo](https://community.glideapps.com/u/Wendy_Longo)
#### Post date: [May 27, 2020, 10:06pm UTC](https://community.glideapps.com/t/like-counter/7094/29 "2020-05-27T22:06:40Z")

</div>

I didnt need to know this information , so I dont know if you can

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 27, 2020, 11:48pm UTC](https://community.glideapps.com/t/like-counter/7094/30 "2020-05-27T23:48:27Z")

</div>

As far as I know, you can’t do a rollup count of likes yet. It stores a number, but at best you can only store it for each individual user. You just can’t total the number of likes.

---

<div class="post-metadata">

### Author: ![wolff\_yves](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wolff_yves/32/13934_2.png) [@wolff\_yves](https://community.glideapps.com/u/wolff_yves)
#### Post date: [January 11, 2021, 12:52pm UTC](https://community.glideapps.com/t/like-counter/7094/31 "2021-01-11T12:52:15Z")

</div>

Hello, any update on this topic ? Or may someone can tell me how to do the average with the rating, for a specfic item not for the current user ?

---

<div class="post-metadata">

### Author: ![Gari\_Gono](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gari_gono/32/19599_2.png) [@Gari\_Gono](https://community.glideapps.com/u/Gari_Gono)
#### Post date: [January 11, 2021, 5:35pm UTC](https://community.glideapps.com/t/like-counter/7094/32 "2021-01-11T17:35:15Z")

</div>

@Robert_Petitto has a pretty good video on Youtube on this particular use case ([https://youtu.be/O7TEF5z5t7U](https://youtu.be/O7TEF5z5t7U))

---

<div class="post-metadata">

### Author: ![Gari\_Gono](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gari_gono/32/19599_2.png) [@Gari\_Gono](https://community.glideapps.com/u/Gari_Gono)
#### Post date: [January 11, 2021, 5:59pm UTC](https://community.glideapps.com/t/like-counter/7094/33 "2021-01-11T17:59:34Z")

</div>

I’ve also implemented a workaround to enable rolling up “Likes” that might work for other people as it did for.

By using a button, you can add an Action called “increment”. I added a column to my spreadsheet called “LikesPositive” and any time someone clicked the Button I added, Glide would +1 to the “LikesPositive” column on that item (regardless of the user).

Obviously the above is open to spam and people constantly smashing the like button, so what I did was create a User Specific Column called “VotedPositive” which was also incremented whenever the user clicked the button.

With all the “…Positive” variables, I also added the “…Negative” equivalents and the “Total…” equivalents too, to use in conditions.

i.e. TotalVoted = VotedPositive - VotedNegative  
I then added a display condition which meant the “Like” button would only show up if “TotalVoted” was less than 1 (meaning you either haven’t voted or you voted and unvoted).  
The “Unlike” button would then show up in the opposite (i.e. the “TotalVoted” is more than 0).

I repeated the same for the Total Number of Likes, which were not user specific columns.

I hope this helps, and I’d be happy to do a video to explain more clearly if people require.

---

<div class="post-metadata">

### Author: ![Nasorean](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nasorean/32/25231_2.png) [@Nasorean](https://community.glideapps.com/u/Nasorean)
#### Post date: [April 21, 2021, 11:05am UTC](https://community.glideapps.com/t/like-counter/7094/35 "2021-04-21T11:05:03Z")

</div>

I’m running into an issue where the dislike button stays if that is the first button pressed. The “unlike” button will continue to stay visible and can be spammed unless the “like” button is pressed first or when you spam enough “likes” to get it past 0.

I tried incrementing by “-1” and that didn’t help me.

Trying a few workarounds but getting stuck with my if-then logic. I tried having a statement where:

IF VotedNegative \> 0 AND IF VotedPositive is empty THEN “LOCKED” and I tried that as a visibility condition.

Any thoughts?

---

<div class="post-metadata">

### Author: ![Gari\_Gono](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gari_gono/32/19599_2.png) [@Gari\_Gono](https://community.glideapps.com/u/Gari_Gono)
#### Post date: [April 21, 2021, 11:52am UTC](https://community.glideapps.com/t/like-counter/7094/36 "2021-04-21T11:52:19Z")

</div>

What I did to try and make it simpler is to have a column in the spreadsheet which calculates the “Total Likes”. So you increment the positive likes when someone clicks the like button, increment the negative likes when someone “unlikes”.  
You then have a formula “=PositiveLikes - NegativeLikes” then base all conditions on that single TotalLikes column.

Hope that makes sense.

---

<div class="post-metadata">

### Author: ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)
#### Post date: [April 21, 2021, 6:55pm UTC](https://community.glideapps.com/t/like-counter/7094/37 "2021-04-21T18:55:47Z")

</div>

Have implemented a simple solution for this in this app to verify City-wide Covid Resources: [https://citywideresources.glideapp.io/](https://citywideresources.glideapp.io/)

You can copy this app.

---

<div class="post-metadata">

### Author: ![Cloud\_X](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cloud_x/32/11700_2.png) [@Cloud\_X](https://community.glideapps.com/u/Cloud_X)
#### Post date: [April 21, 2021, 11:36pm UTC](https://community.glideapps.com/t/like-counter/7094/38 "2021-04-21T23:36:03Z")

</div>

Actually @Robert_Petitto is one of the best glide apps creator ever I really like his videos and every glide user should subscribe to him

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 21, 2021, 11:51pm UTC](https://community.glideapps.com/t/like-counter/7094/39 "2021-04-21T23:51:39Z")

</div>

Aw shucks. You’re too kind!

---

<div class="post-metadata">

### Author: ![Tine\_Driessen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tine_driessen/32/10503_2.png) [@Tine\_Driessen](https://community.glideapps.com/u/Tine_Driessen)
#### Post date: [March 4, 2022, 12:56am UTC](https://community.glideapps.com/t/like-counter/7094/40 "2022-03-04T00:56:11Z")

</div>

In the meantime, is it yet possible to roll-up user-specific data?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 4, 2022, 1:02am UTC](https://community.glideapps.com/t/like-counter/7094/41 "2022-03-04T01:02:17Z")

</div>

There are newer posts at the end of this thread, but the answer is…not natively.

> [@Rollup Likes](https://community.glideapps.com/t/rollup-likes/18376):
>
> Rollup likes using actions while limiting to one like per user. The action is configured as shown where the Like Counter is the actual counter and the “Liked By” Column is a user specific column where I am incrementing the user’s ID from their profile (It’s a basic number assigned to each user using a formula like =arrayforumla(row(A2:A)) I use this user-specific column to define the visibility of the button outside so that one user cannot like a post twice. [image]

---

<div class="post-metadata">

### Author: ![aac](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@aac](https://community.glideapps.com/u/aac)
#### Post date: [September 30, 2022, 2:46pm UTC](https://community.glideapps.com/t/like-counter/7094/42 "2022-09-30T14:46:14Z")

</div>

Hi @Robert_Petitto ,

do you know when Rollup function will work over different users?

I’d like a likes-counter, so I created a user-specific column for storing the “likes”, but I’m not able to sum them across the different users.

Do you have any suggestion in order to implement this?

Thanks!

[Previous page](https://community.glideapps.com/t/like-counter/7094.md?page=1)

[Next page](https://community.glideapps.com/t/like-counter/7094.md?page=3)
