Accepted Solutions
Hello Debbie,
As far as i understand your problem, you should no link table "Passengers" to table "Diagnosis directory".
As Adam said, you should define a rollup field in table passengers as such:
I copied your base and modified the Flight requests in order to have 3 different diagnosis on 3 different lines for Bobba Flett, here is the result in passengers tables:
If needed, you can also filter this "diagnoses" rollup field to show only diagnoses for which status is either "In progress" or "Booked" in "flight requests" table:
Regards,
Pascal
Hi,
In Find Records you should move slider under condition to the right and choose (i suppose Dynamic)
then select field according to your needs
Hello,
I am not sure that I completly understood your problem, but here is something that I tried:
This table "Trig Diagnosis" is linked to the table "Passengers" with the field "Patient".
I added a formula field "Passenger" that copies data for the linked field:
My table Passenger is the following:
Field "Test" is there to test the automation result.
Automation is set up as follows:
It is triggered when field "Diagnosis" is updated on table "Trip diagnosis"
I then have a "Find records" action to find related record in table "Passenger":
Two condition:
- Condition 1 using the formula field to match Passenger primary key field
- Condition 2 to retrieve the record only if Diagnosis is different
Next action is a repeating group set on the list of records obtained from the "find records" action to update the record in table passenger:
Where the record id comes from the current item of the list:
Regards,
Pascal
Pascal,
Thanks for your thoughtful reply. I was not able to figure out how to do all you suggested. I will take you through more detail about my tables and need and what I have attempted in automations and maybe you can help me figure out where I went wrong.
This shows the relevant fields in a large table. A flight request is populated from a form through Zapier. We are choosing a diagnosis from our diagnosis table and it is stored in the trip diagnosis. I created the Passenger field that you requested and then pulled in the Patient Diagnosis as a look up.
The Patient Diagnosis field is the field we are trying to update with the trip diagnosis if it isn't already there. We need to do this to be able to track what diagnosis a patient flew for as well as all the diagnosis a patient has.
That Patient diagnosis field is linked to the same directory as the trip diagnosis field.
It's not sending an error but I couldn't figure out how you got name and I didn't know how to do the repeating action.
It seems like you're trying to consolidate all the diagnoses from each of the trips a patient has been on, is that right? If so, would this work?
Link to base
---
Or is it that you're trying to track the diagnosis a patient went on a specific trip for, and then want to also track what they ended up diagnosed with during that trip?
Hello Debbie,
Adam's answer may be the solution that you are looking for, dimiss this reply if it is the case.
Here is a screen capture for adding the "repeat" action:
Once added, you click on "Select input list":
And you select your "Find records" action and "use as a list" option:
Concerning the "name" option, it depends on field type. I guess that we did not set the same type for Diagnosis field.
Regards,
Pascal
Hmm, it sounds like a lookup field would work fine? The diagnosis the patient is seeking treatment for on a specific flight is kept in the "Flight Requests (Trips)" table, while the "Passengers" table would contain all the diagnoses they had for each trip they had?
Flight Requests (Trips):
Passengers:
