Best Method For Updating A Column Row by Row

Ask for Help
1

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?

2
  • 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.

1 Like