How do I look up for values that are not present in another list?

Question

Hi there! I’m trying to set up a zap that triggers a notification if a EmployeeCode is not present in today’s entry logs.

I have both variables: EmployeeCode that says which employees should have been present and EmployeeLog that states employee codes present on today’s records. How could I filter EmployeeCode if it’s not present in EmployeeLog?

I tried with JS Code by passing them as a dictionary but I can’t seem to find the way.

Is there a simpler approach to this?

Thanks in advance!

icon

Best answer by Todd Harper 15 January 2023, 23:23

View original

Todd Harper · Accepted Answer

Hi@GPozzi!Would you provide a little more context for this? ie. Screenshots of thecode you tried? Are EmployeeCode and EmployeeLog arrays? What do you then need to happen with the information?Here’s a quick piece of JavaScript that does what Ithinkyou’re asking, but let me know if that’s not it:var EmployeeCode = ["ABC123", "DEF456", "GHI789"]; // These employees were expectedvar EmployeeLog = ["ABC123", "GHI789"] // These employees were presentvar NotPresent = [];// Next, we will determine which employees were not present by passing each expected employee through the array of present employees.// We will append the absent employee to the "NotPresent" array.for (var i = 0; i < EmployeeCode.length; i++) {  if (!EmployeeLog.includes(EmployeeCode)) {    NotPresent.push(EmployeeCode);  }}output = [{NotPresent}] // 👉🏻 ["DEF456"]

Anonymous · Answer

Hi@GPozzi!Would you provide a little more context for this? ie. Screenshots of thecode you tried? Are EmployeeCode and EmployeeLog arrays? What do you then need to happen with the information?Here’s a quick piece of JavaScript that does what Ithinkyou’re asking, but let me know if that’s not it:var EmployeeCode = ["ABC123", "DEF456", "GHI789"]; // These employees were expectedvar EmployeeLog = ["ABC123", "GHI789"] // These employees were presentvar NotPresent = [];// Next, we will determine which employees were not present by passing each expected employee through the array of present employees.// We will append the absent employee to the "NotPresent" array.for (var i = 0; i < EmployeeCode.length; i++) {  if (!EmployeeLog.includes(EmployeeCode)) {    NotPresent.push(EmployeeCode);  }}output = [{NotPresent}] // 👉🏻 ["DEF456"]Wow Todd, that’s exactly what I’ve been looking for! Sorry for not being so clear, but that totally solves my question

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded