Hi, I have a Google Sheet setup which contains hexadecimal IDs. While trying to read the whole sheet without any Conditions works just fine, I’ve been getting error Messages as soon as I query with conditions.
I narrowed the issue down to IDs ending on number ‘F’. The error message is:
“Error while interacting with value 2E42036F : Not a digit… The data type value was being parsed to was : DOUBLE”.
Any change of format in Google sheets has not solved this issue. The only Workaround for me right now is putting a space in the IDs and force Appsmith to read it as text.
Thanks in advance for any Held fixing this.