630
edits
Changes
Jump to navigation
Jump to search
Line 44:
Line 44: − + + + + + + + +
add ifttt workaround
As a result, every time I double click the Flic button, the value in cell N3 automatically increments upwards for a given day, before jumping back to zero at midnight. With this automated counting in the Google Sheet in place I then added a monitoring of this particular cell (N3) to IFTTT, and every change in the cell's value will trigger a notification on my phone/watch through the IFTTT app that informs me about today's counter status. IFTTT does not monitor the data in real-time, but rather every 5 minutes, which seems timely enough for now.
As a result, every time I double click the Flic button, the value in cell N3 automatically increments upwards for a given day, before jumping back to zero at midnight. With this automated counting in the Google Sheet in place I then added a monitoring of this particular cell (N3) to IFTTT, and every change in the cell's value will trigger a notification on my phone/watch through the IFTTT app that informs me about today's counter status. IFTTT does not monitor the data in real-time, but rather every 5 minutes, which seems timely enough for now.
In a few weeks it will then be time to check the the data and compare it to the baseline to see if the intervention made any difference.
In a few weeks it will then be time to check the the data and compare it to the baseline to see if the intervention made any difference.
'''Update 2022-08-17''': Unfortunately the regular monitoring that IFTTT provides for Google Sheets seems not to work reliably, leading to notifications rarely being sent. My workaround for this was to slightly change my IFTTT setup using the "webhooks" integration:
# I expanded the IFTTT action that is taken when clicking the Flic button is pressed. After writing the data to the Google Sheet it now also uses the webhook integration to send a web-request to IFTTT itself. This webhook can than be used to trigger a second action
# The second IFTTT action listens for activity on the webhook that fired in step 1. When triggered it manually requests the current value of the cell in the Google Sheet as outlined above and then delivers the value as a rich notification to my phone/watch.
This approach is pretty rigged together, but so far seems to work reliable and didn't require any programming.
== References ==
== References ==