{"id":34616,"date":"2021-04-28T09:31:45","date_gmt":"2021-04-28T09:31:45","guid":{"rendered":"https:\/\/wpdatatables.com\/?p=34616"},"modified":"2024-02-20T09:40:48","modified_gmt":"2024-02-20T09:40:48","slug":"weather-table","status":"publish","type":"post","link":"https:\/\/wpdatatables.com\/weather-table\/","title":{"rendered":"How to create a weather table with wpDataTables"},"content":{"rendered":"

You’ve surely seen a weather table online, but have you ever tried to build one?<\/p>\n

Surely, it would seem a dreadful experience with all the data and conditional formatting that you’d need to add to the table cells.<\/p>\n

Do you know how they say there isn’t such thing as bad weather, only unsuitable clothing?<\/p>\n

The same goes for building a weather table. If you can’t create one, it means you don’t have the right tools for the job.<\/p>\n

In this article, I’ll go over creating a weather table with wpDataTables, the #1 WordPress plugin for creating tables and charts.<\/p>\n

<\/p>\n

What kind of weather table can we create? Well, something like this:<\/p>\n

Yes, that is a really long screenshot. You can view the dynamic weather table here<\/a>.<\/p>\n

For creating a weather table like the ones we presented earlier, you have few options depending on your source data.<\/p>\n

1. Creating a table from scratch<\/strong><\/h3>\n

If you do not have a data source you can create your weather table from scratch with the option \u201cCreating tables manually\u201d<\/a> where you will insert data manually.<\/p>\n

To start creating a data table manually, open your WordPress admin panel, go to wpDataTables -> Create a Table<\/strong>, choose the third option \u201cCreate a table manually\u201d<\/strong>, and click \u201cNext\u201c<\/strong>.<\/p>\n

You will be shown the wizard step that will assist you to create the table structure where you will create 14 columns: Period, Year, and all other will be names of the months (Jan, Feb…). For Period columns you will leave column type as \u201cOne-line string\u201d<\/strong> and for all others, you will set \u201cInteger\u201d<\/strong> column type.<\/p>\n

When you have finished configuring the table, click \u201cCreate the table\u201d<\/strong>. A dropdown will open with options to \u201cOpen in standard editor\u201d<\/em> or \u201cOpen in Excel-like editor\u201d<\/em> and that\u2019s it. The table structure is created. Now you will insert your data over the Standard editor <\/a>or an Excel-like editor<\/a>.<\/p>\n

2. Creating a table from a data source<\/strong><\/h3>\n

If you have data in some data source like Excel, CSV, JSON, Google spreadsheet, XML, PHP Serialized array, or in a table in the database (SQL source), you will use the second option in the table wizard.<\/p>\n

To start creating a data table linked to an existing data source, open your WordPress admin panel, go to wpDataTables -> Create a Table<\/strong>, choose the second option \u201cCreate<\/strong> a data table linked to an existing data source.\u201d<\/strong>, and click \u201cNext\u201c<\/strong>.<\/p>\n

Depends on which source you have you will follow instructions:<\/p>\n