Can I reset a bunch of rows with an action?

AppSheet AppSheet Q&A
,
1

Hi community

I have 2 tables, one with spes and the other with what really happens when combining different ingredients into a formula. In the second table i have a lookup that goes to table 1 and fetches the specs for the formula I am making. Now when I run over spec, as in the example 1.9%, the easiest way to fix it is to multiply the original formula by the factor of the mistake (101.9 % in this case) and add the differences.

CarlosCh1_0-1726698158455.png
CarlosCh1_0-1726698158455.png411×504 7.41 KB

My question is: How can I rewrite the whole specs in my second table? The most logical thing seems to create an action that multiplies everything by 1.019 but, since the records are written in a Google spreadsheet, I understand that they do not overwrite. Do I need to make a virtual column instead?

I appreciate any insightor help

Carlos

2

If you mean you want to overwrite the ORIGINAL column in your third table, you sure can do it because the column is not a key column.

But why do you want to overwrite them? Why not just keep all of the columns? ORIGINAL, PROPORTION (% value), RECALCULATED and DIFFERENCE?

I would create RECALCULATED and DIFFERENCE as VC because you can see them update ‘real time’ as you enter ORIGINAL.

1 Like