![]() ![]() You should now have populated your sheet with data from TUJ! ![]() Select the Cell you want this table to be created (A1) and click on the blue “ Get Data to Table” button in the sidebar. ![]() Select Database query and paste the query I attached. In the sidebar you should now have 2 options, Database query and Data Source. Feel free to adjust this query to your needs This will give us the historic daily price information of all these BFA Fish for Doomhammer EU. JOIN tblRealm RLM ON RLM.house = IHD.house JOIN tblDBCItem DBItm ON IHD.item = DBItm.id Unfortunately, this is not something I can help you with, but maybe some other people can help with that or you could visit to learn more about SQL! For the purpose of this tutorial we shall use the following SQL Query: Next part of this tutorial will be constructing an SQL to get the data out. A green notification “Connection successful” should present next to the button. Username: DBGoblin (can be anything BUT blank – example: your username)Ĭlick on “ Test Connection” to make sure we can connect to the DB. Select “ Database” from the list of available data sources.ĭB Address: A new side panel should pop-up on the right side. Navigate to Add-ons -> Supermetrics and click on Launch. If you have any other preference, go ahead and use that! Feel free to chime in should you have any suggestions! You can find more information about TUJ’s MySQL DB as well as very nice tutorials in PHP ! Please consider donating or subscribing to them!Īlthough there might be several add-ons to connect MySQL databases, I will use one called “Supermetrics”. This is Austin….kidding-kidding! It seems that it is quite a common request how to connect your google sheets to the TUJ DB so I figured I will share my way. ![]()
0 Comments
Leave a Reply. |