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
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
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
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?
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
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
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
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!
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
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?
> 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
Hello, I hope this is clear, if not let me know
Thanks again to help me
Yeap sure, check out this base
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.