MYSQL Connector in Google Sheets Addon, unwanted column names as first-row

  • 44Views
  • Last Post 4 weeks ago
0
votes
mercerdomains posted this 27 August 2022

When using the Google Sheet Query addon, and a MYSQL connector, I keep getting the first row set to the column names, even if they are already there from the initial query, and any subsquent refreshes add it again.  Furthermore, query filters do not work for removing this. They still show up every time a query or refresh is run. I am driving myself bonkers trying to figure out how to prevent or eliminate this behavior. What would be fantastic is a way to remap the column names to a header row, or an option to not insert column names as first result row.  

Order By: Standard | Newest | Votes
0
votes
Serhii Muzyka posted this 29 August 2022

Hi,

Thank you for contacting Skyvia Customer Support.

To understand your situation, we need more details. Please send us screenshots where we can see column names and filters you added. 

 

We are looking forward to hearing from you.

 

Best regards,

Serhii

Technical Support Engineer

0
votes
mercerdomains posted this 5 weeks ago

 

There, as you can see, it clearly inserts the column names into the first row of the sheet, regardless of if I attempt to filter them out or not. I feel like this behavior is easily reproducible outside of my providing screenshots..   

0
votes
Serhii Muzyka posted this 4 weeks ago

Hi,

Thank you for screenshots.

 

For this case, we had "Use current cursor position as the first cell of the table" setting, but it's currently under development. Once this setting is available again, we will let you know. Unfortunately, we cannot give you any time frames.

 

Should you have other questions, don't hesitate to reach out.

 

Best regards,

Serhii

Technical Support Engineer

0
votes
mercerdomains posted this 4 weeks ago

What needs to be a setting, is "Insert Column names as First Row data" and have that be a checkbox. Thats really what I want. 

Or even "Use First row results as column names" as the table contains the preferred column names as the first row data, but due to issues with plugins that work with the sheet, I need to keep them as they are, as they push any sheet changes to the db via appscript webhook.  If skyvia could synchronize the sheet to the DB for me, then I could name the columns as desired and not have this headache. 

0
votes
Serhii Muzyka posted this 4 weeks ago

Hi,

 

We are really sorry that we cannot come up with a quick solution of your situation.

We will hand over your suggestion to our team and will keep you posted.

 

Best regards,

Serhii

Technical Support Engineer

Close