# About the detailed calculations for Updates **URL:** \ **Category:** Ask for Help\ **Created:** [October 13, 2025, 2:29pm UTC](https://community.glideapps.com/t/about-the-detailed-calculations-for-updates/84876 "2025-10-13T14:29:58Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Jonathan\_Chen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathan_chen/32/92302_2.png) [@Jonathan\_Chen](https://community.glideapps.com/u/Jonathan_Chen)\ **Post date:** [October 13, 2025, 2:29pm UTC](https://community.glideapps.com/t/about-the-detailed-calculations-for-updates/84876/1 "2025-10-13T14:29:58Z")
I’d like to understand the detailed calculations for Updates. Suppose I’m using an app to implement the Bill of Materials feature. All functionality uses a Glide table, with no external data updates. One product has 47 semi-finished items. Does this mean that every time I restock this product, I’ll consume 47 Updates? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 13, 2025, 3:00pm UTC](https://community.glideapps.com/t/about-the-detailed-calculations-for-updates/84876/2 "2025-10-13T15:00:50Z")
That’s a loaded question because it depends on many factors. For your situation, it could be zero updates or several, but it depends on how you are updating the data. Generally with a Glide table you would not incur updates, but if you are using certain workflows, then it would. Workflows will tell you if an action incurs updates and how many per run. > **[Updates | Glide Docs](https://www.glideapps.com/docs/reference/account/updates)** > > An explanation of updates and how they relate to billing. ---
**Author:** ![Jonathan\_Chen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathan_chen/32/92302_2.png) [@Jonathan\_Chen](https://community.glideapps.com/u/Jonathan_Chen)\ **Post date:** [October 14, 2025, 2:52am UTC](https://community.glideapps.com/t/about-the-detailed-calculations-for-updates/84876/3 "2025-10-14T02:52:31Z")
Thank you for your reply! I need to use the Loop function in the work flow to accomplish this. If I need to deduct the quantity of 47 semi-finished products, that means I’ll need to use the Set Column Value function 47 times. I see in the image that each execution consumes one update. ![CleanShot_2025-01-06_at_1_](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/97b207a88a897cdd8b8d9732a4617ed3af815474.webp) Does this mean that each execution of the Loop function consumes 47 updates? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 14, 2025, 3:04am UTC](https://community.glideapps.com/t/about-the-detailed-calculations-for-updates/84876/4 "2025-10-14T03:04:43Z")
Yes, I believe that would be 47 updates, and actually more with the additional actions that incur updates as well. I think looping and performing IO that many times seems extreme. I would reconsider your approach and maybe use a relation or query plus a Rollup to get the number of items. Then you only need to increment once with 47 instead of 47 times with one. ---
**Author:** ![Jonathan\_Chen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathan_chen/32/92302_2.png) [@Jonathan\_Chen](https://community.glideapps.com/u/Jonathan_Chen)\ **Post date:** [October 14, 2025, 3:21am UTC](https://community.glideapps.com/t/about-the-detailed-calculations-for-updates/84876/5 "2025-10-14T03:21:04Z")
Thank you for your reply! I need to do this calculation because I need to calculate the exact quantity of each semi-finished product in detail. For example, after I process product A, I consume semi-finished products B, C, and D. Of course, I’ve also tried the relation and rollup you mentioned, but it doesn’t allow me to deduct the inventory of semi-finished products B, C, and D by clicking the replenish button for product A once. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 14, 2025, 11:44pm UTC](https://community.glideapps.com/t/about-the-detailed-calculations-for-updates/84876/6 "2025-10-14T23:44:42Z")
Do you mean there isn’t a way to establish a relationship between product A and its child products B, C and D when you do the relation - rollup? This might be a long con, but I think you can: - Have a table to establish the relationship between parent and children products (e.g: 1 product A = 3 product C). - Create a JSON for that relationship in said table. - When you add a product A, you would have a multi relation to that table, and get back a JSON array of those “relationships”. - From that, you can use JavaScript to return the final quantity of each child product based on product A’s quantity. - In the children product’s table, establish a multi relation to all records where it would appear in the table where you log product A’s. - Get back a JSON array of all children product calculations, and use Query JSON to sum all quantities matching the children product. ---
**Author:** ![Jonathan\_Chen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathan_chen/32/92302_2.png) [@Jonathan\_Chen](https://community.glideapps.com/u/Jonathan_Chen)\ **Post date:** [October 16, 2025, 2:38pm UTC](https://community.glideapps.com/t/about-the-detailed-calculations-for-updates/84876/7 "2025-10-16T14:38:22Z")
Hi! Thanks for your reply! I appreciate your suggestion! I’ll give it a try! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 16, 2025, 11:48pm UTC](https://community.glideapps.com/t/about-the-detailed-calculations-for-updates/84876/8 "2025-10-16T23:48:52Z")
Hopefully it helps your case! It’s a complex setup, let me know if you have any questions.