Reset a Bulk Edit field to zero

The idea is to set category fields from a value back to zero via bulk edit.
https://community.tapeapp.com/t/bulk-edit-in-table-for-single-select-and-status-field-beta/718

Hey Roman, I wanted to remind you to vote for feature requests (top left.) And also, to remind you to ‘take your vote back’ after a request is implemented :wink:

1 Like

Hi @Roman,

thank you very much for your feature request. This could perhaps even be a low-hanging feature. We’ll check that directly. Of course, we would just have to check that it is not a required field.

Thanks again and best regards
Leo

Just to copy it here: 🆕 Bulk edit in table for single select and status field - BETA - #16 by R.J

Hi all,
As a quick workaround for this, I found this “fix” (although I am not sure if this could potentially brake something/have unwanted consequences):

  1. Create a new option in the field.

  2. Set in bulk all the records to this option.

  3. Delete the option.

I hope this “dirty” trick helps until a proper unset option is implemented.

Thanks.
Best,
R.J.

@R.J

An alternative to your deleting option that as you say may well have “unwanted consequences” could be the following:

  1. Search for records you want to change in batches of 50
  2. Replace were I have ‘single_select’ with whatever your field external name is
  3. replace were i have 61169 with your app ID
// console.log(JSON.stringify(record_collection_docs,null,2));
const ev = `$.{
  "record_id": record_id,
  "fields": {
    "single_select": ""
  }
}[]`;

const inputs = jsonata(ev).evaluate(record_collection_docs);
await tape.Record.batchUpdate(61169,{
    inputs
}
);

that will change the records 50 at a time:

Stil a work round but probably safer than deleting options