Warning when running a script from a different table

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([promise1ref,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(['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.