https://sites.secure.force.com/success/questionDetail?qId=a1X30000000HZAREA4
I've now got my custom field and WFR programmed, and have the handy Chrome "converter" tool up and running. But .... have a monthly upload that I fear by the time Mar comes along, all accounts won't have had the 18 digitid number WFR triggered to populate it for all. I am a SQL programmer, so was playing around with the conversion formula to just populate this new "18 digit id" after I batch calculate the conversion formula in SQL and re-import the results back in SF.
Anyone done this in SQL? If so, I'd be curious to see what approach you used...
1 个回答
If I make a new WFR I need to execute across all records of an object, I'll pull the whole table down with the Excel Connector (or do it in chunks if you're got crazy amounts of records) and then force an update across the whole table. This makes the WFR evaluate itself, and then provided it's set in the "Every time a record is updated or created" setting, you should be set going forward.
