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.