@Andreas_Iacovides,

I think you forgot to include your code, so I don’t know specifically what you are working with… I assume this is in the context of the Scripting Block, so I think I can just provide the general guidance that you can use JavaScript’s built in .filter() method to do this on your queried records. Assuming you’ve queried your records into a variable called records, it will look something like this:

 let filteredRecords = records.filter(record => record.getCellValue("email").includes("@gmail.com"))

In this example, your records would be filtered to return only records where the “email” field includes the sub-string “@gmail.com”, and the resulting array of records would be stored in the filteredRecords variable.

.filter() takes an arrow function which it runs on each record ((record => {function block}). The {function block} needs to be a piece of code that returns a boolean true/false as its result. The .includes(), which we run against the string returned by .getCellValue() will return true if it finds “@gmail” in the email address string, and false if it does not.

Hopefully that at least points you in the right direction.

@Andreas_Iacovides,

I think you forgot to include your code, so I don’t know specifically what you are working with… I assume this is in the context of the Scripting Block, so I think I can just provide the general guidance that you can use JavaScript’s built in .filter() method to do this on your queried records. Assuming you’ve queried your records into a variable called records, it will look something like this:

 let filteredRecords = records.filter(record => record.getCellValue("email").includes("@gmail.com"))

In this example, your records would be filtered to return only records where the “email” field includes the sub-string “@gmail.com”, and the resulting array of records would be stored in the filteredRecords variable.

.filter() takes an arrow function which it runs on each record ((record => {function block}). The {function block} needs to be a piece of code that returns a boolean true/false as its result. The .includes(), which we run against the string returned by .getCellValue() will return true if it finds “@gmail” in the email address string, and false if it does not.

Hopefully that at least points you in the right direction.