Displaying Data from Google sheets Query. He...

(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?


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?