
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 16, 2024 06:40 AM
Hi everyone. I am trying to set up an automation where when a diagnosis field for a trip in one table is updated it finds the corresponding person (that is connected) in another table and updates a diagnosis field in that table where only different diagnosis is entered. Attached is what I have started. It doesn't run. I tried adding a find records step but couldn't configure the condition (screen grab also attached).
Suggestions please!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 20, 2024 07:13 AM
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

- « Previous
-
- 1
- 2
- Next »