topic Re: Longtime Demand Tools user in DemandTools

Longtime Demand Tools user

bhare1357 — Tue, 31 Jan 2023 21:26:44 GMT

Hi all - as I mentioned in the subject - have used Demand Tools a number of times over a number of different jobs over the years. I love Demand Tools because of it is power. At one career stop I was able to take all of the states in Salesforce and turn them into two letter abbreviations thorughout my company's Salesforce org - very cool and very helpful!!

If I can help out I will do my best to jump in and try to contribute some answers!

Bill

Re: Longtime Demand Tools user

SummerinGreece — Wed, 01 Feb 2023 13:52:41 GMT

@bhare1357 we did the exact opposite 🙂
switched from state abbreviations to full names to accomodate Europe as well

Re: Longtime Demand Tools user

bhare1357 — Wed, 01 Feb 2023 13:54:21 GMT

@SummerinGreece - Interesting! 😀

Re: Longtime Demand Tools user

AnthonyValidity — Wed, 01 Feb 2023 13:57:38 GMT

Hi @bhare1357 (Bill),

I'm happy to see you've joined our community since you have years of experience! I love it for the same reasons and mentioned in another post of mine about how Modify can really get the job done with existing data. In DemandTools V (DTV) we now have over 127 formulas to use - one of them being the state standardization formula!

StateMatchShortName(state, useFuzzy)

StateMatchLongName(state, useFuzzy)

The above are the two preinstalled formulas we have with DemandTools V (DTV) which can use fuzzy match to find misspelled states as well.

Again, so happy you're here!

Regards,
Anthony

Re: Longtime Demand Tools user

LFoster — Mon, 06 Feb 2023 20:11:36 GMT

I agree! I am excited to share with new users and watch them realize the potential uses of the tool. DT saved a small team a month long project of adjusting the case of account names. It was done in 15 min. They were so excited!

Re: Longtime Demand Tools user

Beth_bohl — Mon, 03 Feb 2025 21:08:48 GMT

Any idea why this formula isn't working? StateMatchShortName({mailingstate}, UseFuzzy) The error message is that there's an unknown variable UseFuzzy at position 45.

Re: Longtime Demand Tools user

Pugs_Validity — Tue, 04 Feb 2025 19:42:59 GMT

@Beth_bohl - You'll need to instruct the formula whether you want to use the Fuzzy criteria or not. So the choice would be beteween StateMatchShortName(${mailingstate}, FALSE) or StateMatchShortName(${mailingstate}, TRUE)

Re: Longtime Demand Tools user

Beth_bohl — Tue, 11 Mar 2025 16:01:04 GMT

Thanks so much for responding! I am just now returning to this after a busy month. I initially rec'd an error on the $ sign, so I removed that. I am next getting an error stating there's an unknown value FALSE at position 42 with StateMatchShortName({mailingstate}, FALSE) . I get the same error if I use TRUE. If I use the out of the box formula StateMatchShortName({mailingstate}, UseFuzzy), I get the same error on UseFuzzy.

Re: Longtime Demand Tools user

Beth_bohl — Tue, 11 Mar 2025 16:05:58 GMT

When I use the preinstalled formulas and use the insert field function to add the field i get this: StateMatchShortName({mailingstate}, UseFuzzy) But I'm getting an error message that there's an unknown variable UseFuzzy at position 45.

BTW, I absolutely love DemandTools. It saves me hours of time to keep our data squeeky clean!

Re: Longtime Demand Tools user

Pugs_Validity — Wed, 12 Mar 2025 13:13:45 GMT

@Beth_bohl - You need to give a response for the UseFuzzy portion. So you'd need to use either StateMatchShortName({mailingstate}, TRUE) or you can remove it all together, StateMatchShortName(${mailingstate}), or just change it to FALSE if you don't want to use Fuzzy Matching, StateMatchShortName(${mailingstate}, FALSE).