+ Start a Discussion
Coral RacingCoral Racing 

Is it Possible to have 2 x Field Updates to update the same field without cancelling each other out ?

Hi

I have a workflow that has 2 formula field updates updating the same custom field.  The reason I have 2 field updates is because the formula is greater than 5000 characters so I had to split it into 2 formula field updates.

As follows

Formula Filed Update 1
(CASE(BMCServiceDesk__FKServiceOffering__r.Name,
"Super Risk","HEAD END",
"Risk", "HEAD END",
"Coral Connect", "CONNECT",
"OBR Wallet Integration Web Services", "CONNECT",
"Workplace Portal","SSBT",
"SAM (Workplace)", "SSBT",
"BGT", "SSBT",
"FOBT", "FOBT",
"FOBT EPSOM", "FOBT",
"Chatsworth Scanner 8500", "PC",
"Shop Tablet", "PC",
"Tablet Application", "PC",
"Nexus 7", "PC",
"Star TCP 100 Printer", "PC",
"PC In Shop", "PC",
"PC NFC Reader", "PC",
"PC In Shop Base Unit", "PC",
"PC In Shop Monitor", "PC",
"PC In Shop Mouse", "PC",
"PC In Shop Keyboard", "PC",
"PCIS Application", "PC",
"TIM30","PC",
"CMS Application", "PC",
"Automatic Cash Management", "PC",
"HIVE", "PC",
"BIP Retail", "BIP",
"BIP Screen", "BIP",
"BIP In Shop", "BIP",
"BIP NFC Reader", "BIP",
"BIP Terminal", "BIP",
"BIP Perform Decoder", "BIP",
"BIP Zone", "BIP",
"BIP BetRadar Decoder", "BIP",
"BIDS Head End Server", "BIDS",
"BIDS central Service", "BIDS",
"BIDS DataCast", "BIDS",
"Television", "BIDS",
"Coral TV", "BIDS",
"Gantry Screen", "BIDS",
"Standalone Screen", "BIDS",
"Main Screen", "BIDS",
"CIT", "BIDS",
"TOTE GATEWAY","EPOS",
"CES Manager", "EPOS",
"ERD", "EPOS",
"Auto Transfer", "EPOS",
"RAS Server", "EPOS",
"CES Manager", "EPOS",
"ITERM", "EPOS",
"ITERM Scanner", "EPOS",
"ITERM Printer", "EPOS",
"ITERM Hard Drive", "EPOS",
"ITERM Monitor", "EPOS",
"ITERM Application", "EPOS",
"ITERM NFC Reader", "EPOS",
"ITERM Keyboard", "EPOS",
"SIS Dish", "SHOP INFRASTRUCTURE",
"SIS Primary Receiver", "SHOP INFRASTRUCTURE",
"SIS Secondary Receiver", "SHOP INFRASTRUCTURE",
"SIS In Shop Service", "SHOP INFRASTRUCTURE",
"PDQ Terminal (Chip and Pin)", "SHOP INFRASTRUCTURE",
"SKY In Shop Service ", "SHOP INFRASTRUCTURE",
"SKY Receiver", "SHOP INFRASTRUCTURE",
"SKY Dish", "SHOP INFRASTRUCTURE",BMCServiceDesk__FKBusinessService__r.Name))


And formula field update 2
IF(CONTAINS(BMCServiceDesk__FKTemplate__r.Name , "Redirect"), "REDIRECTION",
IF(BEGINS( BMCServiceDesk__FKServiceOffering__r.Name , "BIDS"), "BIDS",
IF(BEGINS( BMCServiceDesk__FKServiceOffering__r.Name , "CORAL PLUS"), "BIDS",
(CASE(BMCServiceDesk__FKBusinessService__r.Name ,
"Coral Connect (Multi Channel)", "CONNECT",
"NETWORK SERVICES", "HEAD END",
"SHOP NETWORK AND TELEPHONY","SHOP INFRASTRUCTURE",
"TELEPHONY SERVICES", "HEAD END",
"TRADING DATA FEEDS", "AMELCO",
"TRADING SYSTEM", "AMELCO",
"CORAL RETAIL DATA FEEDS", "AMELCO",BMCServiceDesk__FKBusinessService__r.Name))
)))

What I am finding though that one is cancelling the other out.  So only the second formula is actually updating the field how I want it to, the other formula is just showing up as BMCServiceDesk__FKBusinessService__r.Name

Any ideas how I can stop s from happening?

The end result is to have the data as a summary report
Best Answer chosen by Coral Racing
Parker EdelmannParker Edelmann
One plan is to shorten your formula so it can all fit in one action. You have "CES Manager", "EPOS" in there twice, you could also use contains and begins functions inside if functions like you did in formula 2. I noticed that anything that began with ITERM was given the value EPOS. Look for that kind of thing in the formula. Another idea is for the else criteria of formula 1, leave it blank, change formula 2 to a time dependant action (only for the sake of making sure it acts after formula 1. If there's a better way to do that, do it), and add this to it:
IF(ISBLANK(Custom_Field__c), Insert formula 2 here, Custom_Field__c)
I'm not sure why the first formula isn't working, but these are some ways that may work. Thanks for reading my answer, and I hope it helps.

All Answers

Parker EdelmannParker Edelmann
One plan is to shorten your formula so it can all fit in one action. You have "CES Manager", "EPOS" in there twice, you could also use contains and begins functions inside if functions like you did in formula 2. I noticed that anything that began with ITERM was given the value EPOS. Look for that kind of thing in the formula. Another idea is for the else criteria of formula 1, leave it blank, change formula 2 to a time dependant action (only for the sake of making sure it acts after formula 1. If there's a better way to do that, do it), and add this to it:
IF(ISBLANK(Custom_Field__c), Insert formula 2 here, Custom_Field__c)
I'm not sure why the first formula isn't working, but these are some ways that may work. Thanks for reading my answer, and I hope it helps.
This was selected as the best answer
Coral RacingCoral Racing
Thanks Parker

Following your advice I amanged to get this into one formula meaning I no longer needd a workflow to update the field .  Many thanks
Parker EdelmannParker Edelmann
You're welcome, I just wanted to help where I could.