Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2022, 12:21 PM
new user new user is offline Nested Fields using Conga for Salesforce Windows 11 Nested Fields using Conga for Salesforce Office 2016
Novice
Nested Fields using Conga for Salesforce
 
Join Date: Dec 2022
Posts: 3
new user is on a distinguished road
Cool Nested Fields using Conga for Salesforce

Hello all,
I have a question. Hopefully you can help. I am using conga for salesforce. I need to wite an if condition something like this:

if FieldA >=140 and FieldB >=90 then FieldA-FieldB get red color
if FieldA between 120-139 and FieldB between 80-89 then FieldA-FieldB get yellow color


if FieldA < 120 and FieldB < 80 then FieldA-FieldB get green color



thank you in advance
Reply With Quote
  #2  
Old 12-15-2022, 03:13 PM
Guessed's Avatar
Guessed Guessed is offline Nested Fields using Conga for Salesforce Windows 10 Nested Fields using Conga for Salesforce Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

For those of us that don't have either Conga or Salesforce...
Is this a mail merge you are trying to setup the merged fields for?
Or are you looking for vba code to post-process a document after content has been applied?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 12-15-2022, 03:18 PM
new user new user is offline Nested Fields using Conga for Salesforce Windows 11 Nested Fields using Conga for Salesforce Office 2016
Novice
Nested Fields using Conga for Salesforce
 
Join Date: Dec 2022
Posts: 3
new user is on a distinguished road
Default

Yes, it is a merge field. actually, you are right it is kind of more Microsoft word if condition question
Reply With Quote
  #4  
Old 12-15-2022, 03:29 PM
macropod's Avatar
macropod macropod is offline Nested Fields using Conga for Salesforce Windows 10 Nested Fields using Conga for Salesforce Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

There are conditions that your outline hasn't addressed. For example:
• FieldA < 120 and FieldB >= 90
• FieldA >=140 and FieldB < 80
And, when your say FieldA-FieldB gets coloured, is this a subtraction of FieldB from FieldA, and the result gets coloured or do you want both FieldA and FieldB coloured without subtraction?

PS: Please don't post questions about the same issue in multiple threads. Discussions merged.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-15-2022, 03:34 PM
new user new user is offline Nested Fields using Conga for Salesforce Windows 11 Nested Fields using Conga for Salesforce Office 2016
Novice
Nested Fields using Conga for Salesforce
 
Join Date: Dec 2022
Posts: 3
new user is on a distinguished road
Default

sorry it is not subtraction. output will be sometging like this 115-80

And Macropod, based on the requirement I will not need to have these two conditions. Thank you for taking a look at my question.

{If FieldA >= 140 {If FieldB>=90 " FieldA-FeildB"}
{If FieldA < 140 {If FieldB<90 "FieldA-FeildB"}
{If FieldA<120 {If FieldB <80 "FieldA-FeildB"}}

i did something like this but did not work
Reply With Quote
  #6  
Old 12-15-2022, 04:02 PM
macropod's Avatar
macropod macropod is offline Nested Fields using Conga for Salesforce Windows 10 Nested Fields using Conga for Salesforce Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The examples I gave of conditions not catered for in post #4 were just two or numerous possibilities that you hadn't addressed and, without knowing about what is expected of them, we can't provide a solution. You need to tell us what the expected output is for all 9 possible results:
• A < 120 & B < 80
• A >= 120-<140 & B < 80
• A>= 140 & B < 80
• A < 120 & B >= 80-<90
• A >= 120-<140 & B >= 80-<90
• A> 140 & B >= 80-<90
• A < 120 & B > 90
• A >= 120-<140 & B > 90
• A>= 140 & B > 90
So far, you've managed to address only 5 of the 9 possible results.

Cross-posted at:
Nested if condition - MS Answers
if statement - Conga Salesforce nested if condition - Stack Overflow
For cross-posting etiquette, please read: A message to forum cross posters - Excelguru
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested Fields using Conga for Salesforce “nested” IF/Then with Mergefield, utilizing Conga and Salesforce links. aronfromct Mail Merge 7 05-16-2017 05:39 AM
Nested Fields using Conga for Salesforce Nested IF TDWolsey Excel 2 01-06-2016 11:31 PM
excel data from salesforce excelstone Excel 1 11-07-2015 01:11 AM
Nested Fields using Conga for Salesforce Business Contact Manager not loading, instead it's Salesforce RobinE Outlook 5 09-18-2012 04:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft