May 24, 2022 10:49 AM
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:
May 24, 2022 11:08 AM
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.
May 24, 2022 11:26 AM
Tried replacing with “nothing”, but all I get are errors and invalid inputs :confused:
May 24, 2022 11:37 AM
:slightly_smiling_face: My apologies. I did not mean the word nothing. I mean updating the record with nothing.
In my screenshot. When Estimated Points = 4, deleted what ever is in Potential (or replace it with nothing)
May 24, 2022 11:41 AM
Ye ye ye, understood and tried, but no luck :slightly_smiling_face:
May 24, 2022 11:42 AM
Can you post a screenshot of the error and your setup? Specifically step 4
May 24, 2022 11:50 AM
May 24, 2022 01:49 PM
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.