Hello everyone,
I have two Zaps connected to a single table, and they currently use an identifier in the Zapier table. However, I only want the Zaps to pick up the most recent entry. Right now, the Zapier table displays a list of all previous entries, and since the identifiers have similar names, I need a way to filter it to show only the latest one.
Additionally, how can I configure the Zapier table to look up the Zapier timestamp and use it for this process?
Best answer by SamBBest answer by SamB
Hi there,
With Date & Time fields there isn’t a “most recent” type of search operator that you could use in a Find Record action to search a table. But you could potentially use a Find Records (Output as Line Items) to get all the records with that same identifier. Then use a Formatter (Utilities > Line-item to Text) action to pull the Record ID for each of the records the previous step found, to get the Record ID of the last record:
Then, you could use that Output Item Last field in a Find Record action to pull all the details for just that specific record:
Do you think that sort of approach could work?
+11Hi there,
With Date & Time fields there isn’t a “most recent” type of search operator that you could use in a Find Record action to search a table. But you could potentially use a Find Records (Output as Line Items) to get all the records with that same identifier. Then use a Formatter (Utilities > Line-item to Text) action to pull the Record ID for each of the records the previous step found, to get the Record ID of the last record:
Then, you could use that Output Item Last field in a Find Record action to pull all the details for just that specific record:
Do you think that sort of approach could work?
Thanks
Hi there,
With Date & Time fields there isn’t a “most recent” type of search operator that you could use in a Find Record action to search a table. But you could potentially use a Find Records (Output as Line Items) to get all the records with that same identifier. Then use a Formatter (Utilities > Line-item to Text) action to pull the Record ID for each of the records the previous step found, to get the Record ID of the last record:
Then, you could use that Output Item Last field in a Find Record action to pull all the details for just that specific record:
Do you think that sort of approach could work?
Thanks for the detailed answer. While this approach could work, I used a unique identifier for each unit in the table. That made it easier.
+11You are most welcome,
Seems like you’re all set for now but please do reach back out if there’s anything else we can help with.
In the meantime, happy Zapping! ⚡
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
