# Best Method For Updating A Column Row by Row

**URL:** <https://community.glideapps.com/t/best-method-for-updating-a-column-row-by-row/81159>\
**Category:** Ask for Help\
**Created:** [April 3, 2025, 3:04pm UTC](https://community.glideapps.com/t/best-method-for-updating-a-column-row-by-row/81159 "2025-04-03T15:04:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\
**Post date:** [April 3, 2025, 3:04pm UTC](https://community.glideapps.com/t/best-method-for-updating-a-column-row-by-row/81159/1 "2025-04-03T15:04:02Z")

</div>

So in this example we have rows with different products situated in a normal Glide Table.

Their current price is X for April which is a column named “Price”, however in May each products price will change to Y which is a column named “Future Price”.

I’ve always found it difficult changing multiple rows at once, what would be the best method that if scheduled for the 1st of May (whether the scheduling is in Make or using Glide’s workflow feature) the column “Price” would automatically be populated with it’s relevant row’s “Future Price”, and how would I go about this?

---

<div class="post-metadata">

**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:** [April 4, 2025, 12:08am UTC](https://community.glideapps.com/t/best-method-for-updating-a-column-row-by-row/81159/2 "2025-04-04T00:08:52Z")

</div>

- Add a scheduled workflow that runs on the 1st day every month.
- Loop through your products table.
- Set the “Future Price” column value to the “Price” column.

During the month, you can change the “Future Price” value as needed, and it will be set to “Price” again on the 1st of next month.