Free push notifications Workaround

Community Resources
104

You should do that using an ARRAYFORMULA in the Sheet instead.

105

Stuck on the logic. In the Transaction table, each row needs the user’s phone number pulled from the Profiles table. Feels like I need some matching logic like an IF statement inside the ArrayFormula. If username in transaction row matches username in Profiles, pull the phone number into the Transaction row. Does this right? Can that be done with ArrayFormula?

Thank you

106

Thank you. Have it working.

2 Likes
107

Thanks for your contribution, I have a few weeks trying to make it work for me and I have not succeeded; When you have time, could you help us with a video please?
:v:t5:
good vibes

108

Hey @Drearystate,

I am trying to get the email tag for Claro in Peru. Would you point me to the right direction?

I’ll be looking for the ones in Chile. Would you point me to those ones as well?

Thanks!!

1 Like
109

with what parameters are you looking for them? I can help

110

I have a couple of people in Chile and Peru and I want to set up text notifications for them but I can’t seem to be able to do it.

111

Have you tried Twilio for the text messages? Not free, but a powerful platform.

1 Like
112

I have looked into it. It is pretty powerful but I am looking for some other options.

113

Did you try my text notifications script?

114

Nope. I ended up using Twilio.

115

Hi all, I created solution for ‘push’ notifications using Glide web hooks, Integromat, and Click Send. To implement this, you’ll need to do some work, but it offers a powerful, supported solution.

In brief, you’ll configure a web hook action that will call integromat. Integromat is like Zapier, a service that basically wraps JSON API’s for a growing number of applications. Click Send is one such service / application–it handles SMS and email distributions. You’ll need to set up accounts with both Integromat and Click Send. Both can scale quite well, if you need.

So, Glide action → web hook → Integromat → ClickSend SMS
In your Glide action (web hook), you’ll specify the minimum parameters you’ll need to make the SMS call. At the minimum, those will be you message and the number to which it’ll be sent. You can configure the system to schedule texts in the future, very useful if your app is to remind someone of something coming up.

More details available upon request.

Good luck!

2 Likes
116

Right, but the difference being yours will have a delay and could possibly cost money. The solution listed here is instant and 100% free and customizeable.

117

Hi, I’ll respectfully push back a little: the two solutions complement each other: they each have plusses and minuses.

Yes, using ClickSend results in a small cost (~1 US penny / SMS), but there is no inherent delay: you can flexibly schedule the message to go instantaneously or at any arbitrary time in the future (nice for scheduled reminders). That solution also relieves the developer of having to look up / know the user’s phone carrier–only requisite input is the recipient’s phone number. Finally, with ClickSend you can set up a fixed sending phone number (small extra charge) so that your messages are automatically grouped on the recipient’s phone (useful if you need to send more than one msg).

Having said that, your solution is very elegant and is, yes, free of charge. All good. Multiple ways to slice the pie, all depending on the flavor of pie you’d like to eat :wink:

1 Like
118

I use this same model. Works really well. Super fast and super reliable. I just wish that a link in the SMS could fire up the app. To date I’ve not found a way to achieve that on iOS.

119

I add the daabase in its entirety and the logged in user just picks the carrier from a choice option. I currently list every carrier I have and in alphabetical order. When they type their area code it isolates which part of the world their phone is from to reduce the list. I understand a penny is just a penny but a penny is still $20 a day for me if I go that route.

1 Like
120

I need this :frowning:

121

This title is misleading people as this is not solved, it should be renamed as a workaround or any other solution as a it’s not solving the issue

Anyone from the supervisors here can rename this ?

4 Likes
122

Hi are you still using the Message Auto Sender service?

How’s the review so far?

Is the whatsapp number you have used with them, business or personal? Thanks.

1 Like
123

It is a permanent solution since it is not something Glide would address.

2 Likes