|
Hartynspren
Angemeldet seit:
02.01.2023
Beiträge: 178
|
Hello,
I'm trying the get the latest record from each user made in the past 12 hours.
The List rows works because I get all the records made in the past 12 hours.
How do save into the variable only the latest ones from each user based on email address? My condition at the moment does not work, because all the List rows records end up in the variable regardless there being duplicate email addresses.
What am I doing wrong?
|
| |
|
AniemDariel
Angemeldet seit:
17.02.2023
Beiträge: 86
|
To solve your issue, you'll need to filter the records based on the latest timestamp for each email address after fetching all records from the past 12 hours. Here's a simple approach:
First, list all the rows within the past 12 hours.
Then, loop through the results and create a dictionary where the key is the email address, and the value is the latest record based on the timestamp.
|
| |
|
YunDevour
Angemeldet seit:
24.07.2023
Beiträge: 50
|
If you want to check if an email exists in a variable, it’s pretty simple! First, you can do a basic validation by checking the format. But that only tells you if the email looks right, not if it's real.
For a more solid way to know if the email exists, you could use an email verification tool. I’ve found ***** helpful. It’s excellent for confirming if the email is real and active. This way, you’ll save time and avoid sending to invalid addresses.
|
| |
