I have a custom schedule that starts the scenario on specifik dates. When it runs I want the filter to see if a row has todays date. If yes, then filter would let the trigger pass through to PerpIexity and run the full scenario. I want it to keep looking at rows until there is no more dates that matches todays date.
I got it to work when I set it up, but now I get errors (see attached picture).
The rows in google sheets looks like this (it has its own row)
The filter looks like this:
Can anyone see where I am going wrong? If you need more info please let me know. Would very much appreciate your help and input.
/ Anders
I found what the problem was. Since the scenario started to try to run on 2024-11-13 and it tried 10 rows and no dates matched, then it went on to the next 10 rows and of course their dates did not match so that is why I got the error.
So, the problem now is how do I prevent this from happening? How can I make it so that it checks the rows again that did not pass the filter (and then skip to check them once they are let trough the filter)?
Thank you for any thoughts
Hello @Anders_Granstrom,
You just create it more complex.
Directly use “Search Rows” https://www.make.com/en/help/app/google-sheets#idp1178398, Instead of putting the filter on other modules.
Directly add a filter on Google Sheets ⇒ Search Row action. There are options for filters is there.
Then directly to your next module.
P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution 
and 
Need expert help or have questions? Contact or comment below! 
1 Like
Thank you so much, I did not consider this option. Have now changed this and added the filter inside the Google sheet module.
Now I just need to input the correct info. I get an error now when I try it out.
I have these settings:
Thank you
I noticed that I forgott to remove the filter I set up. Having removed also removed the error info.
It is still not working as I want it to, but now at least I can try out different ways to solve this
1 Like
