Hi,
I am looking to extract the time that has been logged by my team members against various projects into Google Sheets. I have one board that contains all my projects, and time is logged using the time tracker against the subitems of those projects. It looks like this:
Ideally, I would like a process to run everyday that watches whether a sub-item has been either created or the time tracker has been updated, and extract this to Google Sheets in the following format
However, it doesn’t seem it is possible to watch updates on sub items. Therefore, my plan is to list the entire boards items and filter only yesterdays sub-item updates.
The difficulty I am having is iterating the data, I have managed to iterate to the level of sub-items (see below, fairly straight forward).
For ease of testing I have been using one item ID (and group of child sub items), hence the trigger being ‘Get Item’. But I cannot figure out how to iterate this data down to the level of the individual time log.
Looking at the data which is output from the iterator, the data appears to be there to do so (Bundle # > Column Value > 3 > History). but nothing I do seems to work
I am not a Make expert, i have only ever used it for trivial home automation stuff before, So I am probably overlooking something! Any help is much appreciated, thanks 