🧵 Hey team - running into an issue where the output of the AI formula...

·

🧵 Hey team - running into an issue where the output of the AI formula generator is correct, but it doesn't seem to be able to replicate the same result on the table

7 comments

· Sorted by Oldest

Clay Team
APP
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Eoin C.
·
Table Link
Eoin C.
·
Row 2 is what seems to return the expected result "true" in the preview window, but won't turn to "true" on the actual table
Clay Team
APP
·
Hey Eoin, thanks for reaching out! Taking a look now!
Clay Team
APP
·
Ah, just noticed two columns have errors and why it's not working properly, the date calculations that is. Will check those formulas
Clay Team
APP
·
There we go, the issue it had is that it wasn't checking if a record existed or not in the lookup column. I added the code so it first checks if something exists or not, and then runs the other request. Should work now! Let me know if you run into any issues!
Eoin C.
·
Ah legend - thank you Arturo!

Clay Team
APP
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Eoin C.
·
Table Link
Eoin C.
·
Row 2 is what seems to return the expected result "true" in the preview window, but won't turn to "true" on the actual table
Clay Team
APP
·
Hey Eoin, thanks for reaching out! Taking a look now!
Clay Team
APP
·
Ah, just noticed two columns have errors and why it's not working properly, the date calculations that is. Will check those formulas
Clay Team
APP
·
There we go, the issue it had is that it wasn't checking if a record existed or not in the lookup column. I added the code so it first checks if something exists or not, and then runs the other request. Should work now! Let me know if you run into any issues!
Eoin C.
·
Ah legend - thank you Arturo!