Skip to main content

My org sends paper donation thank you letters using DrawLoop, which is a great integration.

 

The tricky part is that we have several "extra" fields on the Opportunity record which, if they are filled in, need to show up in the thank you letter, along with some extra text: In Memoriam, Financial Intermediary, In-Kind Description.

 

To make the thanking process as simple as possible for our non-technical volunteer staff, I have a Thank You button right on the Opp record that goes directly to the merged Word document , using a single merge template document- no having to choose the correct Word template (like, one template for "In Memoriam", another for "In-Kind", etc - this wouldn't work anyway because there can be various combinations of these "extra" fields).  This approach also makes it easier to change the template's boilerplate since I have only one.

 

To achieve this simple setup, I use Word's IF capability to check if these "extra" fields are empty or not, and insert the appropriate merge field and extra boilerplate text if appropriate.

 

Now we get to the problem: I find Word's IF field code feature really hard to test and use.  Whenever I make a change to any field codes using IF, it seems like I break things - the IF doesn't work, formatting the text damages the field code,  testing the code is tedious, etc.

 

Is there a better way than using IF?  I suppose I could create a series of formula fields on Opp that generate the necessary merge text fragments, or generate blank, and merge these fields into Word without using IF.  Is that a better way?  Maybe I just need to learn how to use Word's IF better?  How do you solve this issue?

 

@Nonprofit App Advice and Reviews @Nonprofit Success Pack @Salesforce.org System Administrators 

5 risposte
  1. 23 gen 2017, 23:38
    If you have the business level of Drawloop, Drawloop should also be able to handle those conditional cases. It's useful if you have a lot of fields with this issue and you don't want to create a bunch of Salesforce formula fields to handle it.