You need to sign in to do that
Don't have an account?

Count unique records rollup on lookup value
Hello, everybody.
Does anybody know how to count all values with unique field values from an object A which is in lookup relationship with object B and write this value into the field of object B (in my case that's orders of distinct customers related to a reseller, thus I try to calculate how many customers of one reseller have at least one order)
I know that SFDC doesn't allow to make lookup fields for simple lookups (not master-details), so I managed to count those lookups with use of loop in flow+ Process builder to trigger it, but I don't know how to count records with unique field values.
Does anybody know how to count all values with unique field values from an object A which is in lookup relationship with object B and write this value into the field of object B (in my case that's orders of distinct customers related to a reseller, thus I try to calculate how many customers of one reseller have at least one order)
I know that SFDC doesn't allow to make lookup fields for simple lookups (not master-details), so I managed to count those lookups with use of loop in flow+ Process builder to trigger it, but I don't know how to count records with unique field values.