HomeGuidesAPI
HomeGuidesRecipesAPI
HomeGuidesAPILog In

Variable

Suggest Edits

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.

PropertyDescription / Examples
Answer NameType in a unique name.
Document FormatOptions 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)
VariableSelect 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
FormulaDefines 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 DependenciesClicking this link will open a pop-up window that will show any dependencies that this label has.
554

👍

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 4 months ago