Bulk Table Edit

[Paul_Danyliuk]

Hey! This thread should be relevant:

ModifyRows should allow CurrentValue to modify rows with different values

Currently, ModifyRows does not set CurrentValue to each row as it goes by. This is unfortunate, because if I want to make, say, a button that adds 1 to every value in a column, I want to put something in this box: [image] Say: [image] But clicking this button does not do anything like what is expected. Score finds the entire column, so Score+1 is, apparently, [...]1, where ... are the values of the column. Trying to do it with CurrentValue explicitly doesn’t work: [image] [image] I don’t …

Short answer: you do this by either:

• making a button column where each button modifies thisRow.Rating, then one button that presses all the buttons in the column, then delete the column.
• or use FormulaMap in your single use button to iterate over each row and modify, e.g.

Movies.FormulaMap(
  CurrentValue.ModifyRows(Movies.Rating, Round(CurrentValue.Rating / 2))
)

There’s also a way without buttons, but it’d take much longer, so just do the FormulaMap as the fastest one.