I have a base with two tables: the first is a basic table with a list of records that change somewhat frequently. The second table has a multi-select field whose options should be whatever records are in the first table-view.
I'd love to have a script that goes to the multi-select field in table 2, deletes all of the options in it currently, and then replaces the options with the records in table 1. The idea would be to put that script in an automation that runs once a day at midnight, ensuring the options in the multi-select field are always up-to-date.
Any idea how to write this script?