Project is about organizing tiktok video performance.
I have a view on a different tab that filters by date(weekly) and sort by number of views.
I wanted to create a tab that copies top 5 videos on this view weekly. I figured out the trigger on automation to run weekly. Filter on the view is also adjust weekly. The problem is I don't know how to copy only the top 5 videos. I'm not sure if this is possible.
Please share more details about the design of your base and tables. If you can share screenshots (even edited to hide private info), that would be extremely helpful. Knowing how all of the pieces tie together will make it a lot easier to provide assistance.
On this tab, I have a view that sorts the videos base on their number of views. Every week, I wanted to copy the top 5 of this view to another tab where I can add more info, analyze and plan more of it.