Im new to StudioX and im still not sure about its full capabilities, i have a new project and i don’t know if its can be achieved in StudioX or not.
I have an Excel table which looks something like this, 3 records for same user. see below.
I need to send an email if the status of all records is approved, AND
Total Value for three records NOT EQUAL TO 100, OR
Date of any of the record = beyond 2021. OR
In the above image, email has to be sent for ID1 (total value not equal to 100 and date beyond 2021), AND ID3 (total value not equal to 100).