Conditional action to update record meet condition from finded record

[Sylvain_Dionne]

Hello, my goal is create an automation that update all record meet record update.
see atached file
when I change the value of record indicated from 99 to 1, I want all others records of same finish and same date chage to 1 too.

Thanks

Sylvain

[TheTimeSavingCo]

I think the cleanest way to do this is via an automation and a script

There are probably alternatives to do it without a script, but they'd be very complicated, time consuming to set up, and fragile

[Sylvain_Dionne]

Thanks for your answer, but I have no experience with script.
Can you help me, or tell me how to begin, maybe some videos tutorial, or other support?

[TheTimeSavingCo]

You could try CodeAcademy's JavaScript course if you'd like. Without any prior experience this might be pretty difficult though

May I know if you're on a Pro account? Asking us only Pro accounts can run scripts via an automation.  If you are I can see if I can put something together for you

[Sylvain_Dionne]

Yes I am on Pro Account.

Thanks

[TheTimeSavingCo · Accepted solution]

Here, this should do what you're looking for I think

[Sylvain_Dionne]

Hello, thanks to take to answer my question on this january 1st.
I can't check that today, but for sure first thing tomorrow I will try your script.
Happy New year

[Sylvain_Dionne]

Hello Adam, I tested it and it work exactly the way I was looking for. The only thing, it is a little bit slow, do you have an idea to speedup the process?
Thanks again!

[Sylvain_Dionne]

Hello, your solution work fine.
But I had to changed my structure, indeed the finish information is from a lookup field, I changed the variable Finish to Lookupfiled.value, but now the script do not work.
I hope you can hep me again
Thanks

[TheTimeSavingCo]

> The only thing, it is a little bit slow, do you have an idea to speedup the process?
I don't think so I'm afraid; I believe that's just how long automations take to trigger

> I hope you can hep me again
Could you post a screenshot of your new base structure please?