Mar 06, 2023 08:23 AM
Hello there
i have an automation that was working fine, now when i try to test it, i can't get past the trigger. the trigger works, but when i try to evaluate the conditions for the first action group (or any other action group) i get an error instead of an "yes, matches conditions" or "no, doesn't match conditions". strangely, this automation worked until now. is the error possible related to airtable general maintenance or issues and not to my automation at all. or do you guys know what kind of conditions throw such an error instead of getting evaluated. very strange 😞
Solved! Go to Solution.
Mar 21, 2023 08:59 AM
If anyone runs into this: for me it's because I accidentally went over my automation run limit while building my database and running way too many tests. Word of caution, be more conservative about your tests!!
Nov 21, 2023 09:47 AM
This extremely unhelpful code was cropping up in one of my automations, despite not being over the limits... and it took me a while but I found the solution.
One of my conditions was checking if {Completion} < 1 where {Completion} is a formula field formatted that properly recognizes numerical formatting. I saw grumblings in another forum post which alluded to the fact that formulas referencing lookup fields can sneakily pass through an array rather than a number which can cause automations to fail.
I thought that the new feature in the lookup field configuration to "Limit the number of items shown to the first 1" would force the lookup to return a single value, but it still appeared to be passing an array with a single number. So I altered my formula field to explicitly cast the lookup field to a string and then a number. The resulting formula:
{Completion (Lookup)} & "" + 0
Jul 08, 2024 06:01 AM
Seems like this can be caused by various issues. Check your formulas and fields. Potentially it's related to:
Mar 14, 2023 05:23 AM
I'm experiencing the same issue here @Davidt. Have you been able to resolve this?
Mar 20, 2023 07:13 PM
this is happening to all of my automations. Any insight?
Mar 21, 2023 08:59 AM
If anyone runs into this: for me it's because I accidentally went over my automation run limit while building my database and running way too many tests. Word of caution, be more conservative about your tests!!
Mar 31, 2023 01:08 PM
Thanks! This was also the problem in my case. The error message is very misleading (I spent a lot of time trying to figure out what was wrong with my conditional group!).
Nov 21, 2023 09:47 AM
This extremely unhelpful code was cropping up in one of my automations, despite not being over the limits... and it took me a while but I found the solution.
One of my conditions was checking if {Completion} < 1 where {Completion} is a formula field formatted that properly recognizes numerical formatting. I saw grumblings in another forum post which alluded to the fact that formulas referencing lookup fields can sneakily pass through an array rather than a number which can cause automations to fail.
I thought that the new feature in the lookup field configuration to "Limit the number of items shown to the first 1" would force the lookup to return a single value, but it still appeared to be passing an array with a single number. So I altered my formula field to explicitly cast the lookup field to a string and then a number. The resulting formula:
{Completion (Lookup)} & "" + 0
Jun 14, 2024 04:49 PM
This comment just saved me so headache and frustration - THANK YOU!!!!!
Jul 08, 2024 06:01 AM
Seems like this can be caused by various issues. Check your formulas and fields. Potentially it's related to: