Displaying Data from Google sheets Query. He...

data
(Emma Nixon) #1

Displaying Data from Google sheets Query.

Hello all. Leads Management App. I’ve got my app working perfectly. Now I’m creating a dash board to show some “Pivotal” tables for reporting, such as Quarterly, daily averages, etc.

My data source is Google sheets, so I normally just do a bunch of google queries to display the data in the way that I want.

I’ve created a sheet for each table, so that the tables are clearly defined and added the table to my app. Now one of them is working perfectly fine, but I noticed some weird behavior on one of the tables. It seems its reading the bottom row as the column headers instead of the top row. I’v regenerated it a few times, but keep getting the same result.

Attached pic of actual data source and how it was generated in appsheet.

Any ideas?

#2

Hi Have you tried making your top row of headers bold so appsheet knows where the headers are? Check this article out https://help.appsheet.com/data/data-the-essentials

(Aleksi Alkio) #3

And if that doesn’t help, instead of using number use month names.

(Emma Nixon) #4

UPDATE. I think it was because the column headers were numbers. I was

originally Month number (for the purpose of sorting).

I changed it to a string “01 - Jan”, “02 - Feb” etc. and its working now.

(Emma Nixon) #5

@Aleksi_Alkio Yup just figured it out thnks!

(Aleksi Alkio) #6

May I ask where do you need that order?