1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file 9 * to you under the Apache License, Version 2.0 (the 10 * "License"); you may not use this file except in compliance 11 * with the License. You may obtain a copy of the License at 12 * 13 * http://www.apache.org/licenses/LICENSE-2.0 14 * 15 * Unless required by applicable law or agreed to in writing, 16 * software distributed under the License is distributed on an 17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18 * KIND, either express or implied. See the License for the 19 * specific language governing permissions and limitations 20 * under the License. 21 * 22 ***********************************************************--> 23 24<helpdocument version="1.0"> 25<meta> 26<topic id="textswriter0104090200xml" indexer="include" status="PUBLISH"> 27<title xml-lang="en-US" id="tit">Defining Conditions</title> 28<filename>/text/swriter/01/04090200.xhp</filename> 29</topic> 30</meta> 31<body> 32<bookmark xml-lang="en-US" branch="index" id="bm_id3145828"> 33<bookmark_value>logical expressions</bookmark_value> 34<bookmark_value>formulating conditions</bookmark_value> 35<bookmark_value>conditions; in fields and sections</bookmark_value> 36<bookmark_value>fields;defining conditions</bookmark_value> 37<bookmark_value>sections;defining conditions</bookmark_value> 38<bookmark_value>variables; in conditions</bookmark_value> 39<bookmark_value>user data;in conditions</bookmark_value> 40<bookmark_value>databases;in conditions</bookmark_value> 41<bookmark_value>hiding; database fields</bookmark_value> 42</bookmark> 43<paragraph xml-lang="en-US" id="hd_id3145828" role="heading" level="1" l10n="CHG" 44oldref="1"><variable id="defining_conditions"><link href="text/swriter/01/04090200.xhp">Defining Conditions</link> 45</variable></paragraph> 46<paragraph xml-lang="en-US" id="par_id3145242" role="paragraph" l10n="CHG" oldref="13">Conditions are logical expressions that you can use to control the display of <link href="text/swriter/01/04090000.xhp">fields</link> and <link href="text/swriter/01/04020000.xhp">sections</link> in your document. Although the following examples apply to fields, they also apply to sections.</paragraph> 47<paragraph xml-lang="en-US" id="par_id3147171" role="paragraph" l10n="U" oldref="93">You can define conditions for the following field types:</paragraph> 48<list type="ordered"> 49<listitem> 50<paragraph xml-lang="en-US" id="par_id3151185" role="listitem" l10n="U" oldref="14">Conditional text: displays text A if the condition is true, or text B if the condition is false.</paragraph> 51</listitem> 52<listitem> 53<paragraph xml-lang="en-US" id="par_id3149289" role="listitem" l10n="U" oldref="15">Hidden text: hides the contents of the field if the condition is true.</paragraph> 54</listitem> 55<listitem> 56<paragraph xml-lang="en-US" id="par_id3145412" role="listitem" l10n="U" oldref="16">Hidden paragraph: hides the paragraph if the condition is true.</paragraph> 57</listitem> 58<listitem> 59<paragraph xml-lang="en-US" id="par_id3147515" role="listitem" l10n="U" oldref="17">Any record and next record: controls the access to database records.</paragraph> 60</listitem> 61</list> 62<paragraph xml-lang="en-US" id="par_id3149802" role="paragraph" l10n="U" oldref="18">The simplest way to define a condition is to type the logical expression directly in a <emph>Condition</emph> box using the following values:</paragraph> 63<table id="tbl_id3153537"> 64<tablerow> 65<tablecell> 66<paragraph xml-lang="en-US" id="par_id3153677" role="tablecontent" l10n="CHG" oldref="19">TRUE</paragraph> 67</tablecell> 68<tablecell> 69<paragraph xml-lang="en-US" id="par_id3152960" role="tablecontent" l10n="U" oldref="20">The condition is always met. You can also enter any value not equal to 0 as the conditional text.</paragraph> 70</tablecell> 71</tablerow> 72<tablerow> 73<tablecell> 74<paragraph xml-lang="en-US" id="par_id3155900" role="tablecontent" l10n="CHG" oldref="21">FALSE</paragraph> 75</tablecell> 76<tablecell> 77<paragraph xml-lang="en-US" id="par_id3154191" role="tablecontent" l10n="U" oldref="22">The condition is not met. You can also enter the value 0.</paragraph> 78</tablecell> 79</tablerow> 80</table> 81<paragraph xml-lang="en-US" id="par_id3147090" role="note" l10n="U" oldref="23">If you leave the <emph>Condition</emph> box empty, the condition is interpreted as not being met.</paragraph> 82<paragraph xml-lang="en-US" id="par_id3148980" role="paragraph" l10n="U" oldref="24">When you define a condition, use the same <link href="text/swriter/02/14020000.xhp">elements</link> for defining a formula, namely comparative operators, mathematical and statistical functions, number formats, variables and constants.</paragraph> 83<paragraph xml-lang="en-US" id="par_id3153638" role="paragraph" l10n="U" oldref="25">You can use the following types of variables when you define a condition:</paragraph> 84<list type="ordered"> 85<listitem> 86<paragraph xml-lang="en-US" id="par_id3155135" role="listitem" l10n="U" oldref="27">Predefined <link href="text/swriter/02/14020000.xhp">$[officename] variables</link> that use statistics on document properties</paragraph> 87</listitem> 88<listitem> 89<paragraph xml-lang="en-US" id="par_id3156273" role="listitem" l10n="U" oldref="26">Custom variables, that are a created with the "Set variable" field</paragraph> 90</listitem> 91<listitem> 92<paragraph xml-lang="en-US" id="par_id3149174" role="listitem" l10n="U" oldref="94">Variables based on user data</paragraph> 93</listitem> 94<listitem> 95<paragraph xml-lang="en-US" id="par_id3145781" role="listitem" l10n="U" oldref="28">Variables based on the contents of database fields</paragraph> 96</listitem> 97</list> 98<paragraph xml-lang="en-US" id="par_id3155916" role="paragraph" l10n="U" oldref="29">You cannot use internal variables, such as page and chapter numbers, in condition expression.</paragraph> 99<paragraph xml-lang="en-US" id="hd_id3151375" role="heading" level="2" l10n="U" 100oldref="30">Conditions and Variables</paragraph> 101<paragraph xml-lang="en-US" id="par_id3150122" role="paragraph" l10n="U" oldref="31">The following examples use a variable called "x":</paragraph> 102<table id="tbl_id3155867"> 103<tablerow> 104<tablecell> 105<paragraph xml-lang="en-US" id="par_id3147417" role="tablecontent" l10n="U" oldref="32">x == 1 or x EQ 1</paragraph> 106</tablecell> 107<tablecell> 108<paragraph xml-lang="en-US" id="par_id3147500" role="tablecontent" l10n="U" oldref="33">The condition is true if "x" is equal to 1.</paragraph> 109</tablecell> 110</tablerow> 111<tablerow> 112<tablecell> 113<paragraph xml-lang="en-US" id="par_id3145259" role="tablecontent" l10n="U" oldref="34">x != 1 or x NEQ 1</paragraph> 114</tablecell> 115<tablecell> 116<paragraph xml-lang="en-US" id="par_id3150551" role="tablecontent" l10n="U" oldref="35">The condition is true if "x" does not equal 1.</paragraph> 117</tablecell> 118</tablerow> 119<tablerow> 120<tablecell> 121<paragraph xml-lang="en-US" id="par_id3147749" role="tablecontent" l10n="U" oldref="36">sinx == 0</paragraph> 122</tablecell> 123<tablecell> 124<paragraph xml-lang="en-US" id="par_id3146345" role="tablecontent" l10n="U" oldref="37">The condition is true if "x" is a multiple of pi.</paragraph> 125</tablecell> 126</tablerow> 127</table> 128<paragraph xml-lang="en-US" id="par_id3149846" role="paragraph" l10n="U" oldref="38">To use comparative operators with strings, the operands must be bounded by double quotation marks:</paragraph> 129<table id="tbl_id3148855"> 130<tablerow> 131<tablecell> 132<paragraph xml-lang="en-US" id="par_id3151078" role="tablecontent" l10n="U" oldref="39">x == "ABC" or x EQ "ABC"</paragraph> 133</tablecell> 134<tablecell> 135<paragraph xml-lang="en-US" id="par_id3150162" role="tablecontent" l10n="U" oldref="40">Checks if variable "x" contains (true) the "ABC" string, or not (false).</paragraph> 136</tablecell> 137</tablerow> 138<tablerow> 139<tablecell> 140<paragraph xml-lang="en-US" id="par_id3153301" role="tablecontent" l10n="U" oldref="41">x == "" or x EQ ""</paragraph> 141<paragraph xml-lang="en-US" id="par_id3156120" role="tablecontent" l10n="U" oldref="90">or</paragraph> 142<paragraph xml-lang="en-US" id="par_id3156133" role="tablecontent" l10n="U" oldref="42">!x or NOT x</paragraph> 143</tablecell> 144<tablecell> 145<paragraph xml-lang="en-US" id="par_id3156112" role="tablecontent" l10n="U" oldref="44">Checks if the variable "x" contains an empty string.</paragraph> 146</tablecell> 147</tablerow> 148</table> 149<paragraph xml-lang="en-US" id="par_id3150097" role="note" l10n="CHG" oldref="45">The "equal" comparative operator must be represented by two equal signs (==) in a condition. For example, if you define a variable "x" with the value of 1, you can enter the condition as x==1.</paragraph> 150<paragraph xml-lang="en-US" id="hd_id3148791" role="heading" level="2" l10n="U" 151oldref="95">User Data</paragraph> 152<paragraph xml-lang="en-US" id="par_id3150028" role="paragraph" l10n="U" oldref="96">You can include user data when you define conditions. To change your user data, choose <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - $[officename] - User data</emph>. User data must be entered in the form of strings. You can query the user data with "==" (EQ), "!=" (NEQ), or "!"(NOT).</paragraph> 153<paragraph xml-lang="en-US" id="par_id3153124" role="paragraph" l10n="U" oldref="97">The following table lists user data variables and their meanings:</paragraph> 154<table id="tbl_id3153139"> 155<tablerow> 156<tablecell> 157<paragraph xml-lang="en-US" id="par_id3149632" role="tablehead" l10n="U" oldref="130">Variable</paragraph> 158</tablecell> 159<tablecell> 160<paragraph xml-lang="en-US" id="par_id3150662" role="tablehead" l10n="U" oldref="131">Meaning</paragraph> 161</tablecell> 162</tablerow> 163<tablerow> 164<tablecell> 165<paragraph xml-lang="en-US" id="par_id3154026" role="tablecontent" l10n="U" oldref="98">user_firstname</paragraph> 166</tablecell> 167<tablecell> 168<paragraph xml-lang="en-US" id="par_id3149953" role="tablecontent" l10n="U" oldref="99">First name</paragraph> 169</tablecell> 170</tablerow> 171<tablerow> 172<tablecell> 173<paragraph xml-lang="en-US" id="par_id3147272" role="tablecontent" l10n="U" oldref="100">user_lastname</paragraph> 174</tablecell> 175<tablecell> 176<paragraph xml-lang="en-US" id="par_id3149601" role="tablecontent" l10n="U" oldref="101">Last name</paragraph> 177</tablecell> 178</tablerow> 179<tablerow> 180<tablecell> 181<paragraph xml-lang="en-US" id="par_id3150770" role="tablecontent" l10n="U" oldref="102">user_initials</paragraph> 182</tablecell> 183<tablecell> 184<paragraph xml-lang="en-US" id="par_id3155529" role="tablecontent" l10n="U" oldref="103">Initials</paragraph> 185</tablecell> 186</tablerow> 187<tablerow> 188<tablecell> 189<paragraph xml-lang="en-US" id="par_id3148705" role="tablecontent" l10n="U" oldref="104">user_company</paragraph> 190</tablecell> 191<tablecell> 192<paragraph xml-lang="en-US" id="par_id3148728" role="tablecontent" l10n="U" oldref="105">Company</paragraph> 193</tablecell> 194</tablerow> 195<tablerow> 196<tablecell> 197<paragraph xml-lang="en-US" id="par_id3155361" role="tablecontent" l10n="U" oldref="106">user_street</paragraph> 198</tablecell> 199<tablecell> 200<paragraph xml-lang="en-US" id="par_id3154222" role="tablecontent" l10n="U" oldref="107">Street</paragraph> 201</tablecell> 202</tablerow> 203<tablerow> 204<tablecell> 205<paragraph xml-lang="en-US" id="par_id3145108" role="tablecontent" l10n="U" oldref="108">user_country</paragraph> 206</tablecell> 207<tablecell> 208<paragraph xml-lang="en-US" id="par_id3146885" role="tablecontent" l10n="U" oldref="109">Country</paragraph> 209</tablecell> 210</tablerow> 211<tablerow> 212<tablecell> 213<paragraph xml-lang="en-US" id="par_id3149580" role="tablecontent" l10n="U" oldref="110">user_zipcode</paragraph> 214</tablecell> 215<tablecell> 216<paragraph xml-lang="en-US" id="par_id3156241" role="tablecontent" l10n="U" oldref="111">Zip code</paragraph> 217</tablecell> 218</tablerow> 219<tablerow> 220<tablecell> 221<paragraph xml-lang="en-US" id="par_id3148922" role="tablecontent" l10n="U" oldref="112">user_city</paragraph> 222</tablecell> 223<tablecell> 224<paragraph xml-lang="en-US" id="par_id3148945" role="tablecontent" l10n="U" oldref="113">City</paragraph> 225</tablecell> 226</tablerow> 227<tablerow> 228<tablecell> 229<paragraph xml-lang="en-US" id="par_id3156053" role="tablecontent" l10n="U" oldref="114">user_title</paragraph> 230</tablecell> 231<tablecell> 232<paragraph xml-lang="en-US" id="par_id3159219" role="tablecontent" l10n="U" oldref="115">Title</paragraph> 233</tablecell> 234</tablerow> 235<tablerow> 236<tablecell> 237<paragraph xml-lang="en-US" id="par_id3156435" role="tablecontent" l10n="U" oldref="116">user_position</paragraph> 238</tablecell> 239<tablecell> 240<paragraph xml-lang="en-US" id="par_id3145178" role="tablecontent" l10n="U" oldref="117">Position</paragraph> 241</tablecell> 242</tablerow> 243<tablerow> 244<tablecell> 245<paragraph xml-lang="en-US" id="par_id3150797" role="tablecontent" l10n="U" oldref="118">user_tel_work</paragraph> 246</tablecell> 247<tablecell> 248<paragraph xml-lang="en-US" id="par_id3150820" role="tablecontent" l10n="U" oldref="119">Business telephone number</paragraph> 249</tablecell> 250</tablerow> 251<tablerow> 252<tablecell> 253<paragraph xml-lang="en-US" id="par_id3150894" role="tablecontent" l10n="U" oldref="120">user_tel_home</paragraph> 254</tablecell> 255<tablecell> 256<paragraph xml-lang="en-US" id="par_id3155320" role="tablecontent" l10n="U" oldref="121">Home telephone number</paragraph> 257</tablecell> 258</tablerow> 259<tablerow> 260<tablecell> 261<paragraph xml-lang="en-US" id="par_id3154400" role="tablecontent" l10n="U" oldref="122">user_fax</paragraph> 262</tablecell> 263<tablecell> 264<paragraph xml-lang="en-US" id="par_id3153363" role="tablecontent" l10n="U" oldref="123">Fax number</paragraph> 265</tablecell> 266</tablerow> 267<tablerow> 268<tablecell> 269<paragraph xml-lang="en-US" id="par_id3153390" role="tablecontent" l10n="U" oldref="124">user_email</paragraph> 270</tablecell> 271<tablecell> 272<paragraph xml-lang="en-US" id="par_id3154948" role="tablecontent" l10n="U" oldref="125">E-mail address</paragraph> 273</tablecell> 274</tablerow> 275<tablerow> 276<tablecell> 277<paragraph xml-lang="en-US" id="par_id3145603" role="tablecontent" l10n="U" oldref="126">user_state</paragraph> 278</tablecell> 279<tablecell> 280<paragraph xml-lang="en-US" id="par_id3150129" role="tablecontent" l10n="U" oldref="127">State (not in all $[officename] versions)</paragraph> 281</tablecell> 282</tablerow> 283</table> 284<paragraph xml-lang="en-US" id="par_id3150147" role="paragraph" l10n="U" oldref="128">For example, to hide a paragraph, text, or a section from a user with a specific initial, such as "LM", enter the condition: user_initials=="LM".</paragraph> 285<paragraph xml-lang="en-US" id="hd_id3154115" role="heading" level="2" l10n="U" 286oldref="46">Conditions and Database Fields</paragraph> 287<paragraph xml-lang="en-US" id="par_id3154128" role="paragraph" l10n="U" oldref="47">You can define conditions for accessing databases, or database fields. For example, you can check the contents of a database field from a condition, or use database fields in logical expressions. The following table lists a few more examples of using databases in conditions:</paragraph> 288<table id="tbl_id3154848"> 289<tablerow> 290<tablecell> 291<paragraph xml-lang="en-US" id="par_id3156066" role="paragraph" l10n="U" oldref="132">Example</paragraph> 292</tablecell> 293<tablecell> 294<paragraph xml-lang="en-US" id="par_id3156088" role="paragraph" l10n="U" oldref="133">Meaning</paragraph> 295</tablecell> 296</tablerow> 297<tablerow> 298<tablecell> 299<paragraph xml-lang="en-US" id="par_id3155948" role="paragraph" l10n="U" oldref="48">Database.Table.Company</paragraph> 300<paragraph xml-lang="en-US" id="par_id3148673" role="paragraph" l10n="U" oldref="91">Database.Table.Company NEQ ""</paragraph> 301<paragraph xml-lang="en-US" id="par_id3148687" role="paragraph" l10n="U" oldref="92">Database.Table.Company != ""</paragraph> 302</tablecell> 303<tablecell> 304<paragraph xml-lang="en-US" id="par_id3155373" role="paragraph" l10n="U" oldref="49">The condition is true if the COMPANY field is not empty. (In the first example, no operator is required.)</paragraph> 305</tablecell> 306</tablerow> 307<tablerow> 308<tablecell> 309<paragraph xml-lang="en-US" id="par_id3149977" role="paragraph" l10n="U" oldref="7">!Database.Table.Company</paragraph> 310<paragraph xml-lang="en-US" id="par_id3149991" role="paragraph" l10n="U" oldref="129">NOT Database.Table.Company</paragraph> 311<paragraph xml-lang="en-US" id="par_id3150004" role="paragraph" l10n="U" oldref="50">Database.Table.Company EQ ""</paragraph> 312<paragraph xml-lang="en-US" id="par_id3146911" role="paragraph" l10n="U" oldref="9">Database.Table.Company ==""</paragraph> 313</tablecell> 314<tablecell> 315<paragraph xml-lang="en-US" id="par_id3148733" role="paragraph" l10n="U" oldref="8">Returns TRUE if the COMPANY field is empty.</paragraph> 316</tablecell> 317</tablerow> 318<tablerow> 319<tablecell> 320<paragraph xml-lang="en-US" id="par_id3148762" role="paragraph" l10n="U" oldref="5">Database.Table.Company !="Sun"</paragraph> 321<paragraph xml-lang="en-US" id="par_id3153016" role="paragraph" l10n="U" oldref="149">Database.Table.Company NEQ "Sun"</paragraph> 322</tablecell> 323<tablecell> 324<paragraph xml-lang="en-US" id="par_id3153040" role="paragraph" l10n="U" oldref="6">Returns TRUE if the current entry in the COMPANY field is not "Sun". (Exclamation sign represents a logical NOT.)</paragraph> 325</tablecell> 326</tablerow> 327<tablerow> 328<tablecell> 329<paragraph xml-lang="en-US" id="par_id3154605" role="paragraph" l10n="U" oldref="51">Database.Table.Firstname AND Database.Table.Name</paragraph> 330</tablecell> 331<tablecell> 332<paragraph xml-lang="en-US" id="par_id3153059" role="paragraph" l10n="U" oldref="52">Returns TRUE if the record contains the first and the last name.</paragraph> 333</tablecell> 334</tablerow> 335</table> 336<paragraph xml-lang="en-US" id="par_id3159247" role="note" l10n="U" oldref="53">Note the difference between the boolean NOT "!" and the comparative operator not equal "!=" (NEQ).</paragraph> 337<paragraph xml-lang="en-US" id="par_id3153876" role="paragraph" l10n="CHG" oldref="54">When you refer to a database field in a condition, use the form Databasename.Tablename.Fieldname. If one of the names contains a character that is an operator, such as a minus sign (-), enclose the name in square brackets, for example, Databasename.[Table-name].Fieldname. Never use spaces inside field names.<comment>UFI: fixes bug #i25781# - but see #i25983#. Fixes also #i19571#</comment></paragraph> 338<paragraph xml-lang="en-US" id="par_id3153891" role="heading" level="3" l10n="U" 339oldref="55">Example: Hiding an Empty Database Field</paragraph> 340<paragraph xml-lang="en-US" id="par_id3150051" role="paragraph" l10n="U" oldref="56">You may want to create a condition that hides an empty field, for example, if the COMPANY field is empty for some of the data records.</paragraph> 341<paragraph xml-lang="en-US" id="par_id3150067" role="paragraph" l10n="CHG" oldref="57">Select the <emph>Hidden Paragraph</emph> list entry, and type the following condition: Addressbook.Addresses.Company EQ ""</paragraph> 342<paragraph xml-lang="en-US" id="par_id3147110" role="paragraph" l10n="U" oldref="150">or type the following</paragraph> 343<paragraph xml-lang="en-US" id="par_id3147123" role="paragraph" l10n="U" oldref="151">NOT Addressbook.Addresses.Company</paragraph> 344<paragraph xml-lang="en-US" id="par_id3147136" role="paragraph" l10n="U" oldref="152">If the COMPANY database field is empty, the condition is true and the paragraph is hidden.</paragraph> 345<paragraph xml-lang="en-US" id="par_id3150232" role="note" l10n="CHG" oldref="58">To display hidden paragraphs on the screen, you can choose <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Writer - Formatting Aids</emph>, and clear the <emph>Fields: Hidden paragraphs</emph> check box.</paragraph> 346<paragraph xml-lang="en-US" id="hd_id3145218" role="heading" level="2" l10n="U" 347oldref="59">Examples of Conditions in Fields</paragraph> 348<paragraph xml-lang="en-US" id="par_id3145231" role="paragraph" l10n="U" oldref="60">The following examples use the Conditional text field, although they can be applied to any fields that can be linked to a condition. The syntax used for conditions is also used for the Hidden text, Hidden paragraph, Any record or Next record fields.</paragraph> 349<paragraph xml-lang="en-US" id="hd_id3150311" role="heading" level="2" l10n="U" 350oldref="61">To display conditional text based on the number of pages:</paragraph> 351<list type="ordered"> 352<listitem> 353<paragraph xml-lang="en-US" id="par_id3150333" role="listitem" l10n="U" oldref="136">Choose <emph>Insert - Fields - Other</emph>, and then click the <emph>Functions</emph> tab.</paragraph> 354</listitem> 355<listitem> 356<paragraph xml-lang="en-US" id="par_id3147471" role="listitem" l10n="U" oldref="62">In the <emph>Type</emph> list, click "Conditional text".</paragraph> 357</listitem> 358<listitem> 359<paragraph xml-lang="en-US" id="par_id3154294" role="listitem" l10n="U" oldref="63">In the <emph>Condition</emph> box, type "page == 1".</paragraph> 360</listitem> 361<listitem> 362<paragraph xml-lang="en-US" id="par_id3154319" role="listitem" l10n="U" oldref="64">In the <emph>Then</emph> box, type "There is only one page".</paragraph> 363</listitem> 364<listitem> 365<paragraph xml-lang="en-US" id="par_id3150640" role="listitem" l10n="U" oldref="65">In the <emph>Or</emph> box, type "There are several pages".</paragraph> 366</listitem> 367<listitem> 368<paragraph xml-lang="en-US" id="par_id3153086" role="listitem" l10n="U" oldref="137">Click <emph>Insert</emph>, and then click <emph>Close</emph>.</paragraph> 369</listitem> 370</list> 371<paragraph xml-lang="en-US" id="hd_id3155814" role="heading" level="2" l10n="U" 372oldref="67">To display conditional text based on a user-defined Variable</paragraph> 373<list type="ordered"> 374<listitem> 375<paragraph xml-lang="en-US" id="par_id3155836" role="listitem" l10n="U" oldref="138">Choose <emph>Insert - Fields - Other</emph>, and then click the <emph>Variables</emph> tab.</paragraph> 376</listitem> 377<listitem> 378<paragraph xml-lang="en-US" id="par_id3155109" role="listitem" l10n="U" oldref="68">In the <emph>Type</emph> list, click "Set Variable".</paragraph> 379</listitem> 380<listitem> 381<paragraph xml-lang="en-US" id="par_id3147008" role="listitem" l10n="U" oldref="139">In the <emph>Name</emph> box, type "Profit".</paragraph> 382</listitem> 383<listitem> 384<paragraph xml-lang="en-US" id="par_id3147032" role="listitem" l10n="U" oldref="140">In the <emph>Value</emph> box, type "5000".</paragraph> 385</listitem> 386<listitem> 387<paragraph xml-lang="en-US" id="par_id3152974" role="listitem" l10n="U" oldref="141">Click <emph>Insert</emph>.</paragraph> 388</listitem> 389<listitem> 390<paragraph xml-lang="en-US" id="par_id3152998" role="listitem" l10n="U" oldref="70">Click the <emph>Functions</emph> tab, and click "Conditional text" in the <emph>Type</emph> list.</paragraph> 391</listitem> 392<listitem> 393<paragraph xml-lang="en-US" id="par_id3150952" role="listitem" l10n="U" oldref="142">In the <emph>Condition</emph> box, type "Profit < 5000".</paragraph> 394</listitem> 395<listitem> 396<paragraph xml-lang="en-US" id="par_id3156291" role="listitem" l10n="U" oldref="71">In the <emph>Then</emph> box, type "Target is not met".</paragraph> 397</listitem> 398<listitem> 399<paragraph xml-lang="en-US" id="par_id3156317" role="listitem" l10n="U" oldref="72">In the <emph>Or</emph> box, type "Target is met".</paragraph> 400</listitem> 401<listitem> 402<paragraph xml-lang="en-US" id="par_id3154366" role="listitem" l10n="U" oldref="143">Click <emph>Insert</emph>.</paragraph> 403</listitem> 404</list> 405<paragraph xml-lang="en-US" id="par_id3154389" role="paragraph" l10n="U" oldref="73">To edit the contents of the "Profit" variable, double-click the variable field.</paragraph> 406<paragraph xml-lang="en-US" id="hd_id3155573" role="heading" level="2" l10n="U" 407oldref="74">To display conditional text based on the contents of a database field:</paragraph> 408<paragraph xml-lang="en-US" id="par_id3155587" role="paragraph" l10n="CHG" oldref="144">The first part of this example inserts a space between the "First Name" and "Last Name" fields in a document, and the second part inserts text based on the contents of a field. This example requires that an address data source is registered with $[officename].</paragraph> 409<list type="ordered"> 410<listitem> 411<paragraph xml-lang="en-US" id="par_id3150523" role="listitem" l10n="U" oldref="145">Choose <emph>Insert - Fields - Other</emph>, and then click the <emph>Database</emph> tab.</paragraph> 412</listitem> 413<listitem> 414<paragraph xml-lang="en-US" id="par_id3148811" role="listitem" l10n="U" oldref="75">In the <emph>Type</emph> list, click "Mail merge fields".</paragraph> 415</listitem> 416<listitem> 417<paragraph xml-lang="en-US" id="par_id3148841" role="listitem" l10n="U" oldref="76">In the <emph>Database selection</emph> box, double-click an address book, click "First Name", and then click <emph>Insert</emph>. Repeat for "Last Name".</paragraph> 418</listitem> 419<listitem> 420<paragraph xml-lang="en-US" id="par_id3147549" role="listitem" l10n="U" oldref="78">In the document, place the cursor between the two fields, press Space, and then return to the <emph>Fields</emph> dialog:</paragraph> 421</listitem> 422<listitem> 423<paragraph xml-lang="en-US" id="par_id3150416" role="listitem" l10n="U" oldref="79">Click the <emph>Functions</emph> tab, and then click "Conditional text" in the <emph>Type</emph> list.</paragraph> 424</listitem> 425<listitem> 426<paragraph xml-lang="en-US" id="par_id3153589" role="listitem" l10n="U" oldref="146">In the <emph>Condition</emph> box, type: "Addressbook.addresses.firstname".</paragraph> 427</listitem> 428<listitem> 429<paragraph xml-lang="en-US" id="par_id3153615" role="listitem" l10n="U" oldref="80">In the <emph>Then</emph> box, type a space and leave the <emph>Or</emph> box blank.</paragraph> 430</listitem> 431</list> 432<paragraph xml-lang="en-US" id="par_id3153562" role="paragraph" l10n="U" oldref="84">You can now use a condition to insert text based on the contents of the First Name field.</paragraph> 433<list type="ordered"> 434<listitem> 435<paragraph xml-lang="en-US" id="par_id3150574" role="listitem" l10n="U" oldref="147">In the <emph>Fields</emph> dialog, click the <emph>Functions</emph> tab.</paragraph> 436</listitem> 437<listitem> 438<paragraph xml-lang="en-US" id="par_id3150605" role="listitem" l10n="U" oldref="85">In the <emph>Type</emph> box, click "Conditional text".</paragraph> 439</listitem> 440<listitem> 441<paragraph xml-lang="en-US" id="par_id3151277" role="listitem" l10n="U" oldref="86">In the <emph>Condition</emph> box, type: Addressbook.addresses.firstname == "Michael"</paragraph> 442</listitem> 443<listitem> 444<paragraph xml-lang="en-US" id="par_id3151303" role="listitem" l10n="U" oldref="87">In the <emph>Then</emph> box, type "Dear".</paragraph> 445</listitem> 446<listitem> 447<paragraph xml-lang="en-US" id="par_id3149138" role="listitem" l10n="CHG" oldref="88">In the <emph>Else</emph> box, type "Hello".</paragraph> 448</listitem> 449<listitem> 450<paragraph xml-lang="en-US" id="par_id3149163" role="listitem" l10n="U" oldref="148">Click <emph>Insert</emph>.</paragraph> 451</listitem> 452</list> 453</body> 454</helpdocument> 455