I'm having trouble with an automation that I want to add a step to. Here's a brief video showing the automation in its current state, which takes place when a new record is added to the Discharge table:
https://drive.google.com/file/d/1YTmptnHmO-E7v8rAI244oRdc9ayU5VOh/view?usp=sharing
What currently happens is, when a patient is flagged as discharged, it triggers a message to be sent to an internal Google Chat view webhook. The next step checks to see if there are any Follow Up instructions for the TCM team (transitional care management). If the Follow Up field is not blank, a subsequent message is sent via webhook to another Google Chat to the TCM team.
I need to add another step that sets the value of [Will Not See] to blank once a patient is discharged. This column exists in the Patient Population table and NOT the Discharge table. I have tried a few different things but keep coming up with errors. It seems that since this automation starts with the Discharged table, all subsequent actions must take place on the Discharged table, with the exception of the chatbot/webhook parts, as they allow me to specify a table.
What am i doing wrong here?
LinkedIn
Twitter
