Hi thanulee,
I would typically have two animations and edit it. Close up to the bowl when it is being filled, cut, medium close-up when they start to fly out. This saves time and is more effective, as the start of the flying out will be emphasized with the edit. Good editing is invisible and leaves the impression to have seen it in one flow. Certainly nothing new to you, but I write in a forum with people of various background and experience.
I see it often that there is a wish to do it all in a “one take”, as a film-maker I really don’t share any passion for this limiting idea.
Anyway, here is a set up that could work as one-take.
Scene file
https://www.amazon.com/clouddrive/share/YAK0iZhgtWnexaF0rH62wa0UZy6b1yJw6OhpMOaCoDN
The transition might need some fine tuning, but the motion blur will undoubtedly help to cover that up.
Anyway, I have another idea, but it might sound a little bit abstract. Please have first a look at the scene below:
https://www.amazon.com/clouddrive/share/lpJjaFY8sM4Q3JjT2ulFYAMIm6xuv8Zcqh89UbmAu70
The idea is to trace every single clone. When the clones reached their rest position, the Tracer is moved and creates so a multi-traced-path of the setup.
Set the Animation> Play-mode to Simple, then play from zero to the last frame. Copy the Tracer and make the copy editable [C]
Now you can position that spline (multi-segment) and use it as Object in a cloner.
Set the animation inside of the Cloner and the keyframes should be linear, not spline, we want an exact frame copy as it was calculated.
Now comes the fun part, the Cloner allows now for any Effector influences, and the Spline can be “modeled” with the Magnet tool. This gives you all you need to Art direct the whole shot, and it is in one take if needed.
Enjoy
https://www.amazon.com/clouddrive/share/wjwgYpjomxOeP9vg5dxRxWYrDJd81vtffe7cIGWDci1