After searching around for a while, I have not been able to find a script with the function of finding duplicates within one cell.
I have found workarounds with Airtable automations, the only task holding me back now is the script.
In this case, I want to be able to find and copy duplicated values from a cell (formula cell) into another cell (link to… cell).
Image 1: Here you can see the structure of the table. Column 4 (Concatenated (FORMULA)) combines the values from column 2 and 3 (Outcome 1 and 2) into one cell.
I wish to identify the duplicates within cell “concatenated” and return the duplicated variables to the column cell “Duplicate” (Sample 1) (Notice that the cell “Duplicate” is formatted as “link to…” cell).
IMPORTANT: IF there is more than 1 duplicate, I want to return all duplicates into cell “Duplicate”. (Sample 2) I wish to make this process automatic.
Outcome 1 and 2 are results we receive automatically from an online form. Airtable automatically concatenates outcome 1 and 2. However, I wish to automate the duplicate finder. For this, I would need a Java expert to create a script for Airtable.
- Find duplicates within a cell and return duplicates in another cell
- Copy a value from a “formula” cell and copy it to a “link to…” cell automatically when updated.
- If multiple duplicates, show all.