Hello guys, sorry for bothering you, but I have a problem, and it seems that I can’t find the solution, so here I am.
So automation goes like this:
Its not a bother to message us here we are all happy to help.
It sounds like you are on the right track. Instead of thinking “delete” think ‘replace with nothing’. I think you just need to build a few more automations to handle the rest of the scenarios. Try breaking them up into smaller process. Once you get your desired result you can look to combine them.
That is helpful. I started to plug this in and it made me read your request a little more. You will need a way to find records 1 and 2, based on some parameter but with this set up there isn’t much to work with. Before we go too far down this, can you help me understand the logic of having a Name field, and then a look up to another record. would it make sense for the Name column to be a Job or a Date? Then have the team driver linked record allow multiple values. If more than 1 set the 1/2 to team and if 1 set the 1/2 to Solo.
I wonder what happens when we have more than John and Mike to account for or any other combination of people.