Has anyone attempted to use the new compound actions with glide sheets to create time triggered events. An example of this would be if timestamp is greater than 24 hours then set column clear, or if timestamp is less than largest timestamp then event?
1 Like
I might have a play with that concept, thanksI don’t think it will actually work because all compound actions i think are triggered when clicked on.
1 Like
But you can make your if then else in glide sheets do some stuff based on time…
So let’s say you timestamp an event. With that action you add into the column next to it 30 minutes everytime. another column combines these 2 so you now have a future time. The if then else column states if this column (which is the column set to 30 minutes past its timestamp counterpart) is less than the current time, then do this…
1 Like
So we can make a math column in glide to prevent delay in information combining time and a decimal to represent the mnutes (0.03125 is 45 minutes of a day) so that gets us a little closer.
1 Like
Any idea how t implement a column that counts up depending on how many people are in it? In Glide only though.
1 Like
oh man this would solve my lack of “notification” in Glide. We could have the app send reminders each day over text!
I use integromat now for sending scheduled messages.
You need to use two scenarios, and the data store in between, as integromat only has a sleep function of 300 seconds (hence the trick).
2 Likes
- the video I used to learn the trick
3 Likes
You mean count the rows, and display the incremental number in a column? A rollup column will do that, set it to count the row IDs.
I did the timer as you described, it works well, thanks. Other than the “Now” counts up in 10 second increments, at least in the display in the Glide table. I checked with a stopwatch and the there seems to be about 4 seconds of processing time for the action.
I solved this problem by switching formats to a more capable solution.
2 Likes
Which one?
what more capable solution… please share 
what do you need?
In 2023, Glide will roll out Time-based actions. Can’t wait!
6 Likes
what will be the refresh rate? instant? or like now… every 10 sec?
2 Likes
1 Like
ok… let’s wait… but anyway… a big deal! looks like they might give some more java options…
2 Likes
Still waiting for that feature. I want to configure some timed based push notifications
1 Like
MEEEEEE too!! 