Populating values in newly added column for existing rows

[Mayur_RJ]

Added a new column(Not Virtual) to the table with existing entries, the column has an app formula which uses the value of one of the columns. If i make a new entry it is working. But how do i populate to the pre-existing entries.
Any help is appreciated.

Thanks in advance!

[Lynn]

Hi @Mayur_RJ
What is the formula you are using?

[Steve]

Mayur_RJ:

But how do i populate to the pre-existing entries.

There’s no trivial way to do it. You’ll probably want to use actions to do it: one that identifies the rows that need to be updated, and another that updates them. If there a lot of rows to update (say, more than 100), your actions should be run as a report.

See also:

help.appsheet.com

Changing Data from a Workflow Rule or Scheduled Report

How to change data in your app on a schedule or when some event happens.

[Mayur_RJ]

Thank you Steve! That is a workable solution in my scenario.

[Lynn]

Or you could do it in the sheet and copy paste values.