1

Send reminder SMS

Hi everyone

I am trying to send an appointment SMS reminder referred to an DATA FIELD. 

How is this possibly, if it is!

I look on Zapier, but can't find the right app. 

thanks in advance. 

8 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view

    Cirugia Toracica

    This can be done with messagebird.com using the API of messagebird. Code example:

    let response := do as server
            http("POST", "https://rest.messagebird.com/messages", {
                'Content-Type': "application/json",
                Authorization: "AccessKey " + 'API-key'
            }, {
                recipients: recipient,
                originator: Originator,
                body: Message
            })
        end;
    alert(text(response))
    

    where 'API-key' is the messagebird api key (text field),

    recipient is the receiver's phone number (text field),

    Originator is your phone number used to login to messagebird (text field)

    Message is the sms message (text field)

    Steven

      • Jack_Fleming
      • 1 yr ago
      • Reported - view

      RoSoft_Steven 

      Hi Steven, I've signed up for Messagebird and copied your script into Ninox, using to button to trigger this. I have pasted the Messagebird API as our API-key however in the Ninox script it is showing an error saying "field not found: our API key". Any ideas?

      • Jack_Fleming
      • 1 yr ago
      • Reported - view

      RoSoft_Steven 

      I should have pasted this:

        Authorization: "AccessKey" + '123456789forexample'
              }, {
      
      • Ninox partner
      • RoSoft_Steven.1
      • 1 yr ago
      • Reported - view

      Jack Fleming Glad you managed to get it working 👍

    • Cirugia_Toracica
    • 1 yr ago
    • Reported - view

    thanks for response. 

    but how to trigger the SMS 24 hs before date?

      • Paul_Chappell
      • 1 yr ago
      • Reported - view

      Cirugia Toracica Use "Trigger after open" in the database Options and create a routine to loop through the appointment records that meet your date criteria.  You will also need to create a Yes/No field in your appointments table that gets set when a SMS has been sent to ensure it doesn't get sent again next time you open the database. 

      Of course, this will only work if someone actually opens your database, but it then doesn't need any external processes like Zapier.

      • Cirugia_Toracica
      • 1 yr ago
      • Reported - view

      Paul Chappell thanks!!! for your help!
      could you please explain a little more how to create that routine loop?

    • John_Halls
    • 1 yr ago
    • Reported - view

    Cirugia Toracica If you did decide to use a timed script then have a look my simple step-by-step guide here https://forum.ninox.com/t/x2hbzyb/timed-scripts

Content aside

  • 1 Likes
  • 1 yr agoLast active
  • 8Replies
  • 313Views
  • 6 Following