Hi All,
This might be completely impossible but I’m trying to get rid of duplicate linked field values. Is there any way I could force it to do this via scripts? The dedupe app doesn’t quite do what I need it do and although this can be acheived via a rollup column, the values are now not linked. I know this isn’t a native feature so I’m trying to find a work around because I can’t generate neat pivot tables at the moment.
Some advice would be much appreciated.
Hi Jay - if you’re looking for a No-Code approach to doing this, our On2Air: Actions product has a Function that can calculate the unique items in any array field (linked records, multi-select, lookups) and store them back to the same field as the unique, or into another field if needed.
Check out details here: Function - Arrays | On2Air Support
and here: https://on2air.com/on2air-actions
This is pretty straightforward to do with the Scripting app, you just need to specify how exactly are you determining the undesirable duplicates. Do you want all but the oldest removed? Is the record.name/primary field the only identifier that matters?
Hi,
If you need a ‘deduped’ list of names in your Owner field, add ‘Owner’ as lookup field and create new formula field with ARRAYUNIQUE( {Owner lookup} )
If you need something else, you should explain more, because it’s not clear.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.