Advanced Lists
In some cases, using a standard list may not offer you enough flexibility for your dynamic data. With advanced lists, you can create your own data fields!

If you need more fields for your users to fill out when adding a list item, not a problem, just choose the data type, text length and give it a name and the next time an editor adds a list item, they'll be able to fill out the field with data.

Taking it a step further, you can also create global data types, a type you can add to a data list which has your own values to choose from for you editors. For example, you could create a data list called "location" which holds the values north, south, east and west. Then another global field called "disciplines" you can a range of values to represent different gymnastic types such as "men's artistic", "school gymnastics" and so on.

When you create the data fields for the list, you can specify the global data type to be added and choose whether it can be selected as multiple (check box) or as a single value (drop down list).

The end result then looks like this: (WG Clubs Home)

But it doesn't end there. With the data stored, as a designer you have the ability to use our basic SQL query language to perform searches on your data within an advanced list. How about returned only unique matches, or results that include or exclude a value?

Returning to Welsh Gymnastics, in this example when you click on a location, the results are matched in the database by the link you've clicked, in this case, all clubs in the "north".

With your data structure set, and content added, you could also use that data in external applications. How about mashing up the postcode entered for a club and using that to find it's location in Google map like in this example?

Using a combination of standard and advanced lists, you can soon build up a rich array of data managed using the CMS.