I am storing the answers in a zapier table when I get a new answer from 123formbuilder.
Then every day at midnight I want to put that data in AWS S3 using the schedule function.
My problem now is how can I use the schedule function to extract only the responses that were answered yesterday.
Can someone please answer this question?
Best answer by Troy Tessalone
Check the field descriptions/tooltips for guidance.
If you are using a Date field type, then you can try using the word: yesterday
Otherwise, use this Zap action: Formatter > Date & Time > Format
Insert system timestamps: https://help.zapier.com/hc/en-us/articles/8496275717261#iso-8601-timestamps-0-1
+14Hi
Zap Action: Zapier Tables - Find Records (Output as Line Items)
If you log the Date in a field, then you can search by yesterday’s date.
Hi
Thank you for reply.
Already has an item with a send date.
I don't know how to specify “yesterday” in Find Records (Output as Line Items).
+14Check the field descriptions/tooltips for guidance.
If you are using a Date field type, then you can try using the word: yesterday
Otherwise, use this Zap action: Formatter > Date & Time > Format
Insert system timestamps: https://help.zapier.com/hc/en-us/articles/8496275717261#iso-8601-timestamps-0-1
Yes.
I set this in the table.(submit_datetime)
Are you talking about yesterday and here that you have a choice?
I can't find it.
Oh..Ok.
So, Can you show me the table side settings for this item?
+14Try using the Date field you already have in the Zapier Table.
When in doubt, test it out.
I tested it many times.
But it seems to recognize “yesterday” as a string, even though I set it up the same way you did
+14Did you try this suggestion?
Otherwise, use this Zap action: Formatter > Date & Time > Format
Insert system timestamps: https://help.zapier.com/hc/en-us/articles/8496275717261#iso-8601-timestamps-0-1
Yes.I tried this.
Sorry,But I didn't understand why I needed to do this, since I already have the date in the table with the DateTime type.
+14The value for yesterday changes each day.
Use a system generated timestamp in a Formatter step to get yesterday’s date in the same format as you have configured in your Zapier Table.
Then map the output variable from the Formatter step to be the Zapier Tables Zap action Lookup Value.
Thank you! I see.
I understand now that Zapier does not automatically determine yesterday.
I will try it again.
Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
