I have a supabase collection based on a view, so it cannot be updated automatically. It is possible to update it every 5 minutes. I believe the solution involves creating a javascript and running a workflow from time to time. However, everything I saw requires the workflowid and I cannot obtain it using the methods demonstrated, my project is of the starter type.
Thank you very much in advance.
Not quite sure what you’re trying to do when you say “view”. But it sounds like a CRON job you need and something for the backend, not the “frontend” to handle which is WeWeb.
When in supabase you create a collection based on more than one table, you create a sql view and this view is accessed like any other table in supabase, however it does not have the automatic fetch functionality, so on the Web I need to update it whenever want to recognize your latest updates. That said, I need to fetch the collection every minute, and to do so I need to run a workflow that will fetch the collection for me.
Resolved in Refresh page every 10 min