Jun 15, 2023 08:12 AM
I have table with many fields, all set to Simple String, and the automation simply logs all the payload from a web hook. I periodically but inconsistently get the dreaded "Fields" could not be converted to a string error. I am trying to troubleshoot WHICH field it is given, but I am not able to find any additional details in the run history other than "Fields" could not be converted to a string. Is there a log somewhere where I can see exactly where the error occurred so I can troubleshoot and fix the error? Or are we simply left to guess where the error occurred?
Jun 15, 2023 08:23 AM
Sometimes Airtable error messages are helpful, sometimes not so much.
Can you provide screen shots?
- The error message itself
- The configuration of the automation
- The payloads that are being received (both successful and unsuccessful)
- The fields themselves (including field type)
Jun 15, 2023 08:54 AM
I created a Loom video so that it is clear what the issue is. https://www.loom.com/share/7903929c7d054a51a0af764dfe651674?sid=67a0c135-240f-4fbe-b16a-ed8768bd2a34 It's odd that when an automation runs SUCCESSFULLY, all the details of each of the fields that ran are all listed, but when there is an error, no detail is provided. I appreciate your help in trying to more quickly troubleshoot errors.
Jun 16, 2023 08:05 AM
To clarify, what I am asking is, is there a more detailed error report where I can better pinpoint where the issue is arising? Or is Airtable set up so details of an error are not logged?