The issue is regarding the google sheets script translating from the **Patient ID** to the **Internal ID**. It seems that the index is wrong. <img width="1440" alt="Screenshot 2019-12-26 at 11 47 16" src="https://user-images.githubusercontent.com/1298239/71474883-86204300-27d5-11ea-9c89-3b7e720dceaa.png">
The issue is regarding the google sheets script translating from the Patient ID to the Internal ID. It seems that the index is wrong.