Looking at the best options for creating an item/row that a selection of fields are defaulted on the last item entered historically.
The context is that an item is created that holds 12 “scores” of different measures 1 to 5, using the rating component. So the next time a user “scores” it would be useful to just change the ones that are different. This way the data retains the historic trends of the scores.
Now I have used ARRAYFORMULA, for post saving updates to fields (mark the most recent item and setting 0 to 1 for the ratings) but this new requirement requires a preceding event to default, not a post save event that ARRAYFORMULA can handle.