When updating your app's settings, you may see the error message "Failed to complete the process. The unique field already contains duplicated values. Please remove them and try again." In such a case, you can check which records contain duplicate values by performing data aggregation using the Chart feature.

On the App settings screen, click Discard changes and click OK to abort the app settings update, then check the records with duplicate values by following the steps below.

To check which records contain duplicate values, perform the following steps.

1. Open your app.

2. Click the App settings icon (the gear-shaped icon) at the upper right of the View screen.

3. Click the Graphs tab.

4. Click the Create Graph icon (the plus sign-shaped icon) at the right of the screen.

5. Set up a chart with the following settings.

   • Name: Optional (Example: Duplication Check)
   • Chart type: Table
   • Group by (Level 1): Select a field to prohibit duplicate records
   • Function: Count (Number of Records)
   • Filter: All records
   • Sort by: Total, Descending

6. Click Save on the upper left side of the screen.

7. Click Update app at the upper right of the screen.

8. On the confirmation dialog, click Update app.

Now, display the chart you created.
If a field value is shown as having 2 or more records, it means there are multiple records that contain that field value. Click Show records and modify the field value, or consider deleting records so only one record with that field value remains.

If the error persists even though the number of records for all the field values is '1', the possible causes are as follows:

• Due to the Permissions for records settings, you cannot view records that contain duplicate values
  Check the settings and make sure that you have permission to view all records, then try the steps described in How to check which records contain duplicate values.
  For more details on the Permissions for records settings, refer to the following page.
  Configuring Permissions for Records
  
  

• There are records with duplicate values on the app's preview screen
  Open the preview screen and try the steps described in How to check which records contain duplicate values.
  To open the preview screen, click the App settings icon (the gear-shaped icon at the upper right of the View screen), open the App settings tab, and click Preview.