Button to copy data from1 field to another

Question

Hi,
I’m learning how to use the scripting block, not too successfully. I have tried to adapt the scripting block “select a record” and one from the thread about linked fields from @capt & @JonathanBowen but I can’t seem to get it to work. I am trying to copy the text output by a formula field (EQ3) into the text field Notes using a button.
Any help or advice would be much appreciated!
Many thanks,
Alastair

This is what I have so far:
// Name of table
let table = base.getTable("Requisitions");

// This script is run from a button field & will use the button's record
let record = await input.recordAsync('Select a record to use', table);

if (record) {
    // You can use record.getCellValue("Field name") to access
   let oldValue = record.getCellValue("EQ3");
   
   let newValue = oldValue;
   output.text(newValue);

table.updateRecordAsync(record,{"Notes": newValue});
} else {
    output.text('No record was selected');
}

kuovonne · Accepted Answer

Welcome to the Airtable community!Are you getting any error messages? Does the script run at all?What is the result of the output.text(newValue)?Try converting getCellValue to getCellValueAsStringAlso try adding the await keyword in front of table.updateRecordAsync

Alastair_Noon · Answer

Welcome to the Airtable community!Are you getting any error messages? Does the script run at all?What is the result of the output.text(newValue)?Try converting getCellValue to getCellValueAsStringAlso try adding the await keyword in front of table.updateRecordAsyncThank you!By adding both of these things in the script now works runs properly - thank you!The button still currently applies to all records regardless of whether or not EQ3 is populated, do you know how it is possible to change this?This is my code, with your revisions @kuovonne// Change this name to use a different tablelet table = base.getTable("Requisitions");// This script is run from a button field &will use the button's recordlet record = await input.recordAsync('Select a record to use', table);if (record) {    // You can use record.getCellValue("Field name") to access   let oldValue = record.getCellValueAsString("EQ3");      let newValue = oldValue;   output.text(newValue);   await table.updateRecordAsync(record,{"Notes": newValue});} else {    output.text('No record was selected');}

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded