So, for example a different sender for “Lock” versus “Unlock”, then many smartphones let you set a custom message notification sound if you add each of these From addresses as a contact. Simply add both notifications to the “Then” portion of the program and you’re all set. I want to log the time that the deadbolt was locked or unlocked by the user, and I want to include the date this time. (I obscured the path to my Zapier webhook.)Zapier requestOne difference in this case is that the Content-Type header has been set to “application/json”. With Airtable, for example, I can export anything of my databases any time I want, so I feel OK about using it. In my case, that table is called “Home Access.” This is the stage where you map the variables in the HTTP POST to the fields in your Airtable database.
Account
ISY994 can also add a custom “From” address for the notification. The “st” and “user_num” values should look familiar from the Pushover example. It’s a common format in the world of web applications.Like before, in the body of the request, everything is on one line. Your lock variables will probably be different than mine because they correspond to the ID of the specific Z-Wave device in your ISY.Go ahead and save your Network Resource and click “Save” on the main Network Resource screen too. You’re not allowed to have literal spaces in HTTP requests of this type. Network resources have many options, but for this project we’re using an HTTP POST request.
Connect to Airtable Once you’re connected to Airtable, you need to choose the database where the new records will live. The Airtable database allows me to go back in time and see when they came and went. For this project, I like the idea that I can create a permanent record of uses of the front door lock. (I’m not using the Alarm Codes table at this point.) Creating multiple tables allows me to do lookups with the data I get from the ISY and create fields that make more sense. It’s possible to generate push notifications by sending email to a custom email address, but we’ll be using an HTTP POST to generate the notification directly. While it’s possible to do notifications via text, native push notifications usually arrive faster and can be more succinct with additional formatting options.
- For this project, I created a database (called a “Base” in Airtable’s parlance) called “Home Access.” When you create a new database, you can use one of their templates as a starting point, upload a CSV file, or start from scratch.
- You’re not allowed to have literal spaces in HTTP requests of this type.
- In addition to the items in the section above, you need to have the Schlage lock added as a device to your ISY.
- It’s user friendly and powerful enough to use for production-level projects.
- Once you create a webhook for your zap, you’ll get a URL that you will enter in your ISY’s network resource.
Configure browser push notifications
If you’ve used the Airtable channel previously, this step will already be set to go. Selecting an action app Through Zapier, you can use HTTP to create a new record, update an existing record, or search for a record. Webhook test With the webhook set, now you can choose the appropriate action app. Overview of Zap steps The first step is to create a trigger using the “Webhooks” app. I use two notifications — one sends me a SMTP message, the other appends a log to a local HTML file on the ISY itself.. The entries in the “Status Code” and “Lock User” fields are blue which indicates that those data are linked to corresponding tables.
Account
- So, for example a different sender for “Lock” versus “Unlock”, then many smartphones let you set a custom message notification sound if you add each of these From addresses as a contact.
- While it’s possible to do notifications via text, native push notifications usually arrive faster and can be more succinct with additional formatting options.
- Text messages work too, but I prefer the notifications.
- Network resources have many options, but for this project we’re using an HTTP POST request.
- Connect to Airtable Once you’re connected to Airtable, you need to choose the database where the new records will live.
- Airtable’s API might be possible to access directly from the ISY, but Zapier provides a handy abstraction for doing simple things like adding records.
Airtable’s API might be possible to access directly from the ISY, but Zapier provides a handy abstraction for doing simple things like adding records. A full-screen app on your home screen with push notifications, badges and more. So I have a creaky door opening as my “Unlock” notification sound, and a door closing (“thud”)as the “Lock” sound, so I don’t even have to look at my phone to know which event just happened. The notifications will also correspond to the names you gave yours.Good luck. The “Body” section in the lower left is where you will craft your notification.The data is formatted into one line in the body of the request, and it doesn’t all show in the screenshot. I use Prowl for notifications that works similar to Pushover.
Configure browser push notifications
In the past I was doing rudimentary logging locally but have no need for it presently since there is only a few family members accessing my BE469 and Prowl notifies me when they do. Thank you for putting together this detailed roadmap on how you set up the services for logging. Select “Creater Record” Then you connect to your Airtable account.
Account
The free version of Airtable is quite robust, and I don’t expect to run into any of its limits anytime soon. If you’ve done any database development you know how solving many-to-many relationships requires lots of extra tables. After creating a free Pushover account, you’ll need to add the devices you’d like to receive notifications in the “Your Devices” section.
If I have a network hiccup, and someone’s access doesn’t get logged, I can live with that. Map to your database fields That should do it. Zapier will pull in all the relevants fields from the table.
How To: Log and notify when Schlage BE469 lock is locked or unlocked with the keypad
It’s https://aviator-game-app-download.com/ user friendly and powerful enough to use for production-level projects. As for me, I like the native notification functionality that Pushover provides. In addition to the items in the section above, you need to have the Schlage lock added as a device to your ISY.
Account
The field to the right of each of those are looked up through the linked fields. Airtable take care of the many-to-many relationships in the background gracefully. Their implementation of table relationships is especially well done.
For this project, the trigger is an HTTP POST sent by a network resource on my ISY, and the action is a connection to Airtable that creates a new record in my database with the data in the POST request. Now it’s time to create a short program to trigger the Pushover notification and Airtable record creation when the deadbolt is locked or unlocked. The purpose of this series of posts is to explain in detail how to configure notifications and logging via network resources on an ISY whenever the keypad is used to lock or unlock a Schlage Z-Wave deadbolt.
Text messages work too, but I prefer the notifications. Finally, your ISY must be able to access the Internet in order to send the HTTP requests to Zapier and Pushover. A detailed Airtable tutorial is beyond the scope of this how-to, but the basic setup will be described in that section.
If you have a tool like Insomnia or Paw, you can test whether the connection works and a record gets created before you even create the network resource on your ISY. You will need a database created in Airtable ready to receive the information from the lock and unlock events. Use whatever offset from GMT that makes sense for where you live.Save your network resource, and you should be ready to log to Airtable. Your notification should be ready to use.Now we’ll configure the network resource for the Zapier webhook.As before, pay careful attention to the options listed in my screenshot.
Each combination of a trigger and action is called a “zap.” The free plan allows only simple trigger-action combinations, but the paid plans offer multi-step zaps that can support more complex workflows. I find it more user-friendly and possessing richer integrations than IFTTT with some of the tools I use most often. I could push that kind of stuff to my Raspberry PI too. We have a cleaning service that comes to the house every couple weeks, and they use their own keycde to access the house. For a quick intro, their “12-Minute Airtable Guide” is a good place to start.
Account
Pay attention to each one because the settings have to be just right to trigger the notification.Pushover requestThe HTTP POST request consist of “Headers” and the “Body” which is the request’s payload. We want to create a new record in the database for each lock/unlock event. Webhook URL Once the webhook is created, you can send a test request, and Zapier will confirm that it was received. Once you create a webhook for your zap, you’ll get a URL that you will enter in your ISY’s network resource. For this project, I created a database (called a “Base” in Airtable’s parlance) called “Home Access.” When you create a new database, you can use one of their templates as a starting point, upload a CSV file, or start from scratch.