Like counter

[Robert_Petitto]

User Specific Columns + User Profiles Demo

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]

[Wendy_Longo]

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

[Robert_Petitto]

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.

[Jim_Parish]

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…)?

[Wendy_Longo]

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

[Jim_Parish]

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

[Jim_Parish]

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

[Wendy_Longo]

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

[Jeff_Hager]

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.

[wolff_yves]

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 ?

[Gari_Gono]

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

[Gari_Gono]

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.

[Nasorean]

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?

[Gari_Gono]

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.

[sardamit]

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

You can copy this app.

[Cloud_X]

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

[Robert_Petitto]

Aw shucks. You’re too kind!

[Tine_Driessen]

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

[Jeff_Hager]

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

Rollup Likes

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]

[aac]

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!