Hello,
I am very new to ReTool and need some help filtering a table based on the multiselect inputs. I would like the table to display all rows if nothing is selected, then only show rows that match the selected value(s) in the multiselect component.
My data is drawn from a Google Sheet.
This is what I have so far:
function SelectInputs(value) {
if ({{multiselect1.value.length === 0}}) {
return value.Operation !== ""
}
else {
return value.Operation === {{multiselect1.value}}
}
};
return data.filter(SelectInputs);
This Transformer query works when there are no inputs in the MultiSelect component, but is empty when anything is selected. I would also like to note that the only values in the multi-select dropdown menu were mapped with {{item.Operation}}.
I have been stuck on this for a while. Any help is appreciated. Thanks!