You need to sign in to do that
Don't have an account?
Coral 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
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
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
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.
Following your advice I amanged to get this into one formula meaning I no longer needd a workflow to update the field . Many thanks