# Force / select update Big table **URL:** \ **Category:** Ask for Help\ **Created:** [May 26, 2025, 3:09pm UTC](https://community.glideapps.com/t/force-select-update-big-table/82062 "2025-05-26T15:09:14Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Danny\_Nielsen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danny_nielsen/32/61765_2.png) [@Danny\_Nielsen](https://community.glideapps.com/u/Danny_Nielsen)\ **Post date:** [May 26, 2025, 3:09pm UTC](https://community.glideapps.com/t/force-select-update-big-table/82062/1 "2025-05-26T15:09:14Z")
Hi Is there any way to “force update” a big table? Since Big tables now support Live Updates, im trying to build a “case assignment” system running in a Big table. I add cases to the table automatically, auto-prioritize, and assing cases to employees when they “pull” a new case (they press button: Get new case). We get 75k+ cases each year, so “normal” tables is only viable if i move completed cases to an archive (Big table). Have tried this before, it works, but complicates thing **alot** (statistics, reopening cases, archive-scripts…) My challenge is: Case 1 get assigned (employee email is written i column “email”). But my query trying to find the new available (unassigned) case dosn’t update, unless user refresh window (F5). I dont need my query updated all the time, i basicly only need it to update when a employee pulls a new case. **Have tried:** On pull request, before query is used to selcet next case, i have tried: 1. Opening new window with single data / lists from the Big table. 2. Opening new window with data from the query. 3. Navigating to a window with the Big table data 4. Adding 10 sec wait time after all above. But my query just wont update = so wrong case i assigned. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 26, 2025, 3:17pm UTC](https://community.glideapps.com/t/force-select-update-big-table/82062/2 "2025-05-26T15:17:32Z")
I’m not sure if it would help (and it really shouldn’t be necessary), but have you tried a Reload Query action? Other than that, it sounds like buggy behaviour to me. I’d probably reach out to support. ---
**Author:** ![Danny\_Nielsen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danny_nielsen/32/61765_2.png) [@Danny\_Nielsen](https://community.glideapps.com/u/Danny_Nielsen)\ **Post date:** [May 27, 2025, 5:27am UTC](https://community.glideapps.com/t/force-select-update-big-table/82062/3 "2025-05-27T05:27:45Z")
@Darren_Murphy you sneaky genius… works, thanks 😃 ---
**Author:** ![Danny\_Nielsen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danny_nielsen/32/61765_2.png) [@Danny\_Nielsen](https://community.glideapps.com/u/Danny_Nielsen)\ **Post date:** [May 27, 2025, 6:38am UTC](https://community.glideapps.com/t/force-select-update-big-table/82062/4 "2025-05-27T06:38:09Z")
I woke up with an idea. I could have a “normal” table called “Assignment” with only three columns: Row-ID of cases not assigned | Priority | Relate to Case I would add rows to Assignment table via API (script in background i got running anyway), and run the whole assinment workflow of this table. Think this would be more reliable / fast then running assinment in big table with 100K rows? ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [June 3, 2025, 6:39am UTC](https://community.glideapps.com/t/force-select-update-big-table/82062/5 "2025-06-03T06:39:07Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.