Firstly, @appsheet. Thank you for supporting those of us who are building covid-related applications.
I’ve read through so many different responses on how to update a table if another table is changed but I can’t seem to find a solution that works 100% of the time.
My question is pretty simple I think:
We have 2 main tables - visits and cases.
- A visit includes conversations that we have with patients where they complain of symptoms. The 5 visit statuses are: Non-Covid, Suspected, Active, Recovered, Death
- The cases only have 2 statuses: Open or Closed
The visit table can have multiple visits referencing a single case.
The case table only references the latest visit.
Basically, when we log a visit as “Suspected” or “Active”, we want the case status to be “Open”. Otherwise we want the case status to be “Closed”. (We typically follow up for 14 days to make sure these people are ok)
I’ve tried both of these methods:
- On the visit form submission, I changed the Behavior: Event Actions to be Execute an action on a set of rows. So for a record on the visit table, I update the case status on the case table.
- I have an automation for every added and updated visit, the case status updates.
However, when I look at my data, both of these implementations of this action only updates 80% of case statuses. There are 20% of the case statuses that do not update. Therefore, I can’t tell if this is a bug or if I am not using best practices to accomplish this task. Is there a more reliable way to do this?
Thanks in advance for your help.