topic Dedupe Field Rule Scoring for Picklist - Do I need to make a condition for each value? in DemandTools

Dedupe Field Rule Scoring for Picklist - Do I need to make a condition for each value?

michael-wtds — Mon, 30 Oct 2023 17:17:00 GMT

When using Custom Scoring with Field Rules on a picklist, if I need to make sure the highest value based on our sort order is retained, do I need to assign a value to each picklist value? Or is there an easier way to do this?

In the example shown below, I started with:

Status = "" -1
Status = New +1
Status = Prospect +2
Status = Contacted +3

If I have 10 total values, due to different options for different record types, then I have to create a condition for each value.

Re: Field Rule Scoring for Picklist - Do I need to make a condition for each value?

lydiam8 — Mon, 30 Oct 2023 17:04:23 GMT

I ran into this too, and couldn't find anotehr way other than listing every single option.

Re: Dedupe Field Rule Scoring for Picklist - Do I need to make a condition for each value?

michael-wtds — Mon, 30 Oct 2023 17:17:57 GMT

Note, I added Dedupe to the original post question to clarify which module this applied to.

Re: Dedupe Field Rule Scoring for Picklist - Do I need to make a condition for each value?

AnthonyValidity — Mon, 30 Oct 2023 17:21:05 GMT

Hi @michael-wtds,

The only way I know how to do this is what you did above. You'll want the most ideal value to win based on a score.

Regards,