My If-Then-Else is all working correctly, however, in some cases, the entirety of the text that should be showing, is not. Do you happen to know why that would occur?
Hi! To clarify: is it that field values aren't displaying at all for some of your records, or are some of your fields truncating at, for example, 255 characters?
My if then else is not working. Can you tell me why? It includes the else paragraph in all letters. I used the rules, if-then-else. What I want is to say if lettercode = ESNH-2022ThankYou then insert this paragraph. Else insert this other paragraph. When merging with letters, it is not working. It uses the Else text in all letters. Can you help?
If I've understood correctly, I think you might have a formatting issue. What you describe - having two paragraphs ready to go, and deciding which to display based on the data - is something I cover in the full course in an Intermediate Topics lesson called "Conditionally display static text." In your case, the static text is the paragraphs. You can find the full course on Teachable: bloudesigns.teachable.com/p/formatting-and-reporting-csv-form-and-survey-data-for-easy-review-discussion-and-record-keeping Using your example, that would translate to: { IF { MERGEFIELD lettercode } = "ESNH-2022ThankYou" "your THEN paragraph" "your ELSE paragraph" } Take careful note of all of the spaces and all of the quotation marks. In this criterion check, the lettercode has to match the comparison string exactly, including any spaces. To be sure you've got the comparison string correct, you can always paste in a sample directly from the Data Source file. Let me know if that helped. If not, maybe we can sort it out in a quick Zoom with a screen share. You can book that on my Calendly: calendly.com/bloudesigns
This is a rare video to find -- Thanks. If youc an make a video on how to change content conditionally based on a value in a combo box, it will be appreciated.
You're welcome! As for your question about combo boxes, I've found that people sometimes use that as a catch-all to describe different scenarios. Which one do you mean? (a) a single-select list of predefined options (like a dropdown list that lets you select one thing, and you could use the same document logic for a radio button control) (b) a multi-select list of predefined options (like checkboxes that let you check off multiple answers to the same question) (c) one where folks are allowed to add their own option to the list (might be used in conjunction with a or b) When you know the options that folks might select from because they've been predefined, you should be able to build on what I've covered in this video to check for those values in those fields and display/change document content accordingly. In the full course (hosted on Teachable), I've got some intermediate video lessons that might address your scenario. The video you watched here is the precursor to those videos: * Conditionally display static text (e.g., use data to determine which requirements to list before listing user responses that you're checking against those requirements) * Conditionally display fields with labels (i.e., only display the label and related data if certain other conditions are met) * Conditionally display document sections (i.e., your mail merge template could contain all of the sections you need for all possible variations, but you only display the ones you need based on the data values) * Conditionally display hyperlinks * Conditionally skip entire responses using SKIPIF There are also a couple of lessons for only performing calculations under certain circumstances - as determined by the options selected in the data. If you're interested in the full course, here's the link: bloudesigns.teachable.com/p/formatting-and-reporting-csv-form-and-survey-data-for-easy-review-discussion-and-record-keeping
