User Manual
How can we help?
Full Site Search

Mass Update Records

x
Mass Update Records

Update

Search and Replace

If you don't see any options featured below on your database sheets, it may be related to the access rights you are granted. If you have any questions about your access rights or not being able to modify entries on a sheet, please contact your SYSAdmin of the database to check for the proper access rights configurations.

If you have Admin or survey user access right on the sheet and would like to mass update your records for updating a field with same values, replacing a certain string with other string to all filtered entries, you may use Mass Update.

Update

Update can help you update all records with certain values, and only filtered records will be edited.

After clicking the Mass Update option under the Tools menu, you will be presented with a pop-up window where you can choose a field to be updated and enter a new value for the field.

During this step, if your field is a selection field, please make sure that you're using the same spelling as your value options in your database design. If you are updating more than one field value for the same filter, you can add new options with the + sign.

After confirming, your mass update will start. The database will update in the background. During this time, you may proceed to use the database.

Search and replace

Search and replace helps you search for certain strings in a Free Text Field and replace them with other strings. Please note that if filter is applied to the field, only the filtered records will be edited.

Click the Mass Update option under the Tools menu and select Search and replace. You will be presented with a window where you can choose a field to be updated. Then, enter the strings you want to search and the strings you'd like to replace them with.

If you are updating more than one field value for the same filter, you can add new options with the + sign.

After confirming, your mass update will start. The database will update in the background. During this time, you may proceed to use the database.

Note: Please keep in mind that the detailed history of the data modification done by this feature won't be recorded into entry information.

Top of Page Table of Contents

Start Ragic for Free

Sign up with Google