Update all the same request

Ask for Help
1

I have a case where If request 1 is Completed, the request inside the same case column will also change to Completed.
Any suggestions for implementing this case? Thank you.

No Same Case Status Final Status
1 2, 4, 5 Completed Completed
2 New Completed
3 New New
4 New Completed
5 New Completed
6 New New
2
  • Create an array from your Same Case column using a Split Text column
  • Create a relation column that matches the “No” column with the Split Text column
  • Use a Lookup column to fetch the Status from the related Case via the relation
  • Use an if-then-else column to determine the Final Status
    – If sameStatus is not empty, then sameStatus
    – Else Status

CleanShot 2024-09-24 at 17.20.50@2x
CleanShot 2024-09-24 at 17.20.50@2x1350Ă—478 56.4 KB

3

Hello @Darren_Murphy , can I take a look at the details of the relSame column? Because the result that I got is quite different from yours. Is your relation column checked the match multiple?

4

Here is a screen shot, but it’s showing the wrong thing in the “Matches the value in:” box because of a Glide bug, so ignore that - it should be splitSame. And no, it should not be a multiple relation.

CleanShot 2024-09-24 at 17.59.22@2x
CleanShot 2024-09-24 at 17.59.22@2x828Ă—624 40.9 KB

5

Okay, I think I already got the expected result. Thank you so much for the help @Darren_Murphy !