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
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
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):
-
Create a new option in the field.
-
Set in bulk all the records to this option.
-
Delete the option.
I hope this “dirty” trick helps until a proper unset option is implemented.
Thanks.
Best,
R.J.
An alternative to your deleting option that as you say may well have “unwanted consequences” could be the following:
- Search for records you want to change in batches of 50
- Replace were I have ‘single_select’ with whatever your field external name is
- 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