Sorry @Nicholas Williams, I was incorrect (partly).
• Data cannot be manipulated for records that are loaded in beforeLoad scripts. If you attempt to update a record loaded in beforeLoad, the logic is ignored.
• Data can be manipulated for records created in beforeLoad user events.
If that doesn't work you would need to create a client script to do the work.