If I understand correctly, you are operating at the Admissions table level - inserting an Admissions record and then using a workflow to update the Patient record.
First I would recommend flipping this. Look up the Patient record first and then adding the Admission record to that Patient. As you said each Patient has a list of Admissions. The admissions should be attached as child records to the Patient row using AppSheet’s Parent/Child feature “Is Part Of” switch that creates this link for you. Then you can automatically update the Patient status based on the entered admission record. No workflow will be needed and the app is more efficient.
You can still have an Admissions table for viewing all patient admissions.
If my understanding of your request is correct and you still wish proceed with the current design, you will need to create what I refer to as a “bridge” action. You need to bridge between the entered Admission row and the desired Patient record so you can update the Patient. To do this:
1). Create an action for Admissions called from the workflow and defined as “execute an action on a set of rows”.
2). Se the Referenced Table to Patients
3). Set the Referenced Rows = to LIST([Patient]). Note: this assumes that the Patient column on your Admission table is defined as a Ref type column.
4) Set the the Reference Action to that action you have create to update the Patient row.
I hope this helps. Please ask if you have questions.
LinkedIn
Twitter
