Hi, I cannot get this to work.
I’ve saved a copy, given all auth as well connected to the API but no data is coming.
Thank you,
Open the file and go to Extensions > Macros > ImportintervalsICU and it will pull through the data from the API
Ahh I think its because the code/ formula is not copied across from the original Google Sheets file that @Aindriu produced - please copy it across from there into your file and it should work
1 Like
Specifically you need to copy the formulae for columns A to E on the HRV-calc sheet.
I tried to set up a custom label with the date for each point as suggested earlier in the thread, but I haven’t (yet) figured out how to do this in Google spreadsheets.
Robert
2 Likes
only after he puts the sheet back 
HRV Guided Training (Shared) - Planilhas Google
This version does not have the colored chart.
Also it does not have dates:
thank you
I know…
Copy the formulas from that version into a saved version of the one with the coloured chart… Its what others have done when they came across the same problem
Hello to all,
I’m trying google sheets but I can’t see the graph with the colours and data, I only see a blank sheet, I haven’t been able to find out how to do it, if someone can tell me how to do it.
Thanks
@Olly_Thomas file has an issue. The formula’s on the HRV clac sheet are missing. If you have no clue on how this all works, have a a little patience until a corrected version is posted.
If you do know how to handle this, just copy the formula’s from @Aindriu 's file in the same columns on Olly’s sheet.
This is a work of multiple members each doing the part they have knowledge on.
4 Likes
Replying to this post,specifically to keep Alan Couzens, Python and the below podcast together.
3 Likes
Can you post the link to the colour chart version? Thanks
Sorry work is manic at the moment and I need to update to slightly - bear with me I will do it ASAP. Thanks!
1 Like
hi,
Works using a computer, but how can I do this using an iOS device?
Tks,
1 Like
Still waiting on that as well. Browser based or iPad for me.
Well,
the sheet is there fully working on desktop and 90% on mobile but we don’t have the knowledge on Google Sheets to automatically refresh the data…
Someone else will have to come up with a solution for that. Just like anybody else we have limited time available and need to respect/protect our own priorities.
I thought the best way to keep things moving forward was to post it as it is and count on another helpful soul to solve that remaining issue.
6 Likes
appreciate your efforts.
tks,
Aagggghh
I was messing around with this this morning trying to get a copy I made of v1.5 to pull in custom wellness fields. I ended up having to delete the v1.5 file and now upon redownloading I cannot get it to work at all. Any help would be appreciated
I keep getting an access denied error.
Continually get the message below
I’ve deleted, redownloaded, closed, opened, done everything I can think of to get it working again but I can’t
In the data source settings dialog - Global Permissions - click on Edit permissions and re-enter Basic - user - Api_key
1 Like