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

6 Likes

I wonder if you combined this with @Jeff_Hager’s floating button html code, with a thumb emoji as the button text. Would be a neat way to integrate it visually.

2 Likes

Oh for sure! I made this while I was experimenting with actions. Can make it look a lot more attractive.

1 Like

Could you show how it works? I mean the algorithm of rollup likes

Algorithm?

Hey @Manan_Mehta, @ThinhDinh, @Robert_Petitto, @eltintero

Has anyone figured out how to count streaks?

I have a personal app in which I’d like to add streaks count but I’m having trouble with the date part of it. I mean how to make it keep counting or restart the counting.

Thanks guys!

1 Like

I have a complex way of counting streaks on one of my apps where I am using many GSheets formulae and a script. Tried multiple things previously but that was the best way I could think of but that was before actions was launched.

Now with actions I think there can be a simpler way. I will have to think about it.

2 Likes

Streaks is tricky…had to use a complicated spreadsheet formula that I’ll have to go back and find.

2 Likes

You could probably do something with a relation and rollup to get a max date. Then create a math column to add 1 to the rollup date. Then maybe in a compound action, check if the math date is within Today. If it is, increment 1 to a streak column. Else, if it is after Today, then do nothing with the streak column as it’s already been counted for today. Else, just reset the streak column to 1. I’m imagining this on the form submit actions.

6 Likes

So smart!

2 Likes

Sounds good! I will try this.

It is going to be for a view detail. I’ll see what I can do.

Let you all know how it goes.

2 Likes

my favourite of the week!

1 Like

Improved the UI

4 Likes