Skip to main content

I have a simple grid view data like that:



and I want to filter my data by company’s uniqueness and get an array which includes list of companies by unique like e'Google', 'Facebook', 'Apple'] read Formula Field Reference but couldn’t find. I can fetch entire data and make filtering on client side but instead of getting entire data, I want to pull only array of companies. By code below so far. Thank you


    const RES = await db('users').select({

      view: 'Grid view',

      filterByFormula: 'some filter should be happen at there',

    }).all()

    console.log(RES) // should return u'Google', 'Facebook', 'Apple']

Hey you’d want to create an array of the Company, and potentially use ARRAYUNIQUE(Eitem1, item2, item3])

Hi @kaan_g - if RES is returning an array of users (which I guess it is), then you could do something like:


let unique = [...new Set(RES.map(user => user['Company']))];

console.log(unique);

I haven’t tested this out, but the following works nicely in Airtable scripts, so hopefully you can modify for your code:


let peopleTbl = base.getTable('People');

let query = await peopleTbl.selectRecordsAsync();



let unique = =...new Set(query.records.map(person => person.getCellValue('Company')))];

console.log(unique);


based on this table:



This is creating a new Set, then “spreading” the values of the Set object to an array.

Reply


Terms & Conditions