Quick Replace

• Select the database that you would like to use Quick Replace on (Borrowers or Resources)
• Select 'Tools' on the menu bar at the top of the page and select 'Quick Replace...'
• You will then need to select the 'Field' that needs altering
• Select the 'Value' that is to be altered
• After the value has been selected, either type a new value into the 'Replace With' box or leave the box blank to remove the value
• Press 'Replace' to action this change

Quick Replace is to change a specific value to another. It cannot be used to replace one with multiple different values. If you wish to do this, you will need to first use Quick Search, Advanced Search or a Page View to filter the table to one group for one value change, then use the 'Filtered Records' option in Quick replace to change the required value. Then filter to another group, and change the value for the other option.

For example, if you wished to change the location of a group of resources from "Science Class" to "Physics", "Biology" & "Space", you would need to filter your list of resources first to just the resources changing to "Physics" and change them. Then you would filter to the resources moving to "Biology" and change them. Each group to be changed would need to be filtered, and done separately. 

Quick Replace can be used on Borrower records, but cannot be used to update Year Group or Tutor Group information - this must be done manually, imported via a CSV or through Wonde.