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!
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.
@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)
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.
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.
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!
@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).
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!
