#GoogleSheets query failure, parsing column value as number instead of text

1 messages · Page 1 of 1 (latest)

late raptor
#

Hi! Can you share a screenshot of the query and of the evaluated value?

whole shale
#

@late raptor ^^

late raptor
#

Can you share a screenshot with some sample data? What values do you have for sku_text in your sheet?

whole shale
#

Sample values in sku_text field

Bolan
97862

late raptor
#

Got it. This seems to be a bug.
In the first row of your sheet, is sku_text digits only? If that's the case, can you try to put in the first row a record for which it is a text value (not only digits) and check if the query works?

whole shale
#

okay let me try

late raptor
zealous swan
#

The auto detect issue is still open. How can we force for a column data type? If AS determined a column should be Number, all string values in the column are removed

dusk raftBOT
#

Hi There!
Thanks for reaching out to us. One of our engineers will be with you shortly.

If you are stuck with an issue/error, please help us with following information.

  1. Which version of Appsmith are you on?
  2. Provide screenshots/screen recordings of the original error/code snippet.
  3. Add details about your use case and provide steps to reproduce the issue, if
    possible.
dusk raftBOT
#

Hello! I think you are facing this bug, right?
https://github.com/appsmithorg/appsmith/issues/7794
The workaround you can use for now is to use a dummy row in your data that
specifies data in the expected data type or make sure that the first row does
not contain only digits for that column.

GitHub
[Bug]-[1120]:Where condition on GSheets fails to query if there's m...

Description If a GSheet column has mixed data type (number and string) then where condition fails to query results that favour the filter condition. This is an extension of #7688 Steps to reproduce...

zealous swan
#

The bug is related indeed but title should be edited to be more generic (or close and open new one) as the datatype autodetection creates many downstream issues. User should be in control of the schema and there should be an option to freeze column definitions.

#

Actually, thinking about it, if AS could just read all columns as string, issue goes away as user can after that decide how to render/format in each Column Type + some JS in Computed Value e.g. number formatting

dusk raftBOT
zealous swan
#

Thx. Can't really upvote an issue in Github. Best I could do is thumbs up the original OP but am the only (first) one so far ...