Hello All! Im importing values from a column of a spreadsheet. Some of the cells are blank and I would like to remove them so I don't have a blank option in my select: [image] I have tried to just a git of JS to remove it: Object.keys(item.Product).forEach(key => { if (item.Product[key] === '…

Maybe that would work. Not sure why this one is not working. Anyways I have created a transformer and using this instead. var products = {{getTrades.data}} products = products.map(x => x.Product) products = [...new Set(products)] products = products.filter(x => x) return products duplicates and b…

Removing empty values from mapper in select

💬 Queries and Resources

ScottR October 26, 2022, 11:46am 2

Maybe you would want to check that if it is NOT empty then add it to the Select...

1 Like

Topic		Replies	Views
Transformer to remove property with value=null from an object 💬 App Building transformer	5	1454	September 11, 2023
How to pull Column value of selected rows in multi select table into an Array 💬 App Building multiselect	5	2252	November 15, 2023
Can transform 'remove' (not include) a column from a dataset (changedataArray) 💬 Queries and Resources transformer	3	801	December 28, 2023
How to turn the dropdown values into unique values 💬 App Building	3	604	April 1, 2024
Picking specific values from the .recordUpdates property 🧑‍💻 Retool Tips & Tricks	5	3867	March 8, 2023

Removing empty values from mapper in select

Related topics