Skip to main content
Shraddha Gupta 님이 #Data Management에 질문했습니다
Hi All,

 

I have a requirement to update two fields based on criteria and I am not sure how I can build this up in Formula. 

 

Lets take an example -

 

1. If Country Code = AU and State Code = ACT then populate 

 

Territory Name = APAC - ANZ - ACT and Suregion = APAC - ANZ

 

2. If Country Code = AU and State Code = NSW then populate 

 

Territory Name = APAC - ANZ - NSW and Suregion = APAC - ANZ

 

so on till 52 criteria and updates. 

 

I want to use the Formula to avoid multiple assignment nodes in Before Save Flow .

 

Any help would be much appreciated. 

 

Note: Currently this is implemented in the Process Builder but since we are seeing a lot many SOQL issues hence thinking migrate PB to Flows. 

 

Thanks!
답변 5개
0/9000