How to Update a Column for Multiple Rows Automatically ?

[Keshava_p]

I have a table with around 60,000 rows, and I need to calculate and update a weighted score based on the values of two columns: Supplier Spend and Total Impact Supplier Spend.

I’m using the following formula in the Weighted Score column:

IF([SUPPLIER_SPEND]="error", "",IF(ISNOTBLANK([SUPPLIER_SPEND]),SWITCH(TRUE,[SUPPLIER_SPEND]<=5,1,[SUPPLIER_SPEND]<=10,2,[SUPPLIER_SPEND]<=15,3,[SUPPLIER_SPEND]<=20,4,5)*[TOT_IMPACT_SUPPLIER_SPEND],"n/a"))

The issue is that the values in the Weighted Score column only update when I open a row and click the edit button.

How can I apply this calculation to all rows at once without manually editing each row? Is there a way to trigger bulk updates automatically in AppSheet? 

I don't want to create virtual column for this, as it is getting a performance issue.

Any suggestions would be greatly appreciated!

[CleanSheets]

Hi,

I have a column  on all my tables called [Auto Sync]. It's a number and the initial value is zero. It's hidden from view.

Then when I have the need for the formula's in the row to be updated I invoke something that increments the number. I.e. [Auto Sync] field will equal: [Auto Sync] + 1.

For 60K rows you will want to do this as a bot. If the bot can't handle updating all those rows, then call an action from the bot.

I don't have a clear enough picture of when you want it to calc, but it could be when the before and the after of the fields you've mentioned are not the same, then you can call the [auto syc] for whatever table needs the update.

Hope that helps.

As a side note, it would be nice if appsheet had a native way of invoking the updates for a table so I don't have to config this all the time. Because actual rows are the way to go instead of vcs, as you madde mention of ( and vary rearly do I think anyone actually needs a vc if they think about things differently).

Cheers