My solution listed above will do exactly as you want, mine was both automatic and manual, depending on the nature of the SMS. It’s been very reliable so far.
If you are using node, my Onesignal extension also has SMS sending functionality although I would recommend using Twilio as it's a cleaner implementation than Onesignal's offering
i also use the Twilio route.. but went the Whatsapp route.. as the cost per message was way cheaper.. the only thing with the Whatsapp.. its normally template based.. so you cant just setup a random message.. it will first need to be set message that is approved.. just worked out way way cheaper… but you have to take into consideration.. if you clients use whatsapp….
Twilio was actually very easy once I figured it out. I have it working on a trial account. I am a bit skeptical on the cost though. About how mush are you guys spending on Twilio for about how many messages?
Thanks Brian, that may be a bit over kill for my use case. Very few people will have access to it and most of our staff can't even clear browser cache without IT support. SO I think I am safe. lol
But having said that, how would you do it with variables? I'd be willing to explore it.