Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Text Functions

FillFields Function

Description:
Populates fields within text strings, which are inserted into the document from local or external lookup tables, with values from the answer set. This allows you to incorporate dynamic content into text strings stored in either a local lookup table or an external database.
Expressions embedded within inserted text strings must use FillFields function and be enclosed in curly brackets
{
 and
}
. Once the function is applied, the expressions are resolved and replaced with values based on the questionnaire answers. The functionality works in a similar way to active text, which dynamically inserts content into questions and guidance on the questionnaire. For more information, see What is active text.
This functionality is only available for fields. To add conditional logic to your dynamic inputs, use if-then-else expressions. For more information, see If-Then-Else Expression. Variables used within FillFields function expressions are not considered during relevance evaluation because their existence is only determined at execution time.
Returns:
Text
Parameters:
Parameter
Data Type
Description
1
Text
Select statement or a variable which evaluates to a text string containing the embedded expression in curly brackets.
Examples:
Expression
Result
FillFields(first(select Greeting from LocalisedGreetings)
where the first row in the Greeting column is “Ciao {Name}” and the Name variable is answered as “Ted”
Ciao Ted

This article applies to:

  • PRODUCT: Contract Express

Related Content