Appsheet check if new rows are different from existing ones

Hello,

 

I am having a couple of issues with setting an automation into my appsheet.  I have a scheduled daily import with the data containing an employee email, competence, number of iterations done and current level for that competence. What I need to achieve is when an employee obtains a higher level of competence for one iteration, he will receive an email notification.

I guess that I need to find a way to check if a newly added row is having a different level for the same employee and competence , but I am not sure if this is possible in Appsheet.

Thanks,

Narcis

Solved Solved
0 9 498
1 ACCEPTED SOLUTION

  1. "Angajat" isn't an email address.
  2. Your column to maximize really should be the same as the one being checked with '<' in the extra conditions.
  3. Speaking of the '<', you didn't use it, but instead are equaling to yesterday. Not sure why you did that.
  4. Stop using row number as your key column.

View solution in original post

9 REPLIES 9