The Scripting block applies the record associated from a button click to whatever the first rendered record input is. That means if you’re triggering a script from the “wrong” table, and you don’t want the evaluated table to change dynamically (i.e. always look at the “Farm Details” table) you need to insert a superfluous record input at the start to conditionally appear whenever you launch the script from the wrong table.

let desiredTable = base.getTable("Farm Table")


let activeTable = base.getTable(cursor.activeTableId)





if (activeTable.id !== desiredTable.id) {


    let triggerRecord = await input.recordAsync("Record from wrong table that triggered this script", activeTable)


}





let record = await input.recordAsync("Select a record", desiredTable)

or

let desiredTable = base.getTable("Farm Table")


let activeTable = base.getTable(cursor.activeTableId)





let record = await input.recordAsync("Select a record", activeTable)





if (activeTable.id !== desiredTable.id) {


    record = await input.recordAsync(`Reselect record, pick from the ${desiredTable.name} table`, desiredTable)


}

Thanks Kamille, that doesn’t seem to work as it always asks twice for a record - I’m always triggering the script from the wrong table - I made a separate table which has the buttons on it as they are not needed in each record This was the original script

// Update a record in the Farm Details table


let table = base.getTable(“Farm Details”);


let query = await table.selectRecordsAsync();

let recordId = await input.recordAsync(‘Select a farm to change the farm name’, table);

let name = await input.textAsync(‘What is the new farm name?’);

await table.updateRecordAsync(recordId, {


“Farm Name”: name ,


})

console.log(“Farm Name has been updated!”);

Thanks Kamille, that doesn’t seem to work as it always asks twice for a record - I’m always triggering the script from the wrong table - I made a separate table which has the buttons on it as they are not needed in each record This was the original script

// Update a record in the Farm Details table


let table = base.getTable(“Farm Details”);


let query = await table.selectRecordsAsync();

let recordId = await input.recordAsync(‘Select a farm to change the farm name’, table);

let name = await input.textAsync(‘What is the new farm name?’);

await table.updateRecordAsync(recordId, {


“Farm Name”: name ,


})

console.log(“Farm Name has been updated!”);

If I haven’t misread this: just remove the individual awaits, then declare a single Promise.race method bundling them all together (and await that one, of course) at a point where you actually need some input to proceed.

The syntax would be something like const raceWinner = await Promise.race(epromise1ref,promise2ref,etc])

EDIT: Oh, and while not immediately relevant here, sometimes selective source table filtering is the optimal behavior:

const currentTable = () => base.getTable(cursor.activeTableId).name;





if(f'Table 1','Table 2'].includes(currentTable()));





const cr = await input.recordAsync('',base.getTable(currentTable()));


output.clear()


output.markdown(`## Script called by record ${


    cr.name} (${


        cr.id}) from table "${


        currentTable()}"`


            );

So, this would allow using calling records from buttion presses in Table 1 and Table 2, but not from any other. Even if those hypothetical others each had a button set up to activate the exact script hosting this code.