Use and Modify Data in Omniscripts

After an Omniscript retrieves data, it can then work with and transform, rename, or convert the data. You can use a Data Mapper Transform element, an Integration Procedure element, or a formula element. For example, if you have user input and data from an external source, you might need to combine data, remove duplicates, and put the data into a consistent format.

Use Omniscript formulas and functions to manipulate data directly in an Omniscript. They’re executed in real-time as a user interacts with an Omniscript, providing immediate feedback and results to users. Use them for simpler tasks, such as logical operations to make decisions based on data or arithmetic operations.

For more complex tasks, such as converting, restructuring, or renaming data, use a Data Mapper Transform. In cases where you need to modify or transform data from various sources or where the transformations are more complex, such as conditions or filtering, you might use an Integration Procedure with an Omniscript.

• Access Omniscript Data JSON with Merge Fields
  Enable Omniscript elements and element properties to access data JSON using merge fields. A merge field is a variable that references the value of a JSON node. For example, if a JSON node is "FirstName": "John", then the merge field %FirstName% returns John.
• Manipulate JSON with the Send/Response Transformations Properties
  Specify and transform the input and output JSON of Omniscripts or Integration Procedures with the Send and Response Transformation properties. The Send properties transform the input; the Response properties transform the output.
• Access to Data Within and Outside a Repeatable Block
  Suppose you place an element in a repeatable block (a Block or an Edit Block) and you want to access data that is calculated in a different element. The method that you use to access the data depends on whether the element containing the data is within or outside the same repeatable block in the Omniscript. Review guidelines and examples for the Formula element and for the Select element, which is used to add a dependent picklist to an Omniscript.