# Supabase collection refresh with timer

**URL:** <https://community.weweb.io/t/supabase-collection-refresh-with-timer/7469>\
**Category:** Ask us anything\
**Created:** [March 8, 2024, 1:58pm UTC](https://community.weweb.io/t/supabase-collection-refresh-with-timer/7469 "2024-03-08T13:58:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dougst](https://avatars.discourse-cdn.com/v4/letter/d/c37758/32.png) [@dougst](https://community.weweb.io/u/dougst)\
**Post date:** [March 8, 2024, 1:58pm UTC](https://community.weweb.io/t/supabase-collection-refresh-with-timer/7469/1 "2024-03-08T13:58:20Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![what.gift](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/what.gift/32/8069_2.png) [@what.gift](https://community.weweb.io/u/what.gift)\
**Post date:** [March 11, 2024, 10:01pm UTC](https://community.weweb.io/t/supabase-collection-refresh-with-timer/7469/2 "2024-03-11T22:01:28Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![dougst](https://avatars.discourse-cdn.com/v4/letter/d/c37758/32.png) [@dougst](https://community.weweb.io/u/dougst)\
**Post date:** [March 12, 2024, 11:46am UTC](https://community.weweb.io/t/supabase-collection-refresh-with-timer/7469/3 "2024-03-12T11:46:52Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![dougst](https://avatars.discourse-cdn.com/v4/letter/d/c37758/32.png) [@dougst](https://community.weweb.io/u/dougst)\
**Post date:** [March 12, 2024, 12:49pm UTC](https://community.weweb.io/t/supabase-collection-refresh-with-timer/7469/4 "2024-03-12T12:49:42Z")

</div>

Resolved in [Refresh page every 10 min](https://community.weweb.io/t/refresh-page-every-10-min/3151)