Hello, with the new custom blocks or automation feature, is it possible to make a script that will automatically change a single-select field of all records (or records in a certain view) to a certain value?

It serves the same purpose as the batch-update block, but the batch update block runs manually. I’m looking for something that runs automatically at a specified time (e.g. at 12 am every night) with the automation feature or through custom blocks

Any help in this will be very much appreciated