Using a script to add values from one field to another
Hi @Jens_Schott_Knudsen1 - try this script:
// set the table
let notesTbl = base.getTable("Notes");
// get the table records
let notes = await notesTbl.selectRecordsAsync();
// loop through the records
for (let record of notes.records) {
// set variables to the record values
let notes = record.getCellValue("Notes");
let notesHistory = record.getCellValue("Notes History")
// set variable for today's date
let now = new Date().toLocaleDateString("en-GB");
// define the newNotes variable with starter text (includes the date)
let newNotes = "======= Copied " + now + " ======= ";
// only run on records which have notes
if (notes) {
output.text(`Copying notes for record ${record.name}`)
// build the newNotes value from the notes...
newNotes = newNotes + notes;
// ...and the notes history
newNotes = newNotes + notesHistory;
// update the notes history value and reset the notes value
notesTbl.updateRecordAsync(record, {
"Notes History": newNotes,
"Notes": ""
})
}
} WARNING:
Quickly put together so please try this out on a copy of your base and check that it works for you before you put it into production!
It takes the text from the “Notes” field and prepends it to the “Notes History” field with a date stamp:
JB
Hi @M_k - this script does it:
// set the table
let table = base.getTable("Table 1");
// get the table records
let query = await table.selectRecordsAsync();
// loop through the records
for (let record of query.records) {
// check that Multi-select 1 is not empty...
if (record.getCellValue("Multi-select 1")) {
output.text(`Copying the multi-select values for record ${record.name}`)
// now update Multi-select 2 with the array of ids in Mulit-select 1
let msCopy = await table.updateRecordAsync(record, {
"Multi-select 2": record.getCellValue("Multi-select 1")
})
}
} In some ways, it is a bit simpler than the other script as we don’t need to take account of values in the 2nd multi-select (I assume), just copy MS1 to MS2:
If you wanted the script to be additive rather than replacing, then it would be a bit more involved as you would need to form an array of IDs from MS2, then add the IDs from MS1 to it, before saving this array to back MS2.
One thing to be aware of is that the script cannot create new multi-select values in MS2, so if you have a record in MS1 with a value of “Five” and this doesn’t exist as an option in MS2, then you will get an error. Also, nothing to stop the second multi-select being in a different table, just need to set the second table and reference this in the update.
Hope this helps
JB
