Hi @freejan56
Thank you for sharing the form!
The form itself seems fine but I think one/some of the fields might need slight adjustments to make sure that they are passed over and have proper format. Let me explain.
I wasn’t familiar with Arclab Inbox2DB so I checked it and, as far as I understand, it works in such a way that you give it access to your inbox and it reads selected e-mails from it (in this case Forminator notifications), then it is parsing content of such e-mail in order to extract selected data from it and put it into the database of choice.
It’s using Microsoft ODBC database driver and the error that you are getting (the “Ungültiger Zeichenwert…” one) is coming from that DB driver.
According to this article (assuming that Google Translate translated error message correctly; unfortunately I don’t speak German), it’s related to date format:
An empty string is not a valid date/time literal and it does not represent a NULL value. An attempt to convert an empty string to a date/time value will result in SQLState 22018 error and the message “Invalid character value for cast specification”.
In other words, the error suggests that the date the DB driver gets is either empty or uses incorrect format.
In the Inno2DB app you should be able to check logs. Is this error the only one that it shows or does it give some more details by any chance? Specifically, does it show the data that this error is related to or, at least, the DB field name?
Could you check it please?
Also, are you able to share content (just make sure to mask sensitive data such as e-mail address, full name, phone number from it) of some example e-mail that Inbox2DB wasn’t able to process (that gave this error)?
Basically, we need to find out about that data (most likely date) that results in error and that, hopefully, will help make adjustments to either Forminator field settings or its e-mail notification configuration.
Best regards,
Adam
