# Update columns of a Table

**URL:** <https://community.tulip.co/t/update-columns-of-a-table/1223>\
**Category:** General\
**Created:** [November 18, 2020, 1:55pm UTC](https://community.tulip.co/t/update-columns-of-a-table/1223 "2020-11-18T13:55:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![katha](https://avatars.discourse-cdn.com/v4/letter/k/6bbea6/32.png) [@katha](https://community.tulip.co/u/katha)\
**Post date:** [November 18, 2020, 1:55pm UTC](https://community.tulip.co/t/update-columns-of-a-table/1223/1 "2020-11-18T13:55:39Z")

</div>

Hello,  
I am stuck: I want to update the column of all records in a Table when my App starts, so I can’t use a normal trigger. I want create a function which updates the column of every record. I have two tables and want to store the sum of the kg from the storage in the Input material- table. But the right sum should be stored in the correct record where the materials match. Does anyone have an idea?

 ![sum quantity 2](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/739521af890cafa18b1935cbb25cd014b386229b.png)  
 ![foto2](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/89e52b3098e5d47fd5d749d4c21af0182dcf8825.png)

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [November 18, 2020, 10:05pm UTC](https://community.tulip.co/t/update-columns-of-a-table/1223/2 "2020-11-18T22:05:15Z")

</div>

hello @katha!!

so to address your first point, you can actually add a trigger on **App Started** :

 ![Screen Shot 1](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/338bdbe08bf699f56a49ad3bc6e4499fce7385ce.jpeg)

regarding updating the records in the Input Material Table: you can create multiple Table Records to the Input Table, and then update them on App Start.

 ![Screen Shot 2](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/17e2a66383b7fbe3390c375cbc413267e0c5d87e.jpeg)

would that work for you??

---

<div class="post-metadata">

**Author:** ![katha](https://avatars.discourse-cdn.com/v4/letter/k/6bbea6/32.png) [@katha](https://community.tulip.co/u/katha)\
**Post date:** [November 19, 2020, 12:30pm UTC](https://community.tulip.co/t/update-columns-of-a-table/1223/3 "2020-11-19T12:30:25Z")

</div>

@gio  
it should be variable, so many placeholders wouldn’t be the best solution. Is there a way where I can add a function like where Inputmaterial.ID=Storage.Material number then SUM(Quantity) ?  
Thanks

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [November 19, 2020, 12:44pm UTC](https://community.tulip.co/t/update-columns-of-a-table/1223/4 "2020-11-19T12:44:59Z")

</div>

hello @katha, that is currently the fastest way to implement what you’re describing based on what I’m understanding.

that being said, Table Queries will be released soon (more info.: [Multiple Sorts in Tables](https://community.tulip.co/t/multiple-sorts-in-tables/549/3)) and will help with this use case. keep an eye out in the Announcements category!!