Why Tidy The Data?

The data comes from multiple sources

This means that not all fields are always filled consistently

It can also mean similar spellings of what is basically the same data

The majority of the data is in lists, so cleaning the lists makes the app easier to use

What Can I Tidy?

Each list can be manually tidied individually

The Title and Series Text can be cleaned for consistency

How Do I Tidy The Lists

settings screen

From The Settings Screen

clear lookups screen

This will remove all lookup values which are not currently used

settings screen

From The Settings Screen

fields screen

Choose Advanced Fields

listvalues screen

For the Field you want to tidy; choose Edit List Values

list values screen

Use the context menus on the List Values Screen to clean the values

You can delete unused values, merge values together or rename values

Remember, you cannot do anything with the 'Not Defined' value

How Do I Clean the Title and Series Text

list values screen

From The Settings Screen

capital title

remove words

capital series

ignore series

capital title

Set these clean options as required

apply settings

Apply all of these the clean settings to all Games in one go

Remember, you can also edit the individual Series List Values

'Game Shelf' developed by Dion Hardy © 2011-2020, All rights reserved
These web pages use css and do not use cookies     (Apps Privacy Policy)