Solving the Automation Repeating Issue in Make.com
Introduction
Have you ever faced a situation where your automation is repeating every 15 minutes when the rule is greater than the 'Created at' from MySQL to FluentCRM? If yes, then you're not alone. This is a common issue faced by many Make.com users. But don't worry, we have a solution for you.
The Problem
The problem arises when you have a Laravel system and when a user signs up, you want the name and the email to go to FluentCRM. However, the automation keeps repeating every 15 minutes for every contact after a certain date. What you want is for the action to take the contacts after a certain date at the same time that the user signed up without repeating it.
The Solution
The solution to this problem is to use a date/time comparison instead of a string comparison filter. Here's a step-by-step guide on how to do it:
- Use the Make API module to list the current scenario logs, limit 1 (latest).
- In the filter after your SQL module, do a datetime comparison of the item created_at and timestamp.
By following these steps, you should be able to solve the problem of the automation repeating every 15 minutes.
Troubleshooting Tips
If you're still facing issues, make sure to check the format of the field created_at. Also, remember that the SQL application does not have an instant trigger. You will need to use a CRM or database that can send webhook (instant trigger) requests to Make whenever a new record is created.
Conclusion
In conclusion, the issue of automation repeating every 15 minutes when the rule is greater than the 'Created at' from MySQL to FluentCRM can be solved by using a date/time comparison instead of a string comparison filter. Remember, patience goes a long way when troubleshooting these issues. Happy automating!
You do have further questions?
Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.