Variable
Overview
Variable questions provide a way to retrieve information from the user’s profile or calculate values from data collected in the question set.
The variable question requires you to specify a particular user profile field such as name, address line 1 or email, or to provide a formula to calculate a result. Formulas are not limited to numeric data as they can calculate dates and build strings. For more information see Formulas.
This question type is not visible to the end user in Produce, as it simply inserts a value into the generated document.
Preparation and Bookmarking
Insertion or selection bookmarks or tags can be used throughout the document to specify where the variable result is to be inserted.
Usage
How to create a variable question
1.From the toolbox, drag and drop a Variable question onto a page, section column or tab.
2. SmartIQ automatically adds an answer to the new question. Set the answer’s properties as below.
3. From the Placeholders tab, drag and drop the necessary bookmarks or tags onto the answer.
| Property | Description / Examples |
|---|---|
| Answer Name | Type in a unique name. |
| Document Format | Options are: Percent (PERCENT) Currency (C) General Number (G) Uppercase (+) Lowercase (-) Uppercase first letter (+-) Propercase (+-+-) Number to text (ONE) Number to text uppercase (+ONE) Number to text lowercase (-ONE) Currency to text (CUR) Currency to text (CUR USD) Currency to check text (CUR ZERO USD) Left Pad (LPAD '0'1) Left Pad (RPAD '0'1) Short Date (SHORT DATE) Long Date (LONG DATE) Left number of characters (LEFT 1) Right number of characters (RIGHT 1) Trim start or end spaces (TRIM) |
| Variable | Select which variable to use, which includes: [Formula] Creator User Profile Creator id Creator Name Creator Prefix Creator First Name Creator Last Name Creator Full Name Creator Salutation Creator Title Creator Organization Creator Phone Number Creator Fax Number Creator Email Address Creator Street Address 1 Creator Street Address 2 Creator Street Suburb Creator Street State Creator Street Postcode Creator Street Country Creator Postal Address 1 Creator Postal Address 2 Creator Postal Suburb Creator Postal State Creator Postal Postcode Creator Postal Country Logon User Profile User Id User Guid User Name User Prefix User First Name User Last Name User Full Name User Salutation User Title User Organization User Phone Number User Fax Number User Email Address User Street Address 1 User Street Address 2 User Street Suburb User Street State User Street Postcode User Street Country User Postal Address 1 User Postal Address 2 User Postal Suburb User Postal State User Postal Postcode User Postal Country User Language (Two Letter) User Language (Full) User Custom Others UTC Date UTC Time System Date System Time Date Time Run ID RowNumber RowCount State name Connected (True/False) MobileApp (True/False) ProduceURL First Open Date User Manager User Region Unique Identifier Published Project Guid Project Version |
| Formula | Defines a formula to calculate a result based on information in the question set. For example a calculated total, or calculated age based on the date of birth. Only applies if ‘[Formula]’ is selected in the Variable property. |
| Find Dependencies | Clicking this link will open a pop-up window that will show any dependencies that this label has. |
Best Practice
Variable questions can reference other SmartIQ questions within formulas. Whenever possible, questions should only refer to other questions which come earlier in the form structure. References to later questions (often called a "forward reference") may work but can also behave unreliably; for this reason forward references are not recommended.
Variable 'Connected'
- returns "True" when the form is in a connected state and "False" when it is not
- will only apply after a PostBack has occurred
Updated 11 months ago