Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How can I make a button to add or clear a value based on a cell conditon?

55 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I'm currently running a script button that will copy the 'Reservation Requested By' value to 'Reserved for'  value.

 
let table = base.getTable("Status Report");
 
let record = await input.recordAsync('Reservation Requested By', table);

if (record) {
   let oldValue = record.getCellValueAsString("Reservation Requested By");
   
   let newValue = oldValue;
   output.text(newValue);
   
   await table.updateRecordAsync(record,{"Reserved for": newValue});
} else {
    output.text('');
}
 
I want to add a condition to this button so that if the 'reserved for' value is not empty, or exceeds certain days then remove the value.
 
Can I do that?
1 Reply 1

Here is one approach you could consider - we're checking if the "Reserved for" field is empty, and if it is - then we take the "Reservation Requested By" info and stamp it into the "Reserved for".

let table = base.getTable("Status Report");
 let record = await input.recordAsync('Reservation Requested By', table);

if (!record?.getCellValueAsString("Reserved for")) {
    let newValue = record?.getCellValueAsString("Reservation Requested By")
    await table.updateRecordAsync(record ,{"Reserved for": newValue});
};