Sounds like it would. Being a programmer for a very long time, I understand feature creep though.
Speaking of feature creep...
@evcallia your app looks really cool! Another developer (Simon) recommended I ask if your app can solve the problem I'm having. I've created multiple threads/posts about this, but here's the very basic concept:
I want to control the opening/closing of two outdoor shades using the time from one specific cell in a Google Sheet as the trigger.
I have the spreadsheet built. I have existing RM rules that currently control the shades using a different approach. I feel like I'm almost to a solution. Do you know how to pull time data from a Google Sheet and parse it for use as a trigger in RM or in your app? Does your app already do that? If not, could it be added?
It's also been suggested perhaps it would be better to create an app in HE to handle everything and not connect it to a Google Sheet. That's great too, as long as it's still easy for me to enter user-observed time data into the app. (As user-observed times are entered, the time is averaged between them. As time goes on and I add more time data the shade triggering becomes more accurate. I already have data going back to late April.)
Any thoughts or suggestions are very appreciated!! Here's a link to our latest conversation if you're interested in reading more:
https://community.hubitat.com/t/re-re-release-ecowitt-and-wittboy-weather-stations-and-sensors-local/155655
Thanks in advance, cheers, Brian
haha, definitely happens, but I do think these features fit with the app.
Hey @brian17, this app does not currently pull anything from Google Sheets and it's something I likely will not add. That being said, you may still be able to use this app to fit your needs.
I could not access your link (page not found), but from the details you've given me one potential option would be
- Store the device ID (from Hubitat), schedule ID (generated in Schedule Manager) and times in google sheets
- Write a script (can probably leverage AI for this) that averages your times for each device
- Make requests from your script to this app, setting your time accordingly
A few things to note:
- You will need to do some setup in this app before you can make requests to it via your script
- Select which devices you want to use
- Add a schedule for the device(s). The schedule will need to exist before you can set times for it.
- Set the days the schedule should run and likely a few other options
- While this app does have an API that can be used by your script, it did not originally have it. It was a later feature and I haven't migrated all of the settings to have an API endpoint. Some still use built in Hubitat inputs which is why you'll need to manually configure some of the schedule before you can update it via your script.
- If you end up using the API and something is missing, I'm happy to work with you to get it added.
- Schedule times are something that has an API endpoint so you'd be able to set that via your script.
- I didn't really consider others using the API for this app so I don't have documentation around it, but again, happy to help out if you go this direction.
Hope this helps and good luck!
Release 3.3.0 - 2025-11-04
- Add advanced option: 'Enable earlier/later dual times'
- Option allows users to select two times for a single schedule and for the schedule to run at either the earlier or later of the two times
CC: @John_Land
