Hi Makers,
I’m using the Airtable “Watch Records” to pull new records and copy them into WooCommerce.
Here’s what I’m struggling with:
The “Watch Records” pulls all the newly added records. But newly added since when?
The “watch records” is set on a schedule, to run every Monday at 2am. Where does the business logic come from, in order for make to only pull the newly added records of the past 7 days, and not all the newly added records since the base was created? I do not believe make has a memory and knows what happened in the last 7 days. thoughts?
Thanks,
Ed
hi @Edouard_C ,
please share a screenshot of the module and the scheduling settings.
and I have some confusion regarding the requirements.
-
To my best understanding of the watch records module it will only get trigger for new entries so as it’s scheduled on Monday, it should only get the responses from the Last Monday run ( so 7 days ).
-
For the first run you can specify the time from here
-
If the above settings don;t work you can use the Formula field to create a condition between the CREATED_TIME() and NOW() to find the records that were only created in the past 7 days.
1 Like
Hi Rezwan,
Thanks for the quick follow up - appreciate the help
My main question is: A. how far does the module go back in time to pull the “newly created records” and B. how does it know which ones were created?
- To my best understanding of the watch records module it will only get trigger for new entries so as it’s scheduled on Monday, it should only get the responses from the Last Monday run ( so 7 days ).
There are a few options for “schedule trigger”: every 15 minutes, hour, week etc. Does it mean that the module remembers when the last trigger ran, and what got created in between? i.e.: yes, the module knows it’s running every 15 minutes and can go back in the last 15 minutes. But I could also turn it off and back on, and the “15minutes” would no longer hold…
If the above settings don;t work you can use the Formula field to create a condition between the CREATED_TIME() and NOW() to find the records that were only created in the past 7 days.
How would I have to write the formula? If I run the scenario every 7 days. it would be a formula between the last 7 days and now?
Please see screenshots below:
Thanks again
@Edouard_C
DATETIME_DIFF(NOW(),CREATED_TIME(), “days”)<= 7
you can use this formula, where the difference between the record creation date and current date is either 7 days of less
1 Like
Hi Rezwan,
Thank you for the quick update - I think this solves my problem for now If I run into bugs as this goes into production - I will reach back out
Have a great day!
2 Likes