Button to copy data from1 field to another

[Alastair_Noon]

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 solution]

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 getCellValueAsString

Also try adding the await keyword in front of table.updateRecordAsync

[Alastair_Noon]

Thank 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 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.getCellValueAsString("EQ3");
   
   let newValue = oldValue;
   output.text(newValue);

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

[kuovonne]

Alastair_Noon:

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?

No, it is not currently possible to change this. You can write your script to detect whether the field is empty and product different output when it is.