Skip to main content
Solved

Conditional action to update record meet condition from finded record


Forum|alt.badge.img+5

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

Best answer by TheTimeSavingCo

Sylvain_Dionne wrote:

Yes I am on Pro Account.

Thanks


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

View original
Did this topic help you find an answer to your question?

12 replies

TheTimeSavingCo
Forum|alt.badge.img+28

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


Forum|alt.badge.img+5
  • Author
  • Known Participant
  • 14 replies
  • December 29, 2022
TheTimeSavingCo wrote:

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


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
Forum|alt.badge.img+28
Sylvain_Dionne wrote:

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?


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


Forum|alt.badge.img+5
  • Author
  • Known Participant
  • 14 replies
  • December 30, 2022
TheTimeSavingCo wrote:

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


Yes I am on Pro Account.

Thanks


TheTimeSavingCo
Forum|alt.badge.img+28
Sylvain_Dionne wrote:

Yes I am on Pro Account.

Thanks


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


Forum|alt.badge.img+5
  • Author
  • Known Participant
  • 14 replies
  • January 1, 2023
TheTimeSavingCo wrote:

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


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


Forum|alt.badge.img+5
  • Author
  • Known Participant
  • 14 replies
  • January 2, 2023
Sylvain_Dionne wrote:

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


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!


Forum|alt.badge.img+5
  • Author
  • Known Participant
  • 14 replies
  • January 21, 2023
TheTimeSavingCo wrote:

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


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
Forum|alt.badge.img+28
Sylvain_Dionne wrote:

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!


> 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? 


Forum|alt.badge.img+5
  • Author
  • Known Participant
  • 14 replies
  • January 22, 2023
TheTimeSavingCo wrote:

> 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? 


Hello, I hope this is clear, if not let me know
Thanks again to help me


TheTimeSavingCo
Forum|alt.badge.img+28
Sylvain_Dionne wrote:

Hello, I hope this is clear, if not let me know
Thanks again to help me


Yeap sure, check out this base


Forum|alt.badge.img+5
  • Author
  • Known Participant
  • 14 replies
  • January 25, 2023
TheTimeSavingCo wrote:

Yeap sure, check out this base


I had tried to use directly the linked field, but I was missing the function .toString()
Thanks again form your help and your time


Reply