My current movie ratings are from 1-10 stars. I would like to halve the ratings to 1-5 stars. Essentially, I want to bulk edit the table and replace the rating with Round(currentRow.Rating / 2).
Since column formulas cannot have side effects, but buttons can, the most obvious way to do this in my mind is to create a single use button that sets the rating to half its value. Unfortunately, I have not figured out how to refer to the “currentRow” in the “Update Values” section of the button.