Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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!

Hi @GPozzi!

Would you provide a little more context for this? ie. Screenshots of the code 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 I think you’re asking, but let me know if that’s not it:

var EmployeeCode = ["ABC123", "DEF456", "GHI789"]; // These employees were expected
var EmployeeLog = ["ABC123", "GHI789"] // These employees were present
var 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[i])) {
    NotPresent.push(EmployeeCode[i]);
  }
}

output = [{NotPresent}] // 👉🏻 ["DEF456"]

 

Hi @GPozzi!

Would you provide a little more context for this? ie. Screenshots of the code 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 I think you’re asking, but let me know if that’s not it:

var EmployeeCode = ["ABC123", "DEF456", "GHI789"]; // These employees were expected
var EmployeeLog = ["ABC123", "GHI789"] // These employees were present
var 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[i])) {
    NotPresent.push(EmployeeCode[i]);
  }
}

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

Glad I was able to help!

Terms & ConditionsAccessibility statement