Hello. I’m learning the scripting block and not a programmer but hope to get my feet wet.
I have taken the basic script to “select a record” and added that to a button called COPY.
// Change this name to use a different table
let table = base.getTable("Table 3");
// Prompt the user to pick a record
// If this script is run from a button field, this will use the button's record instead.
let record = await input.recordAsync('Select a record to use', table);
if (record) {
// Customize this section to handle the selected record
// You can use record.getCellValue("Field name") to access
// cell values from the record
output.text(`You selected this record: ${record.name}`);
} else {
output.text('No record was selected');
}
But now I want to use the record selected to copy Field 1 (which is a lookup field) into Field 2 which is just a basic number field.
Can anyone point me how to “copy” data from one field to the other?
Thank you @Justin_Barrett!
Yes, i think you have the right idea.
Essentially i want to add a button to “check” to see if a linked record exists. So if PQ1033 exists in the linked field, I’d like to select that linked field. If not, then just output a “No Match” text or something.
This is the code I have so far:
// edit the table and field names to match your base
const tableName = “Plates”;
const sourceFieldName = “Plate”;
const targetFieldName = “Match”;
const table = base.getTable(tableName);
const record = await input.recordAsync(“Pick a record”, table);
// change the function name below for your desired field types
const writeValue = await copyToSingleSelect(table, record, sourceFieldName, targetFieldName);
output.markdown(Copied value of **${sourceFieldName}** to **${targetFieldName}**);
output.inspect(writeValue);
async function copyToSingleSelect(table, record, sourceFieldName, targetFieldName) {
let writeValue = record.getCellValueAsString(sourceFieldName);
if (writeValue) {
writeValue = {“name”: writeValue};
} else {
writeValue = null;
}
await table.updateRecordAsync(record, {[targetFieldName]: writeValue});
return writeValue;
}
But when I execute, I get:
ERROR
R: Can't set cell values: invalid cell value for field 'Match'.
Cell value has invalid format: <root> must be an array.
Linked records field value must be an array of objects with property 'id' corresponding to linked record id.
at copyToSingleSelect on line 19
at main on line 8
I notice in @kuovonne’s solution there was no function to copy data to a Linked Field.
