I have a button/script that I want to be a toggle the value in a single select field. If the value is blank, I want to e button to mark it “Absent”; if the value is “Absent”, I want the button/script to make the cell blank.

In Airtable Scripting, I see how to delete choices, but I don’t think I want to delete the choice, just the value. (I am trying to avoid having a second option of “Present”, as I know my users will assume they have to mark all clear cells as “Present”.)

Here’s my script:

// Select the recordId that houses the button

let tableClassReg = base.getTable("Class Reg");

let record = await input.recordAsync('',tableClassReg).catch()

//console.log(record.id, record.name);



// read in a specific field

let entry = record.getCellValue("D1 Atnd");



// toggle that field

if (entry.name=="Absent") {

    await tableClassReg.updateRecordAsync(record, {

        'D1 Atnd':{"name":""}  //<-- here's the problem

    });

} else {

    await tableClassReg.updateRecordAsync(record, {

        'D1 Atnd':{"name":"Absent"}

    }); 

};

I’ve tried “”, empty square brackets, null. But it doesn’t seem to allow me to force it to clear a value from a cell. Should I be using a different call?

Related: if I give a user a read-only view link, will the button fail to work at all?