Dear HA community,
Please may I draw upon your knowledge and experience. I have surfed the forums here and elsewhere and have been unable to figure out the solution or determine whether it is possible. Here is a bit of background before I describe what I am trying to achieve.
Background:
We have a few cats and one of them got very ill in the not too distant past. Fortunately said cat is still with us and is now fit and healthy. One of the lessons learned from our experience was that we could spot early signs of health issues by doing a weekly weigh-in to identify any weight loss.
I have successfully set up a simple automation to send a notification to our mobile phones via the HA app to remind us to weigh the cats. This is great but I want to take it one step further.
Problem:
The excel spreadsheet in which we keep a track of weights is saved on a shared folder on a Synology NAS within the local network. What I would like to do is for the notification to have a button which allows me to directly open up and edit the excel file on my mobile phone. Is this possible? If so, how do I do it and what code in the configuration.yaml file etc is required?
Looking through the forums, I can see that mounting NAS folders is possible but this appears to be for media files only (ie via the Media menu on the lovelace UI). Unfortunately it appears this does not work for excel files, at least not for me. Even it it were possible, could I write to that file through the HA interface?
Thanks for your time.