Skip to main content

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?

Hi @Murinhardt 

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 @Troy Tessalone 

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).

 


@Murinhardt

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


@Troy Tessalone 

 

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.

 


@Murinhardt 

Like this...

 


@Troy Tessalone 

Oh..Ok.

So, Can you show me the table side settings for this item?


@Murinhardt 

Try using the Date field you already have in the Zapier Table.

When in doubt, test it out.

 


@Troy Tessalone 

 

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

 


@Murinhardt 

Did 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


@Troy Tessalone 

 

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.


@Murinhardt 

The 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.


@Troy Tessalone 

 

Thank you! I see.
I understand now that Zapier does not automatically determine yesterday.

I will try it again.