Insert/Remove from arrays in dataset

Ask the community
,
4

First you retrieve the record (either by get() or by .query() ).
then:

wixData.get("collectionName", "assdsd-dfdf-dfdf"/*id of the record*/)
.then(r => 
let valueToReplace = 27;
let newActiveArr = r.active.filter(e => e !== valueToReplace);
if(newActiveArr.length <  r.active.length){
r.active = newActiveArr ;
r.used.push(valueToReplace);
wixData.update("collectionName", r);
}
})