...
Run the script with the desired user id and dates.
Open a new Occupation Report Template sheet, and rename it as it suits best.
Click on the
[Select this cell and import the .csv file]and import the .csv file obtained in step 1. Make sure to click on the Replace date at selected cell option while importing the file.%2017.43.20.png?version=1&modificationDate=1579131820170&cacheVersion=1&api=v2&width=659)
%2017.43.20.png?version=1&modificationDate=1579131820170&cacheVersion=1&api=v2&width=652)
Merge the cells of the title and adjust the format to taste.
The final file should look like this:
...
Some Notes:
As a good practice, it is advised to declare your start date on Monday, and your end date on Sunday. It is not required, but it will make your report more concise and clear.
Each EHR has its own time interval limits. Make sure not to request bigger intervals than the EHR’s limits. If needed, you can run two times the script with different time intervals and join them together.